Hello,
I'm currently trying to list records from a CDS Entity into Excel by using Flow.
I have created the flow and managed to run it successfully.
Unfortunately the data is displayed in a weird format (I believe it is base36?)
Please could somebody advise on how I am able to convert this data to simple strings?
Solved! Go to Solution.
Hi @Anonymous
In your excel mapping you have couple of mappings here.
So to get the Modified By you need the following:
In your flow add the below step above Add rows to excel
Next you can add a compose to get the full name or directly add the mapping under excel rows action.
Follow the similar steps for Created By. For other Id's (Guids) you need to find which entity (Above steps for modified by or created by its Users entity) they are and follow the same steps.
If you need any further help please let me know.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @Anonymous
It's the Id (GUID) you are getting. This is by design. To get the actual text value (name) you need to use Get Items and pass the Id.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @Anonymous,
If you want to get the person column information, such as Owner, Created By, Modified By, you can use the Get user action of Azure AD connector by using the Code:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @abm ,
Thank you very much for your reply.
I'm quite new to Microsoft Flow, would it please be possible for you to show me an example?
I don't really know how to set the identifier?
Hi @Anonymous
Thanks for your reply. Will send you something soon.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @Anonymous
In your excel mapping you have couple of mappings here.
So to get the Modified By you need the following:
In your flow add the below step above Add rows to excel
Next you can add a compose to get the full name or directly add the mapping under excel rows action.
Follow the similar steps for Created By. For other Id's (Guids) you need to find which entity (Above steps for modified by or created by its Users entity) they are and follow the same steps.
If you need any further help please let me know.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials@Anonymous
With the latest update of Common Data Service (current environment) connector, you can now query the formatted values of supported field types such as lookup display name, option set value label, formatted date/time by using the OData.Community.Display.V1.FormattedValue property of the field in the expression.
https://linnzawwin.blogspot.com/2020/07/get-lookup-display-name-and-option-set.html
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
39 | |
36 | |
34 | |
32 | |
27 |
User | Count |
---|---|
44 | |
36 | |
33 | |
25 | |
22 |