I am new to Flow and Odata, I hope the community and support can provide me some help and guidance:
I have this Flow that checks an Azure table and returns the OData feed if there is a new record added to the table.
And the Flow will trigger an email notification sent to users in the following Odata format. What we actually need is only the "CustomerInfo" column which seems to combine all customer info and store in just one field:
Is there a function or a way in Flow to turn this email message with OData format to a more readable format, eg:
Thank you in advance,
Hi @Jimmy1 ，
Could you please share a screenshot of the configuration of your flow?
Could you please share the full content in the Body field of the "Send an email" action?
Please share more details so we would try to provide a proper workaround for you.
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You may please refer to my other post which should have all the steps in my flow. The flow itself is working as expected.
What I want is to improve the content returned from the Odata feed. It's not that user-friendly so I would like to have some hints on if it's possible to use Flow to make it more readable:
Below is the details in the "Send an email" action.
For example, the message below is generated and sent in the email action. It returns right information but in a messy format. The customer information, such as First name, Last name, email, phone, etc. is all merged in one "CustomerInfo" tag in this Odata feed. Can Flow help break it down using some delimiter function?
Hi @Jimmy1 ,
After Get entities add a flow step Apply each. Then add a compose within the loop. You should be getting the current item members here.
Try this and let me know.
Thanks for the hint. I modified the Flow and added an "Apply to each" action and a "Compose" action within the "Apply to each" function.
In my test, there are three records returned in Odata format in the "Get entities" step. Output as following:
May I ask for some further hint on what functions I should use in order to get the format I want? Technically, I just want to take the following "CustomerInfo" portion from each record:
And turn it into a more readable format like:
FirstName: Daniel, LastName: M, Email:email@example.com, Phone: 1-xxx-xxx-xxxx, Country: Canada, Company:xxx, Title:;
FirstName: Dane, LastName: K, Email:firstname.lastname@example.org, Phone: 1-xxx-xxx-xxxx, Country: US, Company:yyy, Title: Sales;
FirstName: Adatum, LastName: Corp, Email: email@example.com, Phone: 1-xxx-xxx-xxxx, Country: Canada, Company:www, Title: eg;
Or a table format:
FirstName LastName Email Phone Country Company Title
Daniel, M, firstname.lastname@example.org, 1-xxx-xxx-xxxx, Canada, xxx
Dane, K, email@example.com, 1-xxx-xxx-xxxx, US, yyy Sales;
Adatum, Corp, firstname.lastname@example.org, 1-xxx-xxx-xxxx, Canada, www, eg;
Thank you in advance,
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!