Approvals not being sent to selected approver

[porski]

Hello,

I have created a custom entity in Microsoft Dataverse, and within that entity, I created a "choice" data type and let users select an email address from the list. I use that value to assign the approver in Approvals, however, it is having an error when the flow runs.

Below are some screenshots

1. Users select an email address from the form in my model-driven app

2. I use the dynamic content option to assign the approval

3. The error message

Any suggestions? Thank you in advance!

[Pstork1]

Did you check the output of a run to make sure that the approvers list dynamic content is just the email addresses in the form of a semicolon delimited string?  If its a collection of emails or user objects then it won't work.

[porski]

I did check using Compose and the output doesn’t show the email address. Is there a recommended way for scenarios like this? I want to allow the requesters select from a list of approvers. Thanks!

[Pstork1]

What does the compose show?  Its probably just a matter of taking values from an array of objects and creating a string.  But I need to know what the format looks like before I can suggest how to do that.

[porski]

Here's the Compose action I have created:

And here's the output:

Thank you!

[Pstork1]

It looks like you are getting the ID or something for the approver's email record rather than the email address itself. Can you share the schema for the Dataverse table?  Is the email address a lookup field?

[porski]

I used "Choice" as data type:

Then for the choices, i just typed the approvers' email addresses

Thanks!

[Pstork1]

Accessing the label values in a Choice column are a bit tricky.  Take a look at this article on how to access the label from the choice column.

https://debajmecrm.com/how-to-get-optionset-choice-label-value-from-dataverse-in-power-automate/ 

[porski]

Thanks a lot. I checked the link and it looks tricky indeed. I think it will take time for me to digest as I am new to this.

I am just thinking, maybe there is another workaround for this? As long as my requesters can select or type the designated approver should be fine.

Thank you!