Unanswered

Multiple Approver Fields Error When A Field is Blank

(0) Share

Report

Posted on by JoshShutts

Hello. I have the below flow to where I have 3 fields on my list of possible approvers. The item will not always need all 3 approvals so any of the 3 fields may be blank. My flow is sending the approvals out to the people that are listed in any of the 3 fields but I am receiving the following error in the screenshot. Anyone know how to fix this? Note that this trigger is when an item is created on the list. The error is stating that the Assigned to field is missing but it's not and you can see that it kicked off fine for the CO approval but failed for the other 2 because they did not have a name in them. Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

The Assigned field needs to be an email, is the dynamic data you have there an email?

Was this reply helpful? Yes No
JoshShutts 72 on at

Like (0)

Report

It's a people picker field and it emails just fine when there is a name in any of the 3 fields but it errors out if any of the 3 fields do not have a name in it.

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report
We can probably clean the flow up a bit, instead of running 3 approvals, do just 1 and pick to either wait for all the approvals or just 1 of them. That way you dont have to do the same steps 3 times.

Then just put the approver field to whats written below but switch to your columns, this way your send approval wont fail if one of them is empty.
Approver1;Approver2;Approver3

Was this reply helpful? Yes No
JoshShutts 72 on at

Like (0)

Report

Ok, this might work and I will feel silly if it does. Let me give it a shot. Thanks!

Was this reply helpful? Yes No