web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send HTTP to Sharepoin...
Power Automate
Answered

Send HTTP to Sharepoint and Select from JSON - Bad Request Array error

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

 

I have the following MS Flow:

 

Sharepoint List > "When an item is created or modified"  [This works]

Sharepoint > "Send an HTTP request to Sharepoint" [This works]

  • Site address is correct
  • Method:  GET
  • Uri:  _api/web/Lists/getbytitle('MyList')/items(@{triggerBody()?['ID']})/versions?$top=2
  • Headers: key= accept   value=application/json; odata=nometadata  
  • Body:  

Select [This fails]

  • From: @{body('Send_an_HTTP_request_to_SharePoint')}
  • Map:
    • key= ID  , value=  @triggerBody()?['ID']
    • key= Status, value= @triggerBody()?['Status']?['Value']
    • key= Version, value= @triggerBody()?['{VersionNumber}']

Fail= BadRequest. The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.

 

My problem:  I don't know how to fix this Bad Request error. This is my first time trying to use a send http request in sharepoint flow like this. 

 

My goal: I want to check last two version to see if the modified field was the Status or not. If it was the Status, then I will use a Switch statement to evaluate the Status change and take appropriate action. 

 

I would appreciate it greatly if someone has a solution to fix this flow or an alternative method that accomplishes the same goal. 

 

Thank you very much.

 

Categories:
I have the same question (0)
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @Anonymous 

     

    Use

     body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Verified answer
    v-bacao-msft Profile Picture
    Microsoft Employee on at

     

    Hi @Anonymous ,

     

    Please refer to this blog for details on obtaining item versions using an HTTP request:

    Check-for-a-Change-in-a-SharePoint-List-Column-Value

    It is recommended to parse the response using Parse JSON action, which makes it easy to get specific property values.

    Please try again.

     

    Best Regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 630

#2
Valantis Profile Picture

Valantis 420

#3
11manish Profile Picture

11manish 350

Last 30 days Overall leaderboard