cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mikkele
Level: Powered On

Best way to extract data from email

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?

5 REPLIES 5
Dual Super User
Dual Super User

Re: Best way to extract data from email

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
mikkele
Level: Powered On

Re: Best way to extract data from email

"Dealing with JSON in Microsoft Flow is fun – if you’re a masochist."

https://spmaestro.com/handling-json-in-microsoft-flow/

Community Support Team
Community Support Team

Re: Best way to extract data from email

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.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mikkele
Level: Powered On

Re: Best way to extract data from email

Thanks

 

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 ( )

Community Support Team
Community Support Team

Re: Best way to extract data from email

It seems that you have found the proper workaround and solved your problem.

Great!

 

 

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,114)