Filter Sharepoint list with odata

[djw1005]

I have a sharepoint list that has holiday information and what I want to do is filter those items based the month that we are in so that I can then send an email to managers to say who is on holiday.

I think I can achieve this with odata filter, but not sure how to achieve this

[v-micsh-msft]

Hi @djw1005,

Please take a look at the thread below, which talks about how to work with OData Filter under Microsoft Flow SharePoint Get-Items Action:

Obtaniing a filtered SharePoint List based off a column

You man also take a try with the filter array action.

Post back if you have any further questions.

Regards,

Michael

[djw1005]

Thanks but I want to filter based on start date and end date, how could I combine this?