Unanswered

Get Account Name instead of Account GUID from Dynamics 365

(0) Share

Report

Posted on by waleedbinafzal

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.

Categories:

Using connectors

I have the same question (0)

All responses (9)

Answers (1)

bhanuprathap121 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (1)

Report

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.

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

Best regards,

Mabel Mao

Was this reply helpful? Yes No
waleedbinafzal 41 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Nhegde 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Frantisek 11 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RobinA 8 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
clubinski 92 on at

Like (0)

Report

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

Was this reply helpful? Yes No
saianugrah Microsoft Employee on at

Like (2)

Report

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

Was this reply helpful? Yes No