Filtering a SharePoint list in Power Automate Reminders

(0) Share

Report

Posted on by jess23

Hi There

I currently have a 'default' Power Automate reminder set up on a SharePoint list. I want to customise the flow reminder to filter all items that are reaching a certain date by column "Site"

The current Get Items filter query exists as part of the default reminder, but how do I include the Sites eq 'Epping' to the following code? I want the reminder to only let me know about items expiring that have been assigned "Epping" in the Site column of the list.

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

Thank you!!

Jess

Categories:

Building flows

All responses (1)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @jess23 ,

the combined concat(...) expressions makes the Filter Query very hard to read. Instead of the concat(...) expressions I'd simplify it to the format: column <operator> 'value', which will make it also easier to add another condition to the filter.

concat(concat('Expiry',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Expiry',' lt ','''', outputs('x_Days_+_1'),'''')) => Expiry ge 'outputs('Today_+_x_days')' and Expiry lt 'outputs('x_Days_+_1')' and Sites eq 'Epping' Note: the outputs(..) must be a dynamic content, replace it in the filter query, the rest is just a string. The value must be always in single quotes.