Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Get Account Name instead of Account GUID from Dynamics 365

(0) ShareShare
ReportReport
Posted on by 41

Hi, 

I am new to flow, i am scheduling an email using flow regarding Opportunities in Dynamics 365, i successfully ran the flow but having a problem, it is showing the guid of account related to opportunity instead of account name. Can someone help me how i can display the name of account instead account guid in email body? Any help would be highly appreciable.

Thanks.

  • saianugrah Profile Picture
    saianugrah on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Get the user email address instead of account from GUID
     Use the below in the filter query :
    systemuserid eq  'User' 

    Here USER must be dynamic content from previous action cards which will be giving you a GUID as output.
    Once you give this you will be able to get the email id of the owner associated with the record 

    and in the email or compose action you will need to use Primary email id as dynamic content to fetch the user email address 

    saianugrah_0-1597679725994.png

     

  • clubinski Profile Picture
    clubinski 92 on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    How would I get the Accounts to display on an HTML report that is emailed weekly?

     

     

     

  • Re: Get Account Name instead of Account GUID from Dynamics 365

    Hi @WaleedBinAfzal  i tried all this day to do this with two actions. But nothing works. It is possible that you send your solution to this forum. Thanks al lot ! Markus 

  • RobinA Profile Picture
    RobinA 8 on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Yes, I was trying to do this on a html template as well so if anyone has an answer here it would be appreciated.  Surely MS you would consider just resolving this and stop showing the GUID and put the name!

  • Frantisek Profile Picture
    Frantisek 11 on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Hi am having same issue. What am trying to do is simple HTML table with list of records from one entity where Owner field is translated from ID to Full name thru Users entity. I tried the mentioned steps but no luck with list of records as it does a copy for each user. Anybody can help? Thank you

  • Nhegde Profile Picture
    Nhegde 2 on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Hi , I am facing a similar issue . I have created a gallery from the Opportunities entity , and want to view the Account associated . I have created a lookup of account under the "Default" option of the Gallery as shown,but the GUID is still visible .Kindly help.ss2.PNGss1.PNG

  • waleedbinafzal Profile Picture
    waleedbinafzal 41 on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Thanks @v-yamao-msft,

    I used two actions, one for account and one for opportunity and then in send an email action i get all the options that i need from opportunity and account.

    Thanks alot.

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Hi @WaleedBinAfzal,

     

    Please take the following flow configuration for a reference.

     

    The flow is triggered by When a record is created in Opportunities.

     

    Followed by the action Get record. At here, please select Accounts for the Entity Name field, and for the Item identifier field, select dynamic content Account from the trigger.

     

    Note: There is no Account Name dynamic content from the trigger When a record is created in Opportunities.

     

    Then the action Send an email. In the Body field, select the Account name from the previous action Get record.

     

    1.PNG

    2.PNG

     

    I have tested it on my side and it works fine.

     

     

    Best regards,

    Mabel Mao

  • bhanuprathap121 Profile Picture
    bhanuprathap121 2 on at
    Re: Get Account Name instead of Account GUID from Dynamics 365

    Hi,

     

    I don't think there is a way to get the relative entity data directly in flow. But I can recommend you adding a new step to fetch the account data as you have the GUID. And then use the name in the further steps.

     

    Let me know your thoughts on this.

     

    Thanks,

    Bhanu Prathap

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics