Hi Alliant-Logan, was wondering if you ever get a response for this? Facing the same issue
Thank you
I'm very new at Power automate, but I'm looking for the same thing that Alliant-Logan is looking for. When I get new mail in Outlook, I wish the parse the XML attachment and create a SharePoint list item. Thank you in advance for any help.
Would anyone know how we extract xml data from an email attachment .xml file rather than the xml data being in the body of the email
Hi @RajuGolla ,
If the XML data is included in the email body, then you may need to use WDL function to extract the data, preferably the email message has a fixed format.
Please refer to the similar thread below to extract the data specified in the email body:
https://powerusers.microsoft.com/t5/Building-Flows/Extracting-text-from-email/td-p/334919
After extracting the XML data, you need to use the XPath() function to parse it. Please refer to the following threads and see if it helps:
https://powerusers.microsoft.com/t5/Connecting-To-Data/xPath-parsing-noob/td-p/345459
Once parsed, you can insert data into the specified field based on the properties.
If your email body has a fixed format, you can provide us with sample data so that we could provide the appropriate workaround.
Best Regards,
WarrenBelz
146,771
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional