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-salesforce/td-p/1360/page/2
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 id
I'm still trying to understand this too. Does anyone have an example of a solution
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
Great thanks, some basic functions that I did not know off 🙂
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.
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 😛
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional