Skip to main content

Notifications

Community site session details

Community site session details

Session Id : QFwQkbrEIMlXzYMrOcLA91
Power Automate - Building Flows
Answered

Status Code 200 - empty body/message

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2024 18:34:50 by 17

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:

outputs('Search_for_an_existing_in_progress_Phase_2')['statusCode'] is equal to 200 AND 
outputs('Search_for_an_existing_in_progress_Phase_2')['body/message'] is [left empty]
So if it's true, then I can Create item, if not, i terminate my flow.
I also tried body, instead of body/message; I also tried "value": [] instead of leaving it empty.
None of these options seem to work.
 
Any ideas on how to address this in the best way? Is there something else I could try instead of "value": [] and leaving it empty?
  • Capshoo1 Profile Picture
    17 on 22 Feb 2024 at 09:24:45
    Re: Status Code 200 - empty body/message

    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.

  • Verified answer
    creativeopinion Profile Picture
    10,411 Super User 2025 Season 1 on 21 Feb 2024 at 18:36:57
    Re: Status Code 200 - empty body/message

    @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!


    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started