Using flow to list records from Common Data Services

(1) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @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.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Thanks for your reply. Will send you something soon.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@abm,

You are a STAR!

Thank you very much!

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report

@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

Was this reply helpful? Yes No