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

preview_player
Показать описание
In this video, you will learn how to filter SharePoint data in Power Automate using OData Filter Query.
I will cover all different SharePoint columns and show you the various filter options you can use when filtering the data.
I will also show how to use multiple filter conditions with the "AND" and "OR" operators.

Table of Contents:
00:00 - Intro
01:20- SharePoint list walkthrough
02:10 - Filter Query on SharePoint text column(single line of text)
11:30 - Filter Query on Choice column
12:56 - Filter Query on Number column
16:08 - Filter Query on Currency column
18:49 - Filter Query on Date and Time column
21:34 - Filter Query on Lookup column
24:21 - Filter Query on Yes/No(check box) column
25:24 - Filter Query on Person or Group column

#PowerAutomate #ODataFilterQuery #SharePoint #GetItemsFilterQuery #MultipleFilters
Рекомендации по теме
Комментарии
Автор

First Time subscribing but second time watching your video on Power Automate. Very useful and valuable insight and tips. Thanks for sharing.

dougydoe
Автор

First 7 minutes of video and you already helped me fix the filtering. Very thankful.

lokokas
Автор

Thanks for sharing!!! all details of OData filter query at one place. Well presented.

god_hacker
Автор

Amazing! Keep uploading this type of valuable content 👏

vineetwadhwa
Автор

Thank you so much Deepak!! You always rocks !!

babukurapati
Автор

Hi Deepak, Could you help me with the video tutorial on Quiz App you have developed earlier ?

saikiranrudra
Автор

Thank you for this video!
I'm looking for a way to get an e-mail with the last update done in my share point list. People fill in the list and I need an e-mail to be sent to me with all the details in the same line they filled in.
I was able to create a trigger, but I get all the lines in the list (in one mail, or in separated mails), I need one mail, with the last update, every time the list is updated.
How do you suggest I do that?

gili
Автор

Hi Deepak, I am Dhanvanthri I need your help can you please upload a short video regarding how to upload image in Data verse(latest power apps version). Please respond

Rkyvp
Автор

Can we have multiple line to text in substring

shivamsahay
Автор

How to create security role for dataverse table in solutions

vallikumaresan
Автор

I do love your content and the cadence you use to go through it. Very good. But am I the only one who can't see anything you're typing on your screen? Everything is so blurry I can't even approximate what I'm looking at.

fireflecked
Автор

What if the datatype of column is Email?

madurasheetal