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

This is part 5 of my PowerApps delegation Vlog series - PowerApps Delegation & Gallery Filtering using Person column (single and multi select)

This video will walk you through the concept of achieving delegation and filtering with Person column

Part 1 - What is delegation in PowerApps

Part 2 - Delegation with SharePoint Date columns

Part 3 - Delegation with Choice, Lookup & Yes/No columns (SharePoint)

Part 4 - Delegation with Multi Choice/Lookup columns (SharePoint)

[kharchenko]

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

[jt]

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!

[IamSanjayPersad]

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.

[cztop]

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!

[Tracy_Cai]

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!!!

[LauraForcella]

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?

[notonurnelly]

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

[afkarerizwan]

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.

[BiharKiShaan]

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.

[Gymnastics_girl-UK]

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.

[alessandramacedo]

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?

[siddhkishan]

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

[jaspreetsingharora]

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.

[ZeyaulHoda]

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

[teresaagustin]

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?

[madhanlakshmanan]

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

[Thaara]

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

[nancystevens]

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

[glenbertlobino]

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

[kanwalsaini]

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.