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

[@MeetJorgeh]

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

[@jeffscott9335]

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

[@jagirdarhammad2184]

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

[@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]

This helped so much thank you ❤

[@radiance7906]

Nice video.
Thanks

[@radiance7906]

I know the video will be informative as usual
Thanks

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

[@abbasthegreat5]

Your are love sir g.

[@shafeequeva5986]

Thanks Man

[@panteag1983]

Thank you Alireza, exactly what I was looking for 😊

[@AlirezaAliabadi]

Thank you! It was your idea anyway 🙂

[@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]

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]

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]

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

[@adityadeshmukh3150]

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

[@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]

@@AlirezaAliabadi Thanks 😊

[@big1975E]

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

[@AlirezaAliabadi]

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

[@big1975E]

@@AlirezaAliabadi thank you!