Answered

Get Items Filter Query return three days prior

(0) Share

Report

Posted on by send2mark

505

In a SharePoint list, I figure I can create a column that subtracts 3 days from the due date and run a query filter on that, but it would be much nicer if I could just filter the due date with a calculation.

So this flow will run on a schedule every day looking for due dates three days in the future so I can set a reminder.

I have to change the format of the date and I cannot seem to get it to work.

DueDate eq 'addDays(formatDateTime(utcNow(),-3,'dd-MM-yyyy'))'

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @send2mark m

Try the below

@addDays(formatDateTime(utcNow(),'yyyy-MM-dd'),3)

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report
Copy link

Link copied!

It is failing when I change it to day-month-year to match the format of the Due date.

Was this reply helpful? Yes No
send2mark 505 on at

Like (0)

Report
Copy link

Link copied!

I am also, trying to grab everything 3 days before the due date.

Was this reply helpful? Yes No
Verified answer

send2mark 505 on at

Like (1)

Report
Copy link

Link copied!

This worked for me.
formatDateTime(addDays(utcNow(),3),'yyyy-MM-dd')

Was this reply helpful? Yes No