How to: OData filter in Power Automate on Dataverse lookup field

Показать описание

Writing an OData Filter in Power automate to filter records based on a Lookup field value has always been a challenge. In this video you will understand the logical and schema names in Dataverse. That should be good enough for you to never Google this filter.

This video contains
0:00 Introduction
0:44 Setup and involved tables
1:13 Understanding Dataverse lookup field
2:53 Creating the flow and writing OData filter
5:15 Testing the solution
6:02 How to add lookup field to Select action
8:10 Free course coupon

Contact me

Рекомендации по теме

Комментарии

I think this video is going to help a lot of people and clear confusions. If this applies to your case, please leave a comment and let me know. 😊

AlirezaAliabadi

Saved my life and a lot of time. Thank you so much.

sangrampradhan

Thank you much;
If i could, i'ld have liked 100 times!!!

You saved my day!

StephCoul

Alireza, I'm hopeful that Power Automate will make these a little easier to select/understand in the future, but your video brilliantly walks through how to get what you're looking for. Keep the content coming!

patrick

Awesome as always, Alireza! Thank you

AdiCristea

You just saved my day !! Thanks a lot for this vidéo ;)

Cybermatik

Great Content, loved the way you demonstrated. Thank you.

I've a query: How can we write the ODATA filter query where Column A is of Type "Person or Group" in SharePoint and is a multiselect? example: Column A is called Department, Column B is Employees. One department can have multiple employees, so How can we make the ODATA filter so we get All the departments where Employee1(email of employee) is a part of?

iamdeepshekhar

Is it will work with Triggers Actions....

cambly

Great and clear topic as usual, quick question 🙋🏻 in which Udemy course we’ll get this video?

PowerPlatformDiv

If we use this voucher then the course on udemy will be free?

Learnpowerplatform

How to: OData filter in Power Automate on Dataverse lookup field

Learn to master Filter Query OData Part 16

sap odata $Filter select Options

How to: OData filter in Power Automate on Dataverse lookup field

How to use OData filter in Power Automate on SharePoint lookup columns

Power Automate OData Filter Query flow for SharePoint list

OData filtering using Microsoft Flow and Azure Logic Apps

Power Automate Flow odata filter dataverse lookup and choice columns

Filter Query for SharePoint Get Items action in Power Automate MADE EASY!

OData & SAP Netweaver Gateway - 021 Step 8 Implement Filter Logic

sap odata query parameters

Power Automate: Abrufen von SharePoint Listenelementen mit ODATA-Filter

Power Automate - How to Filter Rows using OData / OData Syntaxes Cheatsheet

⏰ 2 minutes OData row filtering ⚡ with Microsoft Power Automate 🔮

Be smart about Business Central OData, $filter like a Pro!

Power Automate OData Filter Query Flow for Dataverse

Using OData to filter date in Microsoft Power Automate

Power Automate Tutorial: Filter SharePoint List with OData and Export to CSV

2 Get Data From ODATA Feed in POWER -BI

Video 31 - OData Service - Filter and Sort

Filtering Microsoft Power Automate “Get Items” with Filter Query

Azure Search Filter and Facets OData Expression

OData Filter on Array Property: Returning Empty or Non-Empty Arrays

SharePoint Online with Rest API oData Operations($select,$filter,$Top,$expand-Lookup ) - Part 3

Filter SharePoint Data in Power Automate using OData Filter #PowerAutomate #ODataFilter #SharePoint