cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Using flow to list records from Common Data Services

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.

 

test.PNG

 

 

Unfortunately the data is displayed in a weird format (I believe it is base36?)

 

test2.PNG

Please could somebody advise on how I am able to convert this data to simple strings?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Using flow to list records from Common Data Services

Hi @DavidGorgan 

 

In your excel mapping you have couple of mappings here.

 

image.png

 

So to get the Modified By you need the following:

 

In your flow add the below step above Add rows to excel 

 

image.png

Next  you can add a compose to get the full name or directly add the mapping under excel rows action.

image.png

 

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.

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

7 REPLIES 7
Highlighted
Super User III
Super User III

Re: Using flow to list records from Common Data Services

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.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Community Support
Community Support

Re: Using flow to list records from Common Data Services

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:

Annotation 2020-01-13 153606.png

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.

Highlighted
Frequent Visitor

Re: Using flow to list records from Common Data Services

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?

Highlighted
Super User III
Super User III

Re: Using flow to list records from Common Data Services

Hi @DavidGorgan 

 

Thanks for your reply. Will send you something soon.

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Super User III
Super User III

Re: Using flow to list records from Common Data Services

Hi @DavidGorgan 

 

In your excel mapping you have couple of mappings here.

 

image.png

 

So to get the Modified By you need the following:

 

In your flow add the below step above Add rows to excel 

 

image.png

Next  you can add a compose to get the full name or directly add the mapping under excel rows action.

image.png

 

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.

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
Frequent Visitor

Re: Using flow to list records from Common Data Services

@abm,

 

You are a STAR!

 

Thank you very much!

Highlighted
Kudo Collector
Kudo Collector

Re: Using flow to list records from Common Data Services

@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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (7,192)