Part 5 - PowerApps Delegation & Gallery Filtering using Person column (single and multi select) 

I have got a lot from your 5 videos. Thank you!

Hi Reza. Whenever I need to figure out how to do certain things in PowerApps I check out your channel. I just watched your series on delegation and picked up a lot of pointers form them. You are so good at explaining things and showing how-to's. Thank you so much for sharing your knowledge!

I looked far and wide for a solution to filtering by a multi person column. Only you could have broken this problem down into segments and provided such a practical solution. You are amazing, thanks a mil Reza.

Reza, thanks ever so much! Watching along so that I understand each of your videos is some of the best time I've spent -- ever -- learning PowerApps! Wish I'd have found these earlier. You're such an excellent teacher!

Thank you so much, Reza. I asked for a lot of help but only you finally solved my problem. Every time I watch your video I gain a lot!!!

Thank you Raza, excellent videos.

Thank you. I find your explanations to be precise and very clear. Learned a lot from your videos. Is there a way to convert a normal Gallery with all its functionality to a flexible Gallery? I have a lot of functionality built in a gallery in my application and then ran into the issue of delegation warning of filtering on multiple choice column.

Hi Reza, This is really useful, thanks a lot for sharing these great videos. I have implemented the 'visible' rule explained on part 4 of the tutorial but I am not able to combine it with a single select combo box. Is there a way to do that and combine single select and multiple select combo box to filter gallery?

Hi Reza, your videos are really great. I take copious notes every time! I have a gallery with 3 different person columns that my users wish to filter by via drop down controls. I tried creating a collection and adding columns to capture the display names, but it caused issues in the app such as trouble showing newly added items in the gallery. Is there a different approach I could try?

Hi Reza ,I have one canvas app in this there is one column named assigned owner and there is one button named my view if I click those buttons it will show the document of current user assigned in gallery ..any idea

Hi Reza, How we can set the flexible High of row in the gallery when row is hide them visible row should reflect in sequence

I revisited these videos this weekend as a refresher on Delegation, thank you for a great series. Would love to see some video's on using Dataverse in Canvas Apps, I am having a little bit of an issue with Filters on Multiselect Combo's in Dataverse, I'm hoping your example here will help. Thanks Reza

Hi, I am trying to filter from my List where a Assigned To column is set to MultiSelected Column, how can I filter that using the MyPeople collection in your video?

Very Useful. I have a gallery with two dropdown which helps me filter data. 1. ‘Review Manager’ which is of type choice where values are added manually. 2. ‘Approve Manager’ of type people/group. Now I wanted to create a filter in such a way that based on current user logged in, it first matches with ‘Review Manager’ if found it will filter the gallery as well as only his name to he displayed in the drop down option so he can’t view somebody’s else, same with ‘Approve Manager’. Can you help please.

Hi Reza. May I know if possible to add photos of the students (in my case, employees from Sharepoint List) to this?

Hi Reza, great video - thank you! How can I reverse this formula so that it shows all items where the user's name isn't in a column? I've tried adding ! before my variable (also varUserEmail) but this returns no items (it should return all). This is for a voting app, so I want to make items that users have already voted on hidden.

Hi, i implement the same approach in my list which has less than 100 records. It worked fine without any warning. But when I tried to implement the same with the variable in my production list which has more than 5k items, the warning does not gets removed even after storing the user (). Email function in variable in on start property of app. My production list has two people column of site admin and site owner respectively.Both are multiselect user type. I want to filter data based on the user who could be part of any of these two people columns.

Does Releasing new changes in PowerApps impact on existing apps (Release Management)

Hi Amazing Video. I just have issues. I have a list over 2000 elements and gallery is slow and have blank spaces

Looking to countrows(Gallery1.Allitems) that also doesn't count the !visible 0 height rows. Thoughts? Also thanks for the vids. Usually my go to sub for solutions.

It is along story, but our Azure email extension is different then our display email. Can you think of anyway for me to get around this. The above video as create as it is, does not work

Hi Reza, thank you for making this video. How can I show all the results from the beginning? and how can I show all the results if I am not filtering for anything? thank you

Hi Reza i need to filter my gallery based on login user comparing with share point list person type multiple select column. If the person type column user email is equal to login user email means i want to filter my gallery with that user, otherwise i will show all records in my gallery,In this video you telling within that sharepoint list column and we can easily hide and show the record with same datasource person type column. But my gallery data scource is not have an person data type column, i use the lookup function and filter the record based on login user. I already tried with add column to add that person data type column to my gallery data source and filter through that column.But the problem is add column limit is only 500?after 500 records how can i retrieved... And my question is With in the filter function add column delegate or not? Is this possible to retreive the person data type column user email to variable in App.Onstart? Kindly help me reza i have struggling with this since last week i didn't get any idea...🥲 Note:Multiple select person type column

Great video as always. Congrats. I did the same thing however my hidden items appears as blank spaces in the middle of gallery. If only last item is visible I have to navigate all gallery to find it. How do I fix It?

Great you touch all important and pain point of Power apps. is there easy option for cascading of drop-down ? again appreciate your effort ..

Hi Reza, I want to display all the items for admins and for non admin users want to show only their items. Is it possible with above solution? I have multi select person column but with the solution mentioned, for even admin also it is showing admin items only not all.

as always, great tutorial! While experimenting on this i got an issue with a sharepoint Person Type Column. Inside my Gallery the column is loaded correctly and i can access to its property with ThisItem.ColumnName.email or ThisItem.ColumnName.Picture. When i write the Search function on the Gallery, it won't accept the Person Column as parameter. I tried Search(MyData,SearchBar.Text,ColumnName.DisplayName,"Column1",ColumnName.DisplayName) but it gives me an error. How can i fix it? Thank you so much

Hi Reza, Long time viewer and very helpful videos. How can I filter people in a drop-down based on a condition from another sp list column?? I have list of lots of people in the person column and their job title in another column, and I am trying to filter people based on their job titles. Thanks in advance, and keep doing the good work.