cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
porski
Frequent Visitor

Approvals not being sent to selected approver

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

porski_0-1620516025892.png

 

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

porski_1-1620516676267.png

 

3. The error message

porski_2-1620516755394.png

 

Any suggestions? Thank you in advance!

8 REPLIES 8
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
porski
Frequent Visitor

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
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
porski
Frequent Visitor

Here's the Compose action I have created:

 

porski_0-1620608217941.png

 

And here's the output:

porski_1-1620608558249.png

 

Thank you!

 

Pstork1
Dual Super User
Dual Super User

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?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
porski
Frequent Visitor

I used "Choice" as data type:

porski_0-1620617889894.png

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

porski_1-1620618005479.png

Thanks!

Pstork1
Dual Super User
Dual Super User

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/ 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
porski
Frequent Visitor

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (4,140)