cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
robofski
Helper II
Helper II

Http Request - Parse JSON - Filter Array

I have a flow that is using a http request to graph API to retrieve some user details.

I'm taking the output from the http request and formatting it with a Parse JSON action.

When I then try to use filter array on the parse JSON output I get the following error:

The 'from' property value in the 'query' action inputs is of type 'Null'. The value must be an array.

Here's a sample of the output from the parse JSON which is not null!

{
    "value": [
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "Mexico",
        "displayName": "User1",
        "userPrincipalName": "User1@company.com"
      },
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "Mexico",
        "displayName": "user2",
        "userPrincipalName": "user2@company.com"
      },
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "1043",
        "displayName": "user3",
        "userPrincipalName": "user3@company.com"
      },
      {
        "userType": "Member",
        "accountEnabled": true,
        "employeeId": "5935",
        "displayName": "user4",
        "userPrincipalName": "user4@company.com"
      }
    ]
  }
 
Any pointers? 
2 REPLIES 2
Mari
Community Support
Community Support

Hi! Could you try to save the same output that you pass to the "From" field in a Compose before the Filter Array action? Run the flow and check if the results in the Compose are indeed null.

 

Best regards,

 

Community Support Team - Mari
If this post helps, then please consider Accept as solution to help the other members find it more quickly.

Nice idea but still fails.  When I pass the "Value" from the parse JSON to the compose if I try to view the output there is nothing!  If I pass the body then the filter array doesn't like it because it's an object not an array.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,036)