Power Platform Community Forum Thread Details

I have a SharePoint list with a Due Date column, I used the Flow builder in SharePoint to create a flow to send a reminder based on this Due Date then started making edits to this flow to do more,

The flow built the query filter to send a reminder on a single day ahead basis and looks like this - I have since changed the names of the outputs used, this works

concat(concat('field_9',' ge ', '''',outputs('ReminderStart')),'''',' and ', concat('field_9',' lt ','''', outputs('ReminderEnd'),''''))

I need to add another AND to this filter and just cant get it right

and 'field_14' eq "Y"

I think my problem is not understanding what all the '''' are doing in the original code, where do I add the next and, do I need another concat,

Can anyone help break this down or show where \ how I add this extra and requirement?

Thank You

Categories:

Building flows