Hi,
I have a form in Model Driven app. That form has a field (Column) Called Approver1 to choose an approver, for which I am using the Standard User Table of Dataverse. So this filed would do a lookup from User table. When I am using this column in the Send an Email action in Power Automate, it is getting failed. In the table this value (Approver1) is getting stored as Display name. How should I get the Email address for the Approver and then use it in Send an email action in Power Automate.
Please could anyone help me on this ?
Hi @Saideep
Pls use "Get row by id" action of Dataverse connector, pass the Approver1 field value from dynamic content as shown below:
Next, you could get the email address of the user dynamically, here I have stored it in compose action:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks