Answered

Filter Gallery by User button

(0) Share

Report

Posted on by cperry07

Hey Guys,

I have a gallery where I allow the ability to filter the gallery by the buttons "All" "In Progress" "Pending" & "Complete"

I have created a collection of "ToggleCol"

I would also like to add a button where the user can filter Tasks assigned to them named "My Tasks"

I have a form that the users have the ability to add users, which in SharePoint is a Users/Groups field. They can add multiple users to an assigned task. Is there a way that I can Filter the gallery for any tasks associated with a particular user by clicking a button as well? I have tried a few different methods, but none successful. The SharePoint Column Name is 'Responsible Person'

Thanks

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @cperry07 :

I've made a test for your reference:

1\I assume there is a list:

2\Add a button and set it's OnSelect property to:

Set(ShowMyTesks,!ShowMyTesks)

3\Use this formula to get the result:

If( ShowMyTesks, Filter( cperry07List, Assign.Email = User().Email ), cperry07List )

Best Regards,

Bof

Was this reply helpful? Yes No
cperry07 63 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Since I am creating a collection for my other buttons, it does not allow me to filter the gallery by anything other than my collection for some reason.

I am trying the following code with my button, but it doesn't seem to work.

ClearCollect(ToggleCol, Filter(AARList, 'Responsible Person' = User().Email), AARList)

Chris

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cperry07 :

Please try:

ClearCollect(ToggleCol, Filter(AARList, 'Responsible Person'.Email = User().Email))

Best Regards,

Bof

Was this reply helpful? Yes No