Advanced filter gallery

(0) Share

Report

Posted on by nimesh898

hi Expert,

i have a table named user management in dataverse

Name	Email	Team Name	Role	Team Code
tom hary	tom.harry@xyz.com	Alpha	User	16325
tom jerry	tom.jerry@xyz.com	Tango	user	636
Beast Mode	Beastmode@xya.com	Corp	Admin	CorpA
Bold Man	boldman@xyz.com	Corp	SuperUSer	CorpU

and i have record list in dataverse which record the item.

now i have a galllery where i want to filter the REcord list under following condition:

1. Admin and super user can see all item

2. User and his team can see the item created by their team

3. Filter the item by gender (All, Male, Female) and Status(All, open, close, pending) and organisation

you expertise will definately help.

Thank you in advacne

the Gallery

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

SpongYe 5,715 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @nimesh898

I try to create a code how it should look like.
On your Gallery.Items:
If( LookUp(colUsermangement, Email = User().Email).role = "Admin" || LookUp(colUsermangement, Email = User().Email).role = "SuperUSer", Filter(colItems, Gender = Dropdown1.SelectedText.Value, Status = Dropdown2.SelectedText.Value, Organisation = Dropdown2.SelectedText.Value), LookUp(colUsermangement, Email = User().Email).role = "User" Filter(colItems, CreatedByTeam = LookUp(colUsermangement, Email = User().Email).'Team Name' ,Gender = Dropdown1.SelectedText.Value, Status = Dropdown2.SelectedText.Value, Organisation = Dropdown2.SelectedText.Value) )

You only provided the user management table in dataverse because I was missing the other for the created items..
Please adjust the code accordingly to make it work.

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
nimesh898 52 on at

Like (1)

Report
Copy link

Link copied!
Hi Thank you for your response but
If( LookUp('User Managements', Email = User().Email).Role = 1 || LookUp('User Managements', Email = User().Email).Role = 3, Filter(Records, Location = ComboBox1_1.Selected.Value, 'Status (crbb3_Status)'.Value = ComboBox1_2.Selected.Value, 'Organizational Id' = ComboBox1_3.Selected.Value), LookUp('User Managements', Email = User().Email).Role = 2, Filter(Records,'Organizational Id'=LookUp('User Managements', Email = User().Email).'WR Organization Name',Location = ComboBox1_1.Selected.Value, 'Status (crbb3_Status)'.Value = ComboBox1_2.Selected.Value, 'Organizational Id' = ComboBox1_3.Selected.Value))

when i add this record am getting error in this highlighted part.

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @nimesh898

Youre checking two different columns:

'Organizational Id' = LookUp('User Managements', Email = User().Email).'WR Organization Name'

Is that correct? and what is the error that your getting?

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
nimesh898 52 on at

Like (0)

Report
Copy link

Link copied!

yeah i have user management table which has a column name organisation Name.

Was this reply helpful? Yes No
nimesh898 52 on at

Like (0)

Report
Copy link

Link copied!
SortByColumns( If( ComboBox1_1.Selected.Value = "All", Filter( Records, (IsActive = true && 'Created By'.'Primary Email' = User().Email && 'Organizational Id' = ComboBox1_3.Selected.Value) || (IsActive = true && 'Organizational Id' = Dropdown5_1.Selected.Value && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value && 'Organizational Id' = ComboBox1_3.Selected.Value) ), If( // User Management Access: Disable access to user role Not( IsBlank( LookUp( 'User Managements', Email = User().Email && Role = 1||Email = User().Email && Role = 3 ) ) ), Filter( Records, (IsActive = true && cr65c_location = ComboBox1_1.Selected.Value && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value && 'Created By'.'Primary Email' = User().Email && 'Organizational Id' = ComboBox1_3.Selected.Value) || (IsActive = true && cr65c_location = ComboBox1_1.Selected.Value && 'Organizational Id' = Dropdown5_1.Selected.Value && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value && 'Organizational Id' = ComboBox1_3.Selected.Value && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value) ), Filter( Records, (IsActive = true && 'Start Date' <= Today() && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value && cr65c_location = ComboBox1_1.Selected.Value && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value && 'Organizational Id' = ComboBox1_3.Selected.Value && 'Status (crbb3_Status)'.Value = Dropdown4.Selected.Value) ) ) ), "crbb3_startdate", If(varSortStartD=true,SortOrder.Ascending,SortOrder.Descending) )
i even tried tthis code but still faced the same issue?

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What is the issue/error that its giving?

Was this reply helpful? Yes No
nimesh898 52 on at

Like (0)

Report
Copy link

Link copied!

i figure it out but thanks for your guidance though

Was this reply helpful? Yes No