Unanswered

Error when sending an email through Automate from my Users table in Dataverse

(0) Share

Report

Posted on by AlanGN07

Hello everyone, I have a problem since I am generating an automated flow in which I want the "person in charge" to send me an email every time a new record is created from a sales table that I make in Data Verse. From my Power Apps app.

Field in Power Apps:

The "person in charge" field is a lookup field of my AAD users table related to my sales table.

Field in Dataverse:

What happens is that when I execute the flow the value of my field "Person in charge" in the flow throws an error since it is sending the User Id of the "Person in charge": '92137a30-89c6-4bd3-a613-7a807ca47957 ' but what I want is for you to send the mail.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Static 118 on at

Like (0)

Report

Hi @AlanGN07 ,

Run the flow, got to run task and get the output body from trigger, paste in note. you can see the output. For example in Lead table if we want to fetch Source Campaign which is a lookup field to campaign table then the output of the power automate step will give below tags.

Now if we want to display the name of a lookup field use the below code. If the lookup field name is “campaignid” the the code to display text is given below. Copy it.
_campaignid_value@OData.Community.Display.V1.FormattedValue
Now I have used below code in my power automate variable to display campaign name.
For my case I am using below code. Paste this in Send an email and add to expression
outputs(‘Get_a_row_by_ID’)?[‘body/_campaignid_value@OData.Community.Display.V1.FormattedValue’]

Best regards,
Anton Nyrkov

Was this reply helpful? Yes No
MarioRing 541 Super User 2024 Season 1 on at

Like (0)

Report

Hi @AlanGN07 !
In the field "To" on "Send an email V2" you have to put the e-mail address of the recipient. Your flow tries to use the user GUID instead of the e-mail address (like "92137a30-89c6-4bd3-a613-7a807ca47957" vs "johnsmith@domain.com") that's why the system throws an error here.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @AlanGN07, your Person in Charge column is a lookup column, and you probably have the email-address in the related table. Do the following:

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos