Hi, my flow keeps breaking and I'm not sure why. My goal is to have an email generated when the DHS Status is set to "Cleared", but only generated once. I'm using "DHS Notification" to track whether or not it has been sent. If the status is accidentally set and then put back to "Waiting on Clearance", then it reverts the DHS Notification back to "Not Sent". Can anybody give me some insight on why my flow is breaking here?
Hi @ the_joey_o,
Could you please share a full screenshot of the configuration of your flow?
Could you please share a screenshot of the configuration of your sharepoint list "Personnel Management metadata"?
Could you please explain more about the "DHS Notification" column is your sharepoint list "Personnel Management metadata"? Is it a choice type column?
Please check if there are some item's "DHS Notification" column is null in your sharepoint list, if an item's "DHS Notification" column is null, the flow would run failed with the error that you provided as screenshot below:
You could not leave a choice type column null in your sharepoint list to get the null value in flow.
Please make sure all item's "DHS Notification" column is not null in your sharepoint.
The DHS Notification is a choice type column.
I'm not sure I can do a full image of the flow. It's a very long flow. Any more help would be greatly appreciated, because I've done a lot of different versions of this and I'm always getting the same error.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!