Unanswered

Filter Array Working but not working Confused :(

(0) Share

Report

Posted on by gazzo1967

1,151

HI Everyone 🙂
I have a weird one that my brain is now numb from!
I am building a flow to archive calendar events for the previous 3 month in to a Sharepoint list which after item created will be deleted from the calendar.
My flow structure is

Recurrence as trigger then

To here above its returning data

From below onwards no data being passed

What am I missing? 😞
Regards Gary

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @gazzo1967 ,

Just to confirm that I understood it correctly: your 'Filter array' action is returning a non-empty array, but when you pass it to the 'Apply to each 2' as dynamic content, no items are found to be looped?
If this is the case, could you please share the raw outputs from your 'Filter array' action? By doing that, we will be able to identify if is there any errors in the JSON structure of your action outputs.

If you don't know how to get access to the raw outputs, refer to the steps described in this article: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/

Make sure to remove any sensitive content before sharing the outputs 🙂

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (1)

Report

There's a couple of things that I'd maybe change for efficiency, here, @gazzo1967 ... but I don't have the time to address those right now.

I do think one thing that you could change immediately would be to use the 'Subtract from time' action from the 'Date Time' connector.

There is a chance that your time is maybe not subtracting correctly ... just a chance, though.

I think you would also want your Filter to be 'less than' ... no? Plus, if you really want push that, you could wrap each time with trim() in the expression builder.

((( I'm penning a 'proper' answer for you, too )))

Was this reply helpful? Yes No
Verified answer

eliotcole 4,363 Moderator on at

Like (1)

Report

Here you go, @gazzo1967, this should get you accurate results:

Essentially just using the built in 'Filter Query' on the Get items connector will accurately filter the dates.

In my example above I am running it on the default 'Events' list in my site, to get that particular list you need to type it in as a custom value as you cannot select it.

That and using the 'Subtract from time' will ensure that it only returns items that are older than 3 months ago.

Was this reply helpful? Yes No