Unanswered

Filter Gallery by 3 other Gallery

(0) Share

Report

Posted on by Girishiam

I have the main Gallery and 3 other galleries for filter
M trying to filter the main gallery based on the title selection of the other three gallery

Tried the below logic but didn't worked

If(

Title7 = Gal1.Selected.Title7,

Filter(

'MYSPLIST',

City.Value = Gal1.Selected.Title7.Text

Title5 = Gal2.Selected.Title5,

Filter(

'MYSPLIST',

Country.Value = Gal2.Selected.Title5.Text

Title2 = Gal3.Selected.Title2,

Filter(

'MYSPLIST',

State.Value =Gal3.Selected.Title2.Text

)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Girishiam ,

Your formula return the result of the first filter based on your selections on your three filtering galleries. I guess what you're looking for is filtering your main gallery using the three secondary galleries at the same time.

If it is, then you need to actually reverse your "If()" and "Filter()" with something like this:

Filter(MYSPLIST, If(Not(IsBlank(gal1.Selected.Title7.Text)), City.Value = gal1.Selected.Title7.Text, true), If(Not(IsBlank(gal2.Selected.Title5.Text)), Country.Value = gal2.Selected.Title5.Text, true), If(Not(IsBlank(gal3.Selected.Title2.Text)), State.Value = gal3.Selected.Title2.Text, true))

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Girishiam

You didn't mention if your results should be inclusive or exclusive, so, if inclusive, then consider the following to replace your formula:

Filter('MYSPLIST', (Title7 = Gal1.Selected.Title7 && City.Value = Gal1.Selected.Title7.Text) || (Title5 = Gal2.Selected.Title5 && Country.Value = Gal2.Selected.Title5.Text) || (Title2 = Gal3.Selected.Title2 && State.Value = Gal3.Selected.Title2.Text) )

I hope this is helpful for you.

Was this reply helpful? Yes No
Girishiam 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Wizey,
Thank you for sharing!!
I tried the above condition, the gallery is not returning any record

Was this reply helpful? Yes No
Girishiam 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,
Thank you for sharing.
Expecting the exclusive results

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Girishiam ,

Something confuses me... What are those "Titlex" and "Galx.Selected.Titlex" you're comparing here? If those are components, then you're doing it wrong as you should compare their properties and not the whole object itself.

And if it's exclusive, then by reusing @RandyHayes 's formula it should be something like this:

Filter('MYSPLIST', (Title7 = Gal1.Selected.Title7 && City.Value = Gal1.Selected.Title7.Text) && (Title5 = Gal2.Selected.Title5 && Country.Value = Gal2.Selected.Title5.Text) && (Title2 = Gal3.Selected.Title2 && State.Value = Gal3.Selected.Title2.Text) )

But again, comparing "Title7" to "Gal1.Selected.Title7" for example seems wrong and may be the cause of the lack of result. If those are labels, can you try comparing their property "Text" instead?

Was this reply helpful? Yes No
Girishiam 23 on at

Like
a
(0)

Report
Copy link

Link copied!
Tried with the result.value(Text property) also bt gallery is not returning any record.
Also tried @RandyHayes solution Gallery is Returning Inclusive.
Filter('MYSPLIST', (Title7 = Gal1.Selected.Title7 && City.Value = Gal1.Selected.Title7.Text) || (Title5 = Gal2.Selected.Title5 && Country.Value = Gal2.Selected.Title5.Text) || (Title2 = Gal3.Selected.Title2 && State.Value = Gal3.Selected.Title2.Text) )
The gallery is not returning any record with this logic
Filter('MYSPLIST', (Title7 = Gal1.Selected.Title7 && City.Value = Gal1.Selected.Title7.Text) && (Title5 = Gal2.Selected.Title5 && Country.Value = Gal2.Selected.Title5.Text) && (Title2 = Gal3.Selected.Title2 && State.Value = Gal3.Selected.Title2.Text) )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Girishiam

The easiest way to work out your criteria is to know that ALL of your Boolean logic in the criteria will evaluate to either true or false. If the result is true, then the record will be included in the results. If the result is false, then it will be excluded.

So, if you look at the formula for your criteria, it is VERY specific. It states that EVERY condition in the formula MUST be true in order for the end result to be true, and thus include a record.

Remember that T && T = T, T && F = F, F && T = F and F && F = F

And that T || T = T, T || F = T, F || T = T and F || F = F

So your formula currently would (because of all the &&'s) need to have every condition true.

Not entirely sure what logic you want, but perhaps the above will give you some help.

Was this reply helpful? Yes No