Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

CRM Dynamics Online - Owner name not ID ?

(0) ShareShare
ReportReport
Posted on by 252

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

Categories:
  • HenryKnoop Profile Picture
    4 on at
    Re: CRM Dynamics Online - Owner name not ID ?

    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

  • Community Power Platform Member Profile Picture
    on at
    Re: CRM Dynamics Online - Owner name not ID ?

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

  • OlliillO Profile Picture
    4 on at
    Re: CRM Dynamics Online - Owner name not ID ?

    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

  • Rfla Profile Picture
    252 on at
    Re: CRM Dynamics Online - Owner name not ID ?

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

  • Verified answer
    michowl Profile Picture
    Microsoft Employee on at
    Re: CRM Dynamics Online - Owner name not ID ?

    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.

  • Rfla Profile Picture
    252 on at
    Re: CRM Dynamics Online - Owner name not ID ?

    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 😛

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow