PowerApps+Flow logo

Import XML to PowerApps

When preparing for a new project, I started to check whether different customer expectations are feasible with PowerApps. The first of these is the ability to use an XML file as input, to build a table in the application and possibly to save them to SQL later.

Nothing simpler, I thought. Finally, there is an “Attachment” control in PowerApps. And if not, there’s definitely some other one that I can use.

I learned on this occasion that the “Attachment” control is dedicated to forms linked to SharePoint lists and it is not possible to put it in the application “just as-is”. But there is another one that is called “Add picture” – although the name suggests using it only for adding image, it has a much more versatile usage purposes.

How to upload file to application?

Couple of words about the control to add an image. It is in the “Media” group:

"Add picture" control in PowerApps
“Add picture” control

Although it actually suggests, also after placing it on canvas, that it is only for uploading photos, the key phrase from the description is “Let users upload image through your app”. And if it allows uploading photos, then probably other file formats, right?

When you select it in the application, a group consisting of two controls is added. One is “AddMediaButton“, the other is just a control displaying the image. I was solely interested in this first one, which is why I removed the second one:

AddMediaButton in PowerApps

The control works in the following way

  1. User clicks it
  2. A Window Explorer pops-up allowing you to select “Images” or “All files” (luckily!)
  3. User selects a file
  4. File is uploaded to the application and stored in local blob storage.

In my scenario, I’ve added validation so that only XML files can be added. For the “OnChange” event of the control to select files, I added a piece of code:

    EndsWith(FileUpload.FileName, ".xml"), 

So, if the file extension does not end with “xml“, then an error is shown and the upload button is disabled.

How to handle uploaded file?

Here, Microsoft Flow naturally enters the game. However, in order to send a file to the flow, it is not enough to simply use “FileUpload.Media“, because the file’s data is in local blob and this expression in no way matches the contents of the file, but returns its address:, e.g.: appres://blobmanager/jakisGUID

To send such a file to Flow, you need to use the Azure Blob Storage support and the method described in my post for placing a manual signature on the document:

  1. upload file to Azure Blob Storage
  2. call Flow passing URL of the uploaded file
  3. read file from Blob by Flow.

Microsoft Flow

Then the application must run Flow, passing the file’s address linking to the blob. Then Flow downloads the file and in my case, converts its content to JSON using the “Parse JSON” action, but first deleting the line that defines it as XML:

Getting file from Azure Blob Storage and converting its contents to JSON
Downloading file from Azure Blob Storage and transformation to JSON

Using the below expression:

json(xml(replace(body('GetFileFromBlob'), '<?xml version="1.0" encoding="UTF-8"?>', '')))

Of course before parsing the XML to JSON you need to know its schema, so the best approach would be to first discover how your converted XML to JSON is going to look like and then use it as an example to generate schema.

I chose this approach because the use of xpath to read a file has a disadvantage – it creates a list. Finally, to return such a list to PowerApps it should be converted to JSON format. And in addition, if it has more than 5k elements, the loop rev limit should be additionally handled.

Current Flow limitations allow the loop to make max. 5.000 rounds. 100,000 in premium plans.

And that’s basically everything. Having such an object, in which records are repeating , I can return them to PowerApps. Importantly, to return these records the standard action “Respond to PowerApps” is not enough, it is necessary to use the action “HTTP response” to transfer the data preserving the JSON format.

However, I do not return the entire contents of the file, but only the content from one of the attributes, which in my case is a table:

PowerApps response
Response to PowerApps

How does it work?

Above all – quickly. The complete expression under the data import button looks like below:

ClearCollect(xml, ParseXMLFile.Run("/files/" & FileUpload.FileName))
PowerApp importing 500 and 5000 records from XML
PowerApp importing 500 and 5000 records from XML

The XML file has below format:

XML file being imported
XML który jest importowany

Static vs. dynamic

Actually, using this XML file and xpath you could make this solution a bit more dynamic. In described scenario Flow needs to know the JSON schema in order to be able to process XML data properly.

However, you can prepare your own mechanism running as SaaS, which receives JSON code and returns a schema for it, which is then used in the flow.

You can also define a dictionary for XML schemas that you decide to import into the application and based on the user’s choice, simply send a parameter enabling Flow to download the appropriate schema.

I hope that the solution described will be helpful for you. If you liked the article, leave a comment!

Tomasz Poszytek

Hi, I am Tomasz. I am expert in the field of process automation and business solutions' building using Power Platform. I am Microsoft MVP and Nintex vTE.

  • Rob

    Hi Tomasz,

    Thank you for this blog post. It looks very promising!

    I’ve been looking for a way to convert XML to JSON in Flow for a few days now and found your post. I just cant replicate what you’ve done. For example, I can’t find the “Convert XML to JSON” Data Operations action. Have you maybe renamed the action? If so, what action did you use and what expression?

    Can you please add some more steps to the describe what you have done an what actions you’ve used?

    Thanks a lot!


    August 14, 2019 at 9:51 pm Reply
    • Tomasz Poszytek

      Hi! I am using the “Parse JSON” action with an expression: json(xml(replace(body(‘GetFileFromBlob’), ‘‘, ”))) – I updated post for you a little. Before I am able to use the parse action I need to know the schema of the json code, so I manually transformed XML to JSON and then used that JSON as an example to generate schema. I hope it helps 😉

      August 18, 2019 at 6:40 pm Reply
      • Robert

        Hi Tomasz,

        Thanks a lot! I got all the Flow parts working, just not the PowerApp parts. I’ll look into that a bit later.

        Sidenote; I think there is a typo in your first expression. It says IIf, with double I.

        Thanks again!

        August 21, 2019 at 6:47 pm Reply

    Is there also a way to create an xml file from either a Collection or Excel Worksheet and use that file as a “GET” request to a web service call and then bring the Data.”POST” Back into a Collection or excel worksheet ?
    David Powell

    October 21, 2020 at 3:05 pm Reply
    • Tomasz Poszytek

      No oob function, like “convertToXML” 🙂 But sure, you can try to write expression in Power Apps to somehow build XML from your data, or try to use Power Automate for that.

      October 22, 2020 at 11:18 am Reply
  • Gustavo

    Hello, could you make a post on how to handle dynamic xml / json?

    May 27, 2021 at 6:22 pm Reply
    • Tomasz Poszytek

      It is difficult to handle dynamic XML/ JSON in Power Apps, since there is no OOB “parseJSON” function. Maybe you could do that with Power Apps Components Framework?

      June 2, 2021 at 1:05 pm Reply

Post a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.