cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rfla
Kudo Kingpin
Kudo Kingpin

CRM Dynamics Online - Owner name not ID ?

Fields giving ID and not Title/name. Same goes for other lookups.
Is it possible to use the same syntax as in advanced condition in a send email body (html=true). Example: ['owner.title'] ?
If not is the title/name something that is in the pipeline?
Or is it possible to do this with oData query filter?
https://powerusers.microsoft.com/t5/Flow-Forum/Dynamics-CRM-Connector-ODATA-Filters/m-p/5265#M1164
https://powerusers.microsoft.com/t5/Flow-Forum/How-do-I-get-current-account-item-email-address-from-...

1 ACCEPTED SOLUTION

Accepted Solutions

use a get record action in between with the field id to look up the record you want, then get the text from that record.

ex.

 

1. new Lead Triggers flow

2. Get Record from Users Entity using Lead Owner 

3. Use FName/LName from User record in future actions.

View solution in original post

6 REPLIES 6
Rfla
Kudo Kingpin
Kudo Kingpin

Found a workaround afer having some lunch 🙂
I can of course create a "hidden field" in CRM that copies the lookup "text" value to a new custom field on the form, and use that one in the flow.

But off course that is not optimal. Create a flow in CRM to use a flow in flow 😛

use a get record action in between with the field id to look up the record you want, then get the text from that record.

ex.

 

1. new Lead Triggers flow

2. Get Record from Users Entity using Lead Owner 

3. Use FName/LName from User record in future actions.

View solution in original post

Great thanks, some basic functions that I did not know off 🙂

OlliillO
New Member

I am facing the same issue but cannot get this going. Can you please explain in more detail what has to be set up in the flow? In my case it is desired to have the owner of a visit report shown in microsoft teams when the record has been created. This shall be realized via flow. It is easy to realize this with the ID but I am struggling with the "transformation" of the ID to the corresponding First and Last Name of the user who created the visit report instead of his / her ID in flow.

 

Any help would be very much appreciated! Thanks a million 🙂

 

Best regards,

 

Olli

I'm still trying to understand this too.  Does anyone have an example of a solution

Underneath is a way to e.g. add the account name to the description field of the opportunity. The id is added to the "klant"field in sharepoint

Name not idName not id

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,946)