We are generating certificate-related information from SharePoint servers and sending the information via email.
We then want to parse the content of the email and create a new list item in a SharePoint list.
We can generate the email from the servers in many ways (body, text file attachment, json etc.)
What would be the best way to create a Flow as easy as possible, that is able to parse the email content and create a list item in SharePoint?
Personally, I think JSON is your best bet. Flow has actions that can be used to parse JSON and make the individual fields availabel to the Flow. This would make it much easier to then save them in a list.
Hi @mikkele ,
I agree with Pstork1 that if the content in the email body is JSON data, it is more convenient to use Flow to process the data.
You may need to use HTML to text to convert the email body to plain text, and then parse the output from the previous step using Parse JSON action.
Please take try and feel free let us know if you need further assistance.
I ended up generating the email attachment file in JSON format and parse it using Parse JSON action.
Only trick was that I had to "jasonify" the attachment using Fx Json ( )
It seems that you have found the proper workaround and solved your problem.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.