Multiple filter based on condition

(0) Share

Report

Posted on by nimesh898

hi xpert i am trying to create a gallery where i have a role

1. super user/Admin

2. user or the user team who created a record

now am trying to insert a filter which is supposed to work on a filter but the filter is only working when i select the drop down. the dropdown are not being linked. neither the sorting ....

If(
 ComboBox1_1.Selected.Value = "All" || Dropdown4.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 = ComboBox1_2.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))),
 Filter(
 Records,
 (IsActive = true && 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 && Location = ComboBox1_1.Selected.Value && 'Organizational Id' = Dropdown5_1.Selected.Value && 'Status (crbb3_Status)'.Value = ComboBox1_2.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 && 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)
 )
 )
)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@nimesh898 - seeing Blank is correct, because none of the strict criteria you have applied to your Filter expressions are being met.

I would suggest you should rethink what you're trying to do logically. At present, you're using multiple AND conditions which means that ALL criteria must be met before the Gallery displays any data.

------------------------------------------------------------------------------------------------------------------------------

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.

Imran-Ami Khan
nimesh898 52 on at

Like
a
(0)

Report
Copy link

Link copied!

can you suggest me the solution am lost
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I cannot provide you with a solution because I do not know what you want your filter criteria to be.

As already mentioned, your expression is returning blank because that is what you have designed your expression to do.

You need to rethink how strict your Filter criteria needs to be. I would provide the same advice to the other duplicate threads you separately have with @BCBuizer and @SpongYe.