Odata filter query - adding to Sharepoint built code

(2) Share

Report

Posted on by KD-23080647-0

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:

Business Process Flows

All responses (1)

Answers (0)

KD-23080647-0 6 on at

Like (1)

Report

Odata filter query - adding to Sharepoint built code

Problem resolved, Remove the expression and build it again as Dynamic Content, so simple !