Skip to content
July 3, 2022

Manuel T. Gomes

Want to know more the Power Platform or Microsoft 365? You're at the right place.

  • Home
  • Power Platform
    • Power Automate
    • Power Apps
  • Microsoft 365
    • SharePoint
    • Microsoft Planner
    • Microsoft Teams
    • Microsoft Forms
    • Microsoft Lists
    • Microsoft Graph
    • Microsoft 365 Excel
    • Office 365 Outlook
    • OneDrive
    • OneDrive for Business
  • Reference
    • Power Automate Function Reference
    • Power Automate Trigger Reference
    • Power Automate Action Reference
    • SharePoint List Function Reference
    • Power Apps Function Reference
    • Power Apps: Delegable Functions Reference
    • OData Reference
  • Expressions and Templates
    • Expressions
    • Templates
  • Platforms
    • Azure
      • DevOps
    • Twitter
  • |
  • Login
  • Register
  • Home
  • Power Platform
    • Power Automate
    • Power Apps
  • Microsoft 365
    • SharePoint
    • Microsoft Planner
    • Microsoft Teams
    • Microsoft Forms
    • Microsoft Lists
    • Microsoft Graph
    • Microsoft 365 Excel
    • Office 365 Outlook
    • OneDrive
    • OneDrive for Business
  • Reference
    • Power Automate Function Reference
    • Power Automate Trigger Reference
    • Power Automate Action Reference
    • SharePoint List Function Reference
    • Power Apps Function Reference
    • Power Apps: Delegable Functions Reference
    • OData Reference
  • Expressions and Templates
    • Expressions
    • Templates
  • Platforms
    • Azure
      • DevOps
    • Twitter
  • |
  • Login
  • 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
Bookmark

Please login to bookmark

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, 2021May 21, 20210
Bookmark

Please login to bookmark

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
Bookmark

Please login to bookmark

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
Bookmark

Please login to bookmark

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
Bookmark

Please login to bookmark

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, 20210
Bookmark

Please login to bookmark

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
Bookmark

Please login to bookmark

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, 2021May 7, 20210
Bookmark

Please login to bookmark

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
Bookmark

Please login to bookmark

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
Bookmark

Please login to bookmark

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: Save multi-choice Microsoft Forms

February 11, 2020April 26, 2021
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: Add attachment to e-mail dynamically

September 22, 2020April 13, 2021

Introducing your personal area

March 7, 2022May 25, 2022

Power Automate: How to generate an URL to an email?

March 1, 2022June 8, 2022

Power Automate: Long-running Flows

February 28, 2022May 27, 2022

Introducing the Reference and Bargain Bin

February 21, 2022May 27, 2022
Tyler - Power Automate: When Excel can make things easier

Need to update and/or create many rows in Excel? Try Excel batch actions in Power Automate: https://youtu.be/HiEU34Ix5gA

Erik - Power Automate: Access Excel with a dynamic path II

Are the path and file supposed to be swapped - like in the example image of the http step?

Admin User - Power Automate: Compose Action

Hi Suez, If you want to add as in the math operation you can use the add function. You can…

Suez Cordova - Power Automate: Compose Action

What is the Compose action expression for adding more than 2 variables?

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

LATEST

Introducing your personal area

March 7, 2022May 25, 2022

Power Automate: How to generate an URL to an email?

March 1, 2022June 8, 2022

Power Automate: Long-running Flows

February 28, 2022May 27, 2022

Introducing the Reference and Bargain Bin

February 21, 2022May 27, 2022

Power Automate: SharePoint Add attachment action

February 16, 2022May 25, 2022

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.
  • Blog
  • About
  • Privacy Policy
  • Cookie Policy
  • Livro de Reclamações
  • 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