Using flow to list records from Common Data Services

[DavidGorgan]

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?

[abm]

Hi @DavidGorgan 

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.

[v-litu-msft]

Hi @DavidGorgan,

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.

[DavidGorgan]

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?

[abm]

Hi @DavidGorgan 

Thanks for your reply. Will send you something soon.

[abm · Accepted solution]

Hi @DavidGorgan 

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.

[DavidGorgan]

@abm,

You are a STAR!

Thank you very much!

[LinnZawWin]

@DavidGorgan 

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