Answered

Use Output from Filter Array

(0) Share

Report

Posted on by kguidry

I'm trying to create a flow that generates a report based on a filtered SharePoint list. I was able to do this on another flow, but I can't seem to use the data from my Filter Array to create the new report. After some googling, I saw that I have to use the Parse JSON command, but I'm getting the following error: "Invalid type. Expected Object by got Array."

I've seen some solutions for using 1-2 variables from a Filter Array, but I want access to all of them. What do I need to do to be able to use the output from the Filter Array command?

Here's the overview of my flow:

Here's the error:

Categories:

Business Process Flows

All responses (4)

Answers (1)

Verified answer

kguidry 11 on at

Like (0)

Report

Re: Use Output from Filter Array

I abandoned using the Filter Array and instead was able to filter using the "Get Items" action.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Use Output from Filter Array

@kguidry Assuming Filter by Status is a Filter array - the output of that should be an array of items.

Run your flow then copy the entire output from your Filter by Status. Then go back into Edit mode and within your Parse JSON, click on Generate from sample and paste in the output you just copied. This should generate a schema based on your Filter array.
kguidry 11 on at

Like (0)

Report

Re: Use Output from Filter Array

I still receive the same error "Invalid type. Expected Object but got Array."
Sundeep_Malik 6,480 on at

Like (0)

Report

Re: Use Output from Filter Array

Hey @kguidry

Copy the entire data your getting in input of above parse json in the run history.
Then edit your flow. Paste the data in generate from sample of parse json. Now I dont think you will get the same error.

I hope this will help. 🙂