Unanswered

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:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

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. 🙂

Was this reply helpful? Yes No
kguidry 11 on at

Like (0)

Report

I still receive the same error "Invalid type. Expected Object but got Array."

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

kguidry 11 on at

Like (0)

Report

I abandoned using the Filter Array and instead was able to filter using the "Get Items" action.

Was this reply helpful? Yes No