Answered

Set a reminder filter query syntax

(0) Share

Report

Posted on by andy10

I have the standard 'Set a reminder' flow setup on a SP list. I would like to filter the list further. Example, region starts with "AZ". I'm just confused on the syntax. (OData is scary)

concat(concat('Proposed_x0020_Start',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Proposed_x0020_Start',' lt ','''', outputs('x_Days_+_1'),''''))

and startsWith(Region, 'AZ') ????

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @andy10

Yes try extends with and startsWith(Region, 'AZ'). Are you getting any error?

Was this reply helpful? Yes No
andy10 12 on at

Like (0)

Report
Copy link

Link copied!

Not sure what you mean by extends... I'm getting expression is invalid.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @andy10

Thanks for your quick reply. Is your concat expression works without the startsWith operator? If it works then try the below.

startsWith(Region, 'AZ') and concat(concat('Proposed_x0020_Start',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Proposed_x0020_Start',' lt ','''', outputs('x_Days_+_1'),''''))

Was this reply helpful? Yes No
andy10 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks. The concat expression works without startsWith.

startsWith does not work before or after the expression. I get "expression is invalid."

Was this reply helpful? Yes No
Paulie78 8,424 Moderator on at

Like (0)

Report
Copy link

Link copied!
You've made it much more complex than it needs to be with all the concatenation. You can just type into the odata filter query box and it will be concatenated automatically. This query does exactly what you are after.

ProposedStart ge '@{addDays(utcNow(), variables('numberOfDays'))}' and ProposedStart lt '@{addDays(utcNow(),add(variables('numberOfDays'),1))}' and startswith(Region, 'UK')

Easier to read and does what you want.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @andy10

I just tried with the below and worked

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @andy10

There was a case sensitive typo in my previous posts. The correct syntax is startswith

Thanks

Was this reply helpful? Yes No
andy10 12 on at

Like (1)

Report
Copy link

Link copied!

Thanks all.

Yes, what I had was much too complicated, but that's what Microsoft generates from their standard template. 😄

Was this reply helpful? Yes No