Ravindra

 Power Automate OData filter query in SharePoint Get Item In Power Automate, the OData filter query helps to retrieve only the data that matches specific criteria. Below is an example of how to write it in a flow. Example 1: Filtering SharePoint list items where Status is Approved Let’s assume you have a SharePoint list with a column called Status and you want to filter items where the Status is Approved . Filter Query: Status eq 'Approved' Status : The internal name of the SharePoint column. eq : OData operator for "equals." 'Approved' : The value you are filtering by. Example 2: Filtering records based on dates and another field Suppose you want to filter records where Status is Approved and the Created date is after 2023-01-01 . Filter Query: Status eq 'Approved' and Created gt '2023-01-01T00:00:00Z' and : Logical operator to combine multiple conditions. gt : OData operator for "greater than." '2023-01-01T00:00:00Z'