Start an Approval - Assigned to Field - Dynamic Content

[Pripri804]

Hi,

Did anyone ever build a flow with an approval and adding a dynamic content in the assigned to field?

i have an approval  flow built with a SharePoint list, and I want to send an approval email based on the 'Manager' column i have in the SP List (people picker)
when i choose the dynamics content 'Email', it's returning the following error:

BadRequest. The request failed. Error code: 'InvalidApprovalSubscribeRequestAssignedToMissing'. Error Message: 'Required field 'assignedTo' is missing, empty, or contained no valid users.'.

Any ideas please?

[v-xida-msft]

Hi @Pripri804,

Could you please share a screenshot of your flow's configuration?

Further, could you please show more details about your SharePoint list?

The error message told that there is something wrong with the value that you filled within the Assigned to field of the "Start an approval" action, the value that you provided within the Assigned to field is invalid.

I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:

Note: The Manager column is a Person or Group type column in my SharePoint list.

The flow works successfully as below:

Please check if you have filled a value within the Manager column of your SharePoint list. You could consider output the result the Manager Email dynamic content returned using the Compose action as below:Then check if the Manager Email dynamic content contains a value. 

In addition, you could also take a try to add a Condition to check if the Manager Email dynamic content is empty, if yes, do nothing, if no, send an approval email:

 Within Condition box, click "Edit in advanced mode", type the following formula:

@empty(triggerBody()?['Manager']?['Email'])

Best regards,

Kris

[Pripri804]

Hi @v-xida-msft,

Thanks for your reply. I tried your suggestion and added a condition to check if the Approving Manager email field is empty and indeed it resulted as true - it is empty - even though i can see it populated in SP.

So here's my entire flow:

1. User inputs details in Microsoft Forms

Starting Point - Microsoft Forms

2. Then, the SP List gets populated with the info in the form

Leave Request SharePoint List - Gets populated via Flow once a Form has been submitted

--- The Approving Manager column is a people picker column which gets populated via a SP Designer Workflow which checks in another list who the user is and his equivalent manager ---

Approving Manager SharePoint List

SharePoint Designer Workflow to check in Approving Manager list who is the manager for that user - and populate the Approving Manager column in the Leave Request List

3. And here is the flow in Microsoft Flow

I added a delay function so that I make sure that the approving manager column has been populated via the SP Designer workflow. And by monitoring, it does get populated before the Flow continues.... so i don't think that that is the issue


Thanks for your help.

[Pripri804 · Accepted solution]

I actually solved the issue by populating the manager field in exchange and using the get manager function

[Anonymous]

Hi @v-xida-msft

Is it possible to add the condition to check if the Manager Email dynamic content is empty, if yes, skip approval, if no, send an approval email?