Filter SharePoint Data in Power Automate using OData Filter
Ғылым және технология
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
Пікірлер: 29
First Time subscribing but second time watching your video on Power Automate. Very useful and valuable insight and tips. Thanks for sharing.
@DeepakShrivastava
2 жыл бұрын
Thank You 🙏🏻
Very useful! Thank you.
First 7 minutes of video and you already helped me fix the filtering. Very thankful.
@DeepakShrivastava
2 жыл бұрын
You're welcome!
Thanks for sharing!!! all details of OData filter query at one place. Well presented.
@DeepakShrivastava
2 жыл бұрын
Glad it was helpful!
Amazing! Keep uploading this type of valuable content 👏
@DeepakShrivastava
2 жыл бұрын
Thank You!
Thank you so much Deepak!! You always rocks !!
@DeepakShrivastava
2 жыл бұрын
My pleasure 😊. Thank You!
Very useful.... 👍🏽
@DeepakShrivastava
2 жыл бұрын
Glad it was helpful!
thank you
Thanks Deepak
@DeepakShrivastava
2 жыл бұрын
Welcome
Hi Deepak, Could you help me with the video tutorial on Quiz App you have developed earlier ?
How to create security role for dataverse table in solutions
@DeepakShrivastava
2 жыл бұрын
I will add this topic to my list. Thanks for suggestion.
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?
@DeepakShrivastava
Жыл бұрын
if you are looking to get just the chnages - there is an action in SharePoint connetor "Get changes for an item or a file (properties only) 2" that you should use.
Can we have multiple line to text in substring
@DeepakShrivastava
5 ай бұрын
You should be , can you explain what are you trying to achieve so I can understand better
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.
What if the datatype of column is Email?
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
@DeepakShrivastava
2 жыл бұрын
I will add this to my list, I am interested to know how many more people want to see something on this topic.
@Rkyvp963
2 жыл бұрын
@@DeepakShrivastava thank you so much for your response.
New subscriber Same hope from u