Hey guys,
I'm working on the final touches of my workflow. And toward the end I want my workflow to Get Items (from a sharepoint list, and using the filter query Title eq Model_ID variable and Status eq In Progress):
- If an item is found, then the next steps can be skipped
- If an item is not found, then the next step (Create item) can run.
As such, I have configured the Create item action to run only when the Get Items has failed, because I thought that if it doesn't find an item, it fails...
But when testing the workflow, I noticed, that despite not finding a matching item, it comes with a Status Code 200, meaning it's successful, but the body message is obviously empty, cause no items were found. It actually says "value": []. This has an impact on my next steps, because it doesn't create the item as it should.
My first solution to fix this was trying have a Condition after Get Items where:
That's brilliant! Thank you @creativeopinion ! The thing that worked was to create a Compose action after Get Items to count the number of items. And created a Condition after to only Create an Item if the Outputs of the Compose are 0.
@Capshoo1 You might find this YT Tutorial helpful in troubleshooting your flow: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this tutorial I cover:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent
Hope this helps!
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1