Answered

Return list based on expiry date

(0) Share

Report

Posted on by MilesG

Good afternoon,

Ive built a flow that runs on a schedule and should return an email list based on expiry dates.
So far, the flow returns all values within the table and doesn’t filter for dates either expired or expiring in the next 30 days…

Steps in the flow:

Recurrence

List rows present in a table

Filter array

create HTML table

Send an email

How do I get the flow to filter only dates that have either passed or due to expire in the next 30 days and only return those values in an email?

Many thanks.

I have the same question (0)

All responses (19)

Answers (1)

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Re: Return list based on expiry date

Hi @MilesG

You Can Apply Filter on the list.

addDays(utcNow(),-30)

-------------------------------------------------------------------------
If I have answered your question, please mark post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Re: Return list based on expiry date

Hi @MilesG
Same For Excel Table

Was this reply helpful? Yes No
MilesG 18 on at

Like (0)

Report

Re: Return list based on expiry date

Hi @Amit_Sharma, thanks for taking the time to respond, unfortunately though I receive an error if I run the flow using the Greater than or equal to operator, if I use equals then apply a filter array after I still get all the items returned in the table.

F1522A62-E1F2-45D...

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Re: Return list based on expiry date

Hi @MilesG
could you Please show me error and show me flow where you are doing compression.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Re: Return list based on expiry date

Hi @MilesG
The greater than or equal to Currently not supported by List row present in table Action it only support ne,eq,contain
so, you can use Filter Array Action for achieve goal.

addDays(utcNow(),-30)

Best Regards,

Was this reply helpful? Yes No
MilesG 18 on at

Like (0)

Report

Re: Return list based on expiry date

Hi @Amit_Sharma
I must be doing something wrong as I still do not receive the correct data. The output still does not filter the dates that are more than 30 days away.

60605E39-1025-453...

FE9F80FC-0DEA-431...

CBACB984-A64C-433...

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on at

Like (0)

Report
Re: Return list based on expiry date

In your condition for the Filter array, you'll need to format the date from Excel and the data you added days to.

formatDateTime(item()?['YOUR_EXCEL_DATE_FIELD'], 'yyyy-MM-dd') formatDateTime(addDays(utcNow(), -30), 'yyyy-MM-dd')

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Re: Return list based on expiry date

Hi @MilesG
Please Select Date Time Format Field ISO 8601 in List rows present in a table Action then it's work perfectly.

Best Regards,

Was this reply helpful? Yes No
MilesG 18 on at

Like (0)

Report

Re: Return list based on expiry date

@Amit_Sharma @grantjenkins
Thanks for your time, but I’m clearly doing something wrong…
I’ve rebuilt the flow with your recommendations yet still I don’t get the required result.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Re: Return list based on expiry date

Hi @MilesG
Could please show me your flow.
Also try to show me sample output which return by Get row present in table action.

Was this reply helpful? Yes No