Answered

Filter query on Get items action on Sharepoint

(0) Share

Report

Posted on by Sol007

Hi,

I have a custome date column review date and get scheduled flow up and running from a sharepoint list for a user to receive one expected reminder email 30 days before the next review date is due by addDays function query but ran into issues. See query:

Review Date eq'@{addDays(utcNow(),30)}' and Review Date It '@{addDays(utcNow(),31)}

My question is should I use only the first filter query? Any help is appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,280 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you use a recurrence trigger and run it daily, all you need is the first filter although the syntax is off.

It should look something like this:

ReviewDate eq 'addDays(ucNow(),30,'yyyy-MM-dd')'

Where ReviewDate is the internal name of the review date column.

Also, if Review Date is a calculated column, you can't use it in an OData filter.

Here is a link for more info on creating an OData filter for SharePoint.

@007Sol

Was this reply helpful? Yes No
Sol007 93 on at

Like (0)

Report
Copy link

Link copied!

Thanks @ScottShearer

Totally unrelated but grateful if I could get some tips on how to check sites that have broken inheritance on them?

Was this reply helpful? Yes No