Skip to content
March 27, 2023
  • Like what I do? Click here and donate! Keep me writing quality content that saves you time 🎉🎉🎉

Manuel T. Gomes

  • Power Automate
    • Articles
    • Function Reference
    • Trigger Reference
    • Action Reference
    • Expressions
    • Templates
  • Power App
    • Articles
    • Function Reference
    • Delegable Functions Reference
  • SharePoint
    • Articles
    • List Function Reference
  • More
    • OData Reference
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
  • About
  • Hire Me!
  • |
  • Log In / Register
  • Power Automate
    • Articles
    • Function Reference
    • Trigger Reference
    • Action Reference
    • Expressions
    • Templates
  • Power App
    • Articles
    • Function Reference
    • Delegable Functions Reference
  • SharePoint
    • Articles
    • List Function Reference
  • More
    • OData Reference
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
  • About
  • Hire Me!
  • |
  • Log In / Register

Category: OData Reference

OData or Open Data Protocol is a convention that describes a set of rules in building an URL. You can have things like operators, queries, and more. I will simplify its concepts since the specification is quite dense.
Microsoft’s Power Platform takes full advantage of it, so we will too. I’ll show you cases, especially in Power Automate, where you filter the data before it’s transmitted.
If you don’t understand it, the syntax can be tricky, so I want to provide some help by defining my own OData reference. For example, you can specify that you wish to only items that start with a particular set of characters or an older date than today. There is a lot to explore.

OData: startswith Function
OData Reference / Reference

OData: startswith Function

Manuel Gomesby Manuel GomesMay 28, 2021May 27, 20210

Besides operators, OData also enables us to have functions on our data. These are super useful to filter the data on the source to pull …

OData: startswith Function Read More
OData: OR Operator
OData Reference / Reference

OData: OR Operator

Manuel Gomesby Manuel GomesMay 21, 2021December 2, 20220

Data aggregation is essential when performing requests for data, and we’ve already covered the And Operator that helps with that. On the other end of …

OData: OR Operator Read More
OData: Lower Than or Equals Operator
OData Reference / Reference

OData: Lower Than or Equals Operator

Manuel Gomesby Manuel GomesMay 14, 2021May 14, 20210

The “lower than or equals” or “le” operator helps us filtering the data based on criteria of something being “lower” than another. We’ve covered the …

OData: Lower Than or Equals Operator Read More
OData: Greater Than or Equals Operator
OData Reference / Reference

OData: Greater Than or Equals Operator

Manuel Gomesby Manuel GomesMay 7, 2021May 7, 20210

The “greater than or equals” or “ge” operator helps us filtering the data based on the criteria of something being “greater” than another. We’ve covered …

OData: Greater Than or Equals Operator Read More
OData: Lower Than Operator
OData Reference / Reference

OData: Lower Than Operator

Manuel Gomesby Manuel GomesApril 30, 2021May 7, 20210

The lower than operator is used to filter data that fit within certain criteria, in this case, something being “lower” than another. Having this on …

OData: Lower Than Operator Read More
OData: Not Equals Operator
OData Reference / Reference

OData: Not Equals Operator

Manuel Gomesby Manuel GomesApril 23, 2021May 7, 20211

We’ve already covered the “equals” operator but let’s look at its counterpart. The “not equals” operator. It provides a useful filter of data that we …

OData: Not Equals Operator Read More
OData: Greater Than Operator
OData Reference / Reference

OData: Greater Than Operator

Manuel Gomesby Manuel GomesApril 16, 2021May 7, 20210

The greater than operator helps us filtering the data based on the criteria of something being “greater” than another. Having this on numbers or dates …

OData: Greater Than Operator Read More
OData: And Operator
OData Reference / Reference

OData: And Operator

Manuel Gomesby Manuel GomesApril 9, 2021December 2, 20220

Sometimes having one operator that provides us with all the data that we need is hard, so it’s useful to aggregate several in the same …

OData: And Operator Read More
OData: Equals Operator
OData Reference / Reference

OData: Equals Operator

Manuel Gomesby Manuel GomesMarch 26, 2021May 7, 20210

Checking for equality is essential when using operators. For example, if we want to filter data, we usually use one or more equals operator(s) to …

OData: Equals Operator Read More
OData Reference: An Introduction
OData Reference / Reference

OData Reference: An Introduction

Manuel Gomesby Manuel GomesMarch 19, 2021May 26, 20220

First and foremost, OData or Open Data Protocol dates back to 2007 when Microsoft started it, being standardized later by OASIS (not the band, unfortunately) …

OData Reference: An Introduction Read More

Posts navigation

1 2 Next

Power Automate: How to parse a CSV file

August 3, 2020May 30, 2022
Power Automate: How to access Excel with a dynamic path

Power Automate: Access an Excel with a dynamic path

January 21, 2020May 25, 2022

Power Automate: Save multi-choice Microsoft Forms

February 11, 2020April 26, 2021

Power Automate: Add attachment to e-mail dynamically

September 22, 2020April 13, 2021

Power Automate: Office 365 Outlook – When a new email mentioning me arrives Trigger

December 23, 2022December 15, 2022

Power Automate: OneDrive for Business – For a selected file Trigger

December 16, 2022December 15, 2022

Power Automate: SharePoint – For a selected file Trigger

December 9, 2022December 1, 2022

Power Automate: Office 365 Excel – Update a Row action

December 8, 2022November 21, 2022
zidane - OData: Not Equals Operator

thank you for the article

Manuel Gomes - Power Automate: How to download a file from a link?

Hi Koen, Great job giving back. I'm happy you're doing it. Can you share some links so that everyone can…

Manuel Gomes - Power Automate: Long-running Flows

Hi Edison, Indeed a Flow can't call itself, but there's a way around it. You can use the "When a…

Koen - Power Automate: How to download a file from a link?

Dear Manuel, Thank you for your input in various articles, it has helped me a lot in my learning journey.…

Automatic Documentation Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Ignite Into The Weeds Investigative journalism Music New Feature New Habit News Overview Personal Development Privacy Problem Solved Productivity Security Single Source of Truth Technology Templates Tiny Tip Tutorial Writing

Want more time?

We all do.

The solution is automation.
I can help you and your company
 get back precious time.

Let's Work Together

Tags

Automatic Documentation Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Ignite Into The Weeds Investigative journalism Music New Feature New Habit News Overview Personal Development Privacy Problem Solved Productivity Security Single Source of Truth Technology Templates Tiny Tip Tutorial Writing
Copyright © 2019-2022 SKILLFUL SARDINE - UNIPESSOAL LDA.
  • Sponsor
  • Blog
  • Help
  • About
  • Privacy Policy
  • Cookie Policy
  • Login
  • Sign Up
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.AcceptPrivacy Policy