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:
Solved! Go to Solution.
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:
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
2. Then, the SP List gets populated with the info in the form
--- 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 ---
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.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!