Working with XML in Power Automate Flow

[@KlugIngo]

Es kann so einfach sein, wenn man weiß, wie es geht. Hier wird es leicht verständlich gezeigt ohne viel Schnickschnack direkt auf den Punkt. Dieses Video hat mir viel aufwendige Recherche erspart. Vielen lieben Dank dafür ! ! !

[@station2040]

Hi Deepak, I just wanted to tell you that I think your content is superb! I will be liking and following your channel now! Please keep up the excellent work. You are a fantastic content creator & I use your tutorials all of the time. Thank you for the time and effort you put into these tutorials. Also, please don't stop! What a wealth of knowledge you have!!

[@garcialex06]

You are so genius!!! Thanks a lot for this video. You have helped me a lot. I was stucked with xpath and so, but I never figured out that JSON was the key to extract the info I needed. Many many thanks

[@vigneshbabu5274]

Very Informative Video. Thanks Deepak

[@DeepakShrivastava]

Thanks and welcome

[@poormong2178]

This is what I'm looking for, thank you Deepak.

[@DeepakShrivastava]

Most welcome!

[@mikemarzano4958]

is there a size limit for the XML file? When I try to follow this process, the output from XML(compose= xml(outputs('Get_file_content')?['body']) gives me a bunch of junk, not the XML.. IF i trim the XML down to the first 5 entries, it works fine. The XML is 13.5Meg file. How do I work with that?

[@selwyndacosta1748]

At 12:14, how did you get from the previous screen to Create Item, to Apply to Each and select Order. That part was not very clear. Can you help?

[@sueamin2788]

This is exactly what I needed! Thank you Deepak!

[@DeepakShrivastava]

My pleasure 😊Thank you for watching!!

[@alfonsolans]

Great Job Deepak this is awesome work, keep rocking Buddy, great explanation and very dedicated details

[@DeepakShrivastava]

Thank you very much 👍🏻👍🏻

[@martinskalva8808]

Great content! Thank you! 👌

[@francescjuliana888]

Great video. Thank you for your great tutorial. It help me a lot.

[@thehammernasty5376]

Thanks for that i just want to know can we delete node for example you have 10 node i wanna delete the delete one or two node by search with XPATH ?

[@DeepakShrivastava]

I am not sure if we can.

[@jcerbaro]

Thank you very very much!

[@HPTeguh]

Awesome!!!

[@jimrobertson7991]

Great video but I am hung up on the parse JSON, it does not allow me to generate from sample. Any suggestions would be greatly appriciated.

[@DeepakShrivastava]

Thanks for watching. I may need to get more details to help you, i would suggest to post your question to Power automate community powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

[@jonscoresby7530]

Thank you for this video. I'm trying to convert my xml file to a .xlsx file on with specific columns. Specifically, as an xml file is added to the sharepoint page, a new .xlsx will automatically be created based on the data from the xml file. Do you have suggestions on how I can alter your instructions in the video to create this automation?

[@sueamin2788]

Hi Deepak: I have XML File coming into my SP library. Most of the times it has 30 -200 records, however every now and then my XML file has only one record, which makes FLOW (based on the technique shown in the above video) fails. Because the Details property is an Array in the Parse JSON step. How do I deal with this situation? Any suggestion is appreciated. Thank you.

[@DeepakShrivastava]

You can add a condition to check the how many records and based on that you can continue

[@santoshkamala2750]

Hey Deepak, very interesting. Can you something which convert excel to XML format ?

[@DeepakShrivastava]

I need to check , i believe you should be able to do it with some logic.

[@Yuthika2805]

Have you got the solution

[@santoshkamala2750]

@@Yuthika2805 not yet. Do you have some solution ?

[@rohitmetya5002]

Hey there, is there a solution for this now?

[@Almazees]

Awsome!

[@DeepakShrivastava]

Thanks 🙏🏻

[@qaisnaderi6336]

hello deepak hope your doing well thank you so much for this good video and i have a problem with parse json . the problem is . i have an xml file wich is online order and thats all with objects not array and i saved an xml file with one order and thats working normally but when there is an order with morethan 1 order then the pare json is not accepting it its not recognizing it ? so any suggestion will be appriciable from you thank you in advance

[@josuecontreras7931]

Hi!! How can you work with multiple XML that have different structures, but the fields that you want to extract from them are all call the same?

[@stephanebouillon2538]

Hi Deepak, can you share how to apply an xslt transformation on on XML in power automate ?

[@DeepakShrivastava]

I will give a try on Xslt to Json or Xslt to XML parsing using power automate, it should work but have not tried yet.

[@stephanebouillon2538]

Thanks, my requirement - a typical edi scenario - is to transform / restructure an inbound xml file into another outbound xml file where nodes are reordered/consolidated.

[@DeepakShrivastava]

I like the Idea i will add this to in my future video list. thanks for suggestion.

[@fbeauvais6419]

Great stuff! How can we update the list thereafter (and not creat another element each time)?

[@cesarsilva7099]

Ótimo Conteudo. Teria como fazer um video de um fluxo da conta de GMAIL , Tratar e armazenar no ondrive pessoal?

[@cesarsilva7099]

Desculpe email do outlook

[@DeepakShrivastava]

Muito obrigado. Vou criar um vídeo sobre este tema.

[@anjaliroy1976]

How to do xml to xml transformation using power automate , we send xml request through postman and then perform some data operations so that we can map the values from old to new xml and send as a response

[@anthonyaltman4021]

Deepak, i follow your video, i check the xml structure and all seems similar - i have groups Orders and but when i get to parse json i get errors "message": "Invalid type. Expected Array but got Object.", at line 0

[@DeepakShrivastava]

Thanks for watching. To assist you, I may require more information. Could you please post your question at power automate forum and tag me (@deepak_s22). powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

[@adrianojnn]

Excelent! How can I visualize a xml file in Power Apps? I need to compare the informations between the file and a item list that was registered in a sharepoint list.

[@pragu8939]

Is there any way to get the owners email address of SharePoint sites and also each subsites in power automate

[@DeepakShrivastava]

yes you can get it using REST api - "/_api/web/webs/?$select=title,ServerRelativeUrl"

[@pragu8939]

Hi Deepak, thank you for the valuable response.This Uri is giving the each subsites name with the Url but I also want the owners name of each subsites. What will be Uri for this, like what we can add to get owners details for each subsites

[@mwilliams11221]

ThIs tutorial is great. Very well and detailed explaination.. loved it... Even beginner like me was able to understand. Thank you very much!! Is it possible to parse the xml to a .csv or .txt file on the same SharePoint library where the xml file is uploaded. I am looking for xml conversion using power automate but not as a SharePoint list but as a file with .csv or .txt format.

[@DeepakShrivastava]

You're very welcome! Thanks for watching. You should be able to create CSV file from XML data and use the "create file" action to save the file to SharePoint.

[@Yuthika2805]

Hi Deepak, I have a query, please give me some suggestions on whether this will work out or not. My query is, I have an attachment in the SharePoint list as an excel file, I want to extract the data from excel and update the data in the existing XML file which was located in BOX. is there any way I can do this like. Anyone please suggest me.

[@alexisfigueroaAFC]

Hello. Your video is very good. I am making a solution like this. Objective: to give xml format to a list. That is, contrary to what you explained.

[@walfreddeb9176]

hello Deepak, how can i apply this on multiple XML files?

[@matthiasjensenpuchta3542]

Cool and very interesting video, but I can see when i add a XFDF file which is also some kind of XML then it does not show the final values and names, so I can easily add it to a sharepoint list. { "body": { "?xml": { "@version": "1.0", "@encoding": "UTF-8" }, "xfdf": { "fields": { "field": [ { "@name": "Technischer Zustand einsatzbereit", "value": "False" },

[@alfonsolans]

Deepak Quick question and thansk for your help, the flow is working great but sometimes with specific XML's I go tthe following message with errors [ { "message": "Invalid type. Expected Object but got Array.", "lineNumber": 0, "linePosition": 0, "path": "cfdi:Comprobante.cfdi:Conceptos.cfdi:Concepto", "schemaId": "#/properties/cfdi:Comprobante/properties/cfdi:Conceptos/properties/cfdi:Concepto", "errorType": "type", "childErrors": [] } ] Any help would be greatly appreciate it Buddy, Keep Rocking

[@DeepakShrivastava]

Thanks for watching. I believe this is because XML that you getting is not consistent. you can add a action on error and process it as an array.

[@MuhammadAdnan2.0]

Bhai... Will u please start basics to advance flow or power apps step by step for beginners series... ?

[@DeepakShrivastava]

I will very soon.

[@MuhammadAdnan2.0]

@@DeepakShrivastava thnx