cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SimonHoy
Level: Power Up

Working with Dynamics 365 Lookup fields

Hi All,

 

I am a noob in flow so hopefully the answer to this one is fairly straight forward?

 

I have created a flow that pulls data from dynamics365 and sends a weekly email showing a list of won opportunities in a html table.

 

One of the issues i'm having is how to acess the values of lookup fields and not the underlying ID's they refer to. e.g instead of Owner = "John Smith" I get the underlying ID value.

 

I have searched forums and websites looking for an answer but unfortunately am yet to find anything to guide me to the function or approach that would help me achieve this.

 

I have enclosed a screenshot of the flow and example output.

 

Please let me know if there is anything further I can add that would help.

 

Flow

Flow1.PNG

 

Output

Flow1output.PNG

 

 

Kind Regards

Simon

2 REPLIES 2
Community Support Team
Community Support Team

Re: Working with Dynamics 365 Lookup fields

Hi @SimonHoy,

 

Does the Owner column is the lookup field that you mentioned?

Do you want to get the Owner = name "John Smith" instead of person ID in the html table?

 

If you want to get the Owner = name "John Smith" instead of person ID in the html table,please replace the value in the Owner with the name.And I afraid that there is no any other way to achieve your needs.

 

 

Best regards,

Alice

 

 

Frantisek
Level: Powered On

Re: Working with Dynamics 365 Lookup fields

Is there any update on following? Am trying to achieve the same - simple HTML table (list of records) with data from one entity with Owner ID translated to name from User entity. Any help is more then welcome.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 203 members 5,735 guests
Please welcome our newest community members: