Answered

Filter array doesn't work for document library?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys!

I'm trying to create an email notification that refreshes and sends every morning and will tell an individual when a safety data sheet (SDS) has expired.

So far this is what I have:

Under filter array, this is what I've input:

formatDateTime(item()?['SDS_x0020_Expiry_x0020_Date'], 'yyyy-MM-dd') is equal to or less than

addDays(utcNow(), 1, 'yyyy-MM-dd')

The flow can run, but when it does, the table shown in the email includes even the SDS that has NOT expired, so I guess the filter array didn't work?? I'm not so sure, but here is how the email looks like:

The one i arrowed is not supposed to be there 😞

Sorry if this question is dumb, its my first time trying out flow automate!! Thanks for helping in advance!!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-LilyW-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous
The From value of Create HTML table should be filled with the body of the filter array.
I created a simple Flow, you can refer to as below:
This is my file library:
Flow in details:
Expression:formatDateTime(item()?['SDSExpiryDate'],'yyyy-MM-dd')
Expression:addDays(utcNow(),-1,'yyyy-MM-dd')
After flow runs, I will receive notification as below:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much! This solution 100% works! This is how it looks like now:

Thanks again!

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous
Do you only want to display the date at expiry, not including the time?
If yes, you can change the Select action as below:
Expression:formatDateTime(item()?['SDSExpiryDate'], 'yyyy-MM-dd')
Best Regards

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes! that works as well. Thank you again!!!

Was this reply helpful? Yes No