Unanswered

filtering more than 1 gallery with an "All" option

(0) Share

Report

Posted on by joybre

So I have an initial page that has 3 filter gallery options and then a final dropdown that would select by name.

If(
FG_FLAG = "All",
Filter(
'Master Project List',
'Site/Function' in S_FLAG
),
Filter(
'Master Project List',
'Project Type'.Value in FG_FLAG && 'Site/Function' in S_FLAG && 'Project Phase'.Value in PS_FLAG,
'Project Leader'.DisplayName = Dropdown7.SelectedText.Result
)
)

The above is the code im using, I can get the "All" option to work and it brings back everything and then I can select the other gallery options and returns the desired results.

But the bit that im struggling with is that if you dont first select the "All" option in the first gallery none of the other filters work separately.

Any help will be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@joybre

Try

Filter( 'Master Project List', FG_FLAG="All"||Site/Function' in S_FLAG, 'Project Type'.Value in FG_FLAG, 'Project Phase'.Value in PS_FLAG, 'Project Leader'.DisplayName = Dropdown7.SelectedText.Result )

Was this reply helpful? Yes No
joybre 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for answering, sorry have tried this and am getting 0 results at all now.

Was this reply helpful? Yes No
joybre 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Im getting a delegation warning as it will be running across a large data set. is there any way round this?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@joybre

The "in" operator is not delegatable in SharePoint. Either "=" or StartsWith() can be used with large lists.

Was this reply helpful? Yes No