Required field 'assignedTo is missing or empty' error

(0) Share

Report

Posted on by Holly_CMS

523

Hi,

I am building a multiple approvers flow. I followed the instructions and for some odd reason, this is firing an error...

According to Microsoft, the email addresses are invalid? This doesn't make sense as they are valid email addresses....

InvalidApprovalCreateRequestAssignedToMissing

Required field 'assignedTo' is missing or empty.

This error occurs if the Assigned To field of the approval action didn't contain any values. The Flow designer prevents any Flows from being saved without any value for this field, so typically this can occur if the Assigned To field is populated from the output of some other step and for this Flow run, there was no value for the expression or output field.

Approvers emails issue3.PNG Approvers emails issue2.PNG Approvers emails issue1.PNG Approvers emails issue.PNG

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Holly_CMS

Please try the below expression for the 'Assigned to' property in approval action:
join(variables('varApprovers'),';')
You need to put this formula inside the Expression tab as shown in the screenshot.

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report
Copy link

Link copied!

It works but it's sending to 3 approvers emails at the same time. It's a sequential approval process. It needs to be split like Approve 1 goes to Approver 1 (Sam)...after that's approved, then goes to Approver 2 (Adam), etc. Follow me?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Holly_CMS

In that case, you need to take element from 'varApprovers' array & accordingly set 'Assigned to' at each level:
First Approval:
Expression:
first(variables('varApprovers'))

Second Approval: Using index we will fetch the second approver email from array variable. Index starts with 0, so for second element, the index will be 1.
Expression:
variables('varApprovers')[1]

Third Approval:
Expression:
last(variables('varApprovers'))

Note: This flow will work if all approvers are present in the list. If any of the approver field is empty, then you need to handle null or blank values as well using condition action.

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report
Copy link

Link copied!

Ok, let me show you this flow....I only added 1 approval action in the flow....I do have a working flow similar to this but broken up using 3 approval actions and the Approver X email addresses from SP works fine without any expression.

But this one...according to https://youtu.be/gb_FUeRjgg4 , Reza Dorrani used item() as an expression for the assigned to field. However, he had email addresses as the varApprovers whereas I am using the email addresses from SP dynamics in Power Automate. We don't have 3 email addresses set in stone as the company is pretty large so we have whoever was selected as Approver 1, Approver 2, Approver 3 from the Power Apps form.

I believe that the expression item() is confused. Hope this clarifies for you. I appreciate you helping me out in this! 🙂

Was this reply helpful? Yes No