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

  • @dougydoe
    @dougydoe2 жыл бұрын

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

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    Thank You 🙏🏻

  • @ShihChiWang
    @ShihChiWang2 жыл бұрын

    Very useful! Thank you.

  • @lokokas
    @lokokas2 жыл бұрын

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

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    You're welcome!

  • @god_hacker581
    @god_hacker5812 жыл бұрын

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

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    Glad it was helpful!

  • @vineetwadhwa5915
    @vineetwadhwa59152 жыл бұрын

    Amazing! Keep uploading this type of valuable content 👏

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    Thank You!

  • @babukurapati5611
    @babukurapati56112 жыл бұрын

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

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    My pleasure 😊. Thank You!

  • @rajasekar5069
    @rajasekar50692 жыл бұрын

    Very useful.... 👍🏽

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    Glad it was helpful!

  • @bellam2413
    @bellam2413 Жыл бұрын

    thank you

  • @sundrapillay6668
    @sundrapillay66682 жыл бұрын

    Thanks Deepak

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    Welcome

  • @saikiranrudra4308
    @saikiranrudra43082 жыл бұрын

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

  • @vallikumaresan
    @vallikumaresan2 жыл бұрын

    How to create security role for dataverse table in solutions

  • @DeepakShrivastava

    @DeepakShrivastava

    2 жыл бұрын

    I will add this topic to my list. Thanks for suggestion.

  • @2210gili
    @2210gili Жыл бұрын

    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

    @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.

  • @shivamsahay1994
    @shivamsahay19945 ай бұрын

    Can we have multiple line to text in substring

  • @DeepakShrivastava

    @DeepakShrivastava

    5 ай бұрын

    You should be , can you explain what are you trying to achieve so I can understand better

  • @amberschiffer3844
    @amberschiffer3844 Жыл бұрын

    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.

  • @madurasheetal4906
    @madurasheetal4906 Жыл бұрын

    What if the datatype of column is Email?

  • @Rkyvp963
    @Rkyvp9632 жыл бұрын

    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

    @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

    @Rkyvp963

    2 жыл бұрын

    @@DeepakShrivastava thank you so much for your response.

  • @RajeevSirMathCoaching
    @RajeevSirMathCoaching2 жыл бұрын

    New subscriber Same hope from u

Келесі