How to Filter SharePoint items for current user in PowerApps - [Me]

Ғылым және технология

Most probably you know how to filter items inside a SharePoint for current user using [Me] filter. In this lecture we would like to do the exact same thing in PowerApps. We have a SharePoint list with person field (multi select and single select) and we would like to filter list items displayed in a PowerApps Data table.
To enroll in my Udemy courses see below link for discount vouchers
sslwsh008.securedata.net/dotn...
This video contains
0:00 Introduction
0:55 Setup and problem definition
1:50 Adding [Me] filter directly to SharePoint list view
2:48 Creating Single-select person field filter in PowerApps
6:10 Creating Multi-select person field filter in PowerApps
12:03 Conclusion
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb

Пікірлер: 22

  • @MeetJorgeh
    @MeetJorgehАй бұрын

    The silly girl at the end got me to subscribe! 😂 love the vid!

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

    Perfect timing! I was stuck on the Filtering thing. Thank you for getting me past that roadblock.

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

    Highly informative and practical scenario video , to filter data based on current user login

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

    Many Thanks Ali. This functionality I was looking for a long time. You explained the concept in a very simple way. Thanks a lot as always. 🙂

  • @GS-mz6nf
    @GS-mz6nf3 ай бұрын

    This helped so much thank you ❤

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

    Nice video. Thanks

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

    I know the video will be informative as usual Thanks

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

    Your are love sir g.

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

    Thank you Alireza, exactly what I was looking for 😊

  • @AlirezaAliabadi

    @AlirezaAliabadi

    Жыл бұрын

    Thank you! It was your idea anyway 🙂

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

    Many thanks Ali. If it's not too much to ask, along with data table, pls include Gallery filter to give kinda comparison in terms of view and behaviors pls.Love from India

  • @shafeequeva5986
    @shafeequeva59865 ай бұрын

    Thanks Man

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

    Thank you for the video, Alireza! I think a warning related to delegation would've been great for beginners that will rely on this solution on SharePoint lists containing more than 2000 records.

  • @AlirezaAliabadi

    @AlirezaAliabadi

    Жыл бұрын

    It's always a challenge for me when I make videos like this. On one side I consider some audience may not understand delegation and on the other side I I see some busy developers that they just open the video to get the answer to their current problem and get back to work. On the same note, delegation needs a separate video on it's own. I definitely consider that.

  • @kedar910

    @kedar910

    3 ай бұрын

    Thanks Ali. Your videos are super helpful. Your 'you know I don't like 3 columns' is a signature to look for 😀.. This video so timely for me. However, on the delegation bit I am not sure I understand the problem. I just thought you clearly stated that this is a delegable filter?

  • @MohammadAli-ts2ev
    @MohammadAli-ts2ev Жыл бұрын

    Hi Ali Reza, "In" is a non deligable function. So, is there a way to filter more than 2k records

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

    Awesome video! How would I just return one filtered column from my SharePoint list to use as items for a combo box?

  • @AlirezaAliabadi

    @AlirezaAliabadi

    Жыл бұрын

    Your answer is in the video 11:37 Simply set the "Items" property of the combo box to ListName.ColumnName

  • @big1975E

    @big1975E

    Жыл бұрын

    @@AlirezaAliabadi thank you!

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

    Thanks for the very nice example. 🙂👍 Is there any substitute for IN function here for delegation issue?

  • @AlirezaAliabadi

    @AlirezaAliabadi

    Жыл бұрын

    IN has 2 different behaviors. Sometimes you use IN to see if a substring exists in a string. On the other side you may use IN to see if an exact string exists in an array of strings. The delegate issue in here has nothing to do with IN. The issue is you have a table inside another table. I may consider a video about delegation in PowerApps and close this chapter once and for all, simply because I get lots of questions about it.

  • @adityadeshmukh3150

    @adityadeshmukh3150

    Жыл бұрын

    @@AlirezaAliabadi Thanks 😊

Келесі