You’re offline. This is a read only version of the page.
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!
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!
Can you upload a screenshot of what your flow looks like now? It would help me to see the bigger picture. Thx.
@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!
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.
@creativeopinion you are a lifesaver. This worked beautifully and now I don't have to use a filter array. Thank you!
@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!
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?
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (