Hello,
I have a sharepoint list that consist of 5 different views. Each view has a different condition/filter in sharepoint (see below). I created a flow that sends a report of all the different view.
What I need: how can I add the below filter/condition to power automate? should I do it on the "get items" ODATA field? or is there a better way to write multiple conditions into power automate and what are the steps?
SharePoint filters/condition:
View #1
Date is equal or less than [today+21]
AND
Date is more than [amount of people]
OR
Today is equal to [services]
Thank you