Solved: Re: Convert Email text body to JSON

neo54n4 · ‎06-17-2020

Hello everyone,

I tried to convert the Email body from HTML to Text and I got one step ahead, but now my questing is how can I convert this text to json

Email body:

Client: Name Surname
Category: Category Name
Date: 15.06.2020 20:57:46

Thnx,

v-bacao-msft · ‎06-18-2020

Hi @neo54n4 ,

If the fields in the email body are fixed, then you can refer to the following thread to extract the field value first, and then configure the extracted data corresponding to the field name in JSON.

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-text-from-email/td-p/334919

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.

View solution in original post

v-bacao-msft · ‎06-18-2020

Hi @neo54n4 ,

If the fields in the email body are fixed, then you can refer to the following thread to extract the field value first, and then configure the extracted data corresponding to the field name in JSON.

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-text-from-email/td-p/334919

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.

Convert Email text body to JSON

Helpful resources

Join us for Microsoft Power Platform Conference

A new place to submit your Ideas for Power Automate

Register for a Free Workshop

Ask your licensing questions at the Power Automate AMA!