Get items 7 days after created date

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

In my "Get items" step below I have a filter query for FormStatus eq 'Pending' - I also need to filter by items that are older than X number of days.

Essentially we want to send a reminder to users to fill out a form every week if the Form Status is equal to Pending.

But what we dont want to do is send a reminder email to someone who's only been pending for 1 day.

Could someone help me with the logic to acheieve this?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @sudosaurus,

Try a filter query like below:

(FormStatus eq 'Pending') and (Created le '@{addDays(utcNow(), -7)}')

This should give you all the items with a Pending status which have been created before the 6th of April (today-7).

Was this reply helpful? Yes No