Answered

Help! Filter Array erasing dynamic content

(0) Share

Report

Posted on by jessicadduffey

Hello - I am attempting to pull items from a Sharepoint site into a monthly excel report based upon the following parameters:

- BLEND = yes

- Created during current month

With some help from this community, I have gotten the filtering to work and the correct items to pull into the report based on the parameters defined. The problem is that after I perform the filter array, a key element of the report is now missing (see the JSON from the Get Items output below):

I cannot append this to the array as it is a string. How can I get this to show back up in the dynamic content?

Also, using the flow below for reference - I am assuming that the next steps will be Parse JSON (to get the dynamic content back), Create CSV (to create the CSV table), and Create File (so the CSV is now available on the sharepoint site). Does that sound like the correct plan of action?

Here is my flow for reference:

This community has been such an amazing help - thank you so much in advance for helping me tackle this issue!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@jessicadduffey
Are you able to add a condition to your filter query in the Get Items action rather than use a Filter Array action?

Don't ask why, but if you want to filter out a Yes/No column using the OData filter query in the Get Items action you need to use a 1 (yes) or 0 (no).

I also haven't seen a case where the Filter Array removes content. That action should only be filtering the results returned from the Get Items action.

Can you confirm that the missing content from the Filter Array action is present in the outputs of the Get Items action?

Was this reply helpful? Yes No
jessicadduffey on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion let me give this a try - I wasn't aware of this and I would LOVE to not have to use the filter array. It is creating all kinds of problems!

Was this reply helpful? Yes No
jessicadduffey on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion you are a lifesaver. This worked beautifully and now I don't have to use a filter array. Thank you!

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

Fantastic! Glad it worked out. Just note that if you need to use a contains condition, you will need to use a Filter Array action.

Was this reply helpful? Yes No
jessicadduffey on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion since you did such an awesome job helping me out...here are two more questions:
1. Please refer to the screenshot below. For the highlighted items, I'm interested in populating the value in my CSV table. How would you recommend getting to that value, and where is the best place to build in that step? In the past, when I did the filter array first, I would do an apply to each using the following steps: Select (mapping with item()?['Value']. Join with a comma, then append the output to an array variable...but again, I'm not using a filter array so I'm not sure if the steps are the same.

2. How would you recommend handling null values? My flow breaks down anytime there is a null value. I am able to replace any null values with something like 'no response' or such...but I just don't want the flow to break down every time someone doesn't respond to a question.

Again, thanks for your help!

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you upload a screenshot of what your flow looks like now? It would help me to see the bigger picture. Thx.

Was this reply helpful? Yes No
jessicadduffey on at

Like (0)

Report
Copy link

Link copied!

Of course! Screenshots are below.
1.
2.

3.
Select>Map expression: item()?['Value']

4.

This is the error that I'm getting (and what the error is):
If you need any JSON outputs, let me know. I hope this helps, and thank you for your help!

Was this reply helpful? Yes No