I have built a process flow for Approval.
The process needs to look at a SQL database and return an email address from the line of data in the 'AssignedTo' section of the flow. When completing the flow as below i receive and error which i have provided as well?
Any help is appreciated as I'm at a loss?
Solved! Go to Solution.
This usually happens if the field value specified in the 'AssignedTo' section is empty. You could add a Condition first to determine if Manager Email dynamic content is empty. If it is empty, Approval action is not executed and if it is not empty, send an approval email.
First Step in the flow: When an item is created (as you did in the picture)
Second Step in the flow: Add Condition (you need to add this part to your flow)
If manager email is equal to null
If yes ----> Take no action
If no -----> Create an approval (as you did in the picture)
Let me know if it this helps you!
Community Support Team - Edgar Madrigal
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@emadrigal I have looked in to the table that feeds this process and imparticular the 'ManagerEmal' section and there is and email address in the table - i have tried you addition but it did run and it should have as there is an email address as shown below
Im at a loss now - The format of the data is varchar(255) as well if that helps.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!