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!
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.
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!
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.
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?
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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.