Filter array in 2nd apply to each not work

[priyo182]

Dear team,

I'm going to create flow send email reminder for expired document.

This scheduled flow will be run daily. And I use document library as storage

1st step : I would like to get all item which expired date today.

2nd step : If item found, then i would like for check who will be notified in each row items (there is column named "notify_receiver" in doc library) and get their unique username and email for "Receiver"

3rd step : After found each receiver, then i would like to get all items for each receiver (summary items expired which owned by receiver)

4th step : Need to send email to each receiver that contain summary list items (generated in 3rd step).

Currently i try to use filter array in apply each receiver, but data not filtered (still view all data based on 1st step)

Any suggestion how I build flow /automate for our needs above?

Your feedback/advice will be very helpful

Screenshot current flow has attached

Thank you

Warm regards, 

[ManishSolanki]

Hi @priyo182 

Pls check if filter array 2 action should have compose - user email output value on the right side to compare with in the query.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[priyo182]

Hi @ManishSolanki ,

Herewith screenshot for compose user email output

any suggestion or need to change flow process?

thank you

[ManishSolanki · Accepted solution]

Hi @priyo182 

I would suggest to pls check the values of inputs & outputs for each action inside apply to each loop. You could check those values in the last run flow instance. Pls also check if the filter query uses the correct SharePoint list column to apply filter on email address. Also check if there is any space before or after the output of compose action that is being used in filter query.

Initially, you have mentioned that filter array 2 is not returning the correct array, so if you pls share its input along with output of compose action that contains the email address. 

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[priyo182]

Hi @ManishSolanki , 

Thanks for your advice.

Based on your advice to check value each step, we have change flow process.

And currently we can send notification to each responsible person and having summary list expired document name in email.

Warm regards,