Power Automate OData filter query in SharePoint Get Item

 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': Date in the ISO format (YYYY-MM-DDTHH:MM
    ).

Steps to Write an OData Filter Query in Power Automate:

  1. Add your data source action (e.g., "Get Items" for SharePoint).

  2. In the "Filter Query" field, write the OData query.

  3. Example query for filtering items based on a column value:

    ColumnName eq 'Value'

    Replace ColumnName with the name of your column and Value with the actual value you want to filter by.

  4. Operators you can use in OData:

    • eq: Equals
    • ne: Not equal
    • gt: Greater than
    • lt: Less than
    • ge: Greater than or equal to
    • le: Less than or equal to


✨ Thanks for reading! ✨

I hope you found this blog on the Microsoft Power Platform helpful! From Power Apps, Power Automate (Cloud & Desktop), Canvas Apps, Model-driven Apps, Power BI, Power Pages, SharePoint, Dynamics 365 (D365), Azure, and more, I cover a wide range of topics to help you harness these powerful tools. Don’t miss out on future tips, tutorials, and insights—hit that subscribe button to get the latest posts right to your inbox. 💌

💬 I’d love to hear your thoughts! Drop a comment below with your questions, ideas, or feedback—let’s get the conversation started!

🔗 Let’s connect and grow together!
Follow me, Ravindra Jadhav, on your favorite platforms for even more content and updates on Microsoft Power Platform and related technologies:

  • 💼 LinkedIn – Let’s network and share ideas!
  • 💻 GitHub – Explore my projects and code.
  • 🐦 Twitter – Stay updated with quick tips and industry news.
  • 📺 YouTube – Watch tutorials and deep dives on Power Platform, Power Apps, Power Automate, and more!

Let’s build something amazing together with Power Platform and Azure! 🚀

Comments

Post a Comment

Popular posts from this blog

Display Dataverse Table Data In Power Pages by Using liquid Language

 Display Dataverse Table Data In Power Pages by Using liquid Language Display Dataverse Table Data In Power Pages by Using liquid Language CSS CODE:   /* styles.css */ /* Apply basic styles to the outer container */ .col-md-12.columnBlockLayout {     padding : 16px ;     margin : 60px 0 ;     min-height : 200px ;     background-color : #f5f5f5 ;     border : 1px solid #ddd ;     border-radius : 5px ; } /* Style the table */ .table {     width : 100% ;     border-collapse : collapse ;     background-color : #fff ; } /* Style the table header */ .table th {     background-color : #007bff ;     color : #fff ;     text-align : left ;     padding : 10px ; } /* Style the table rows */ .table td , .table th {     border : 1px solid #ddd ;     padding : 8px ; } /* Apply alternate row background color for better readability */ .table tbody tr:nth-child (even) {     background-color : #f2f2f2 ; } /* Style the button within the table cell */ .table button {     background-color :
Read more

Public Preview of Column-Level Security for Masking Sensitive Data

Image
  Public Preview of Column-Level Security for Masking Sensitive Data Data Masking in Customer Interactions: Key Points Overview : Data masking (also known as de-identification or obfuscation) protects sensitive information by replacing it with masked strings. This ensures that only authorized users can view the original data, while unauthorized users see the masked version. Purpose : Helps prevent exposure of sensitive information such as credit card numbers and social security numbers during customer interactions. Preview Feature : This is a preview feature, meaning it is available for early access and feedback but isn't intended for production use. May have restricted functionality compared to the final release. How Masking Works : Masking Rules : Define how data should be masked using regular expressions to identify patterns like credit card numbers or email addresses. Rules Setup : Create a solution in Power Apps. Add components and select "Secured masking rule" from
Read more

Fetch XML For Dataverse Table

Image
 Fetch XML For Dataverse Table In D365 & Power Apps Youtube Video Link   Step 1 1. Click On Gear Icon 2. Go to the Advanced Setting In Power Apps Or In D365 3.  Click on Advanced Find.          New Window Will Pop-Up. 4.  Select The Table As Shown. 5.  Click On Download Fetch XML. Thank You Everyone. Keep Learning  Keep Growing Keep Exploring ✨ Thanks for reading! ✨ I hope you found this blog on the Microsoft Power Platform helpful! From Power Apps, Power Automate (Cloud & Desktop), Canvas Apps, Model-driven Apps, Power BI, Power Pages, SharePoint, Dynamics 365 (D365), Azure, and more, I cover a wide range of topics to help you harness these powerful tools. Don’t miss out on future tips, tutorials, and insights— hit that subscribe button to get the latest posts right to your inbox. 💌 💬 I’d love to hear your thoughts! Drop a comment below with your questions, ideas, or feedback—let’s get the conversation started! 🔗 Let’s connect and grow together! Follow me, Ravindra Jad
Read more