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