Can't filter a gallery on a subtable

(0) Share

Report

Posted on by laurent68000

Hi everyone,

I'm having trouble filtering a gallery and i would like your help !

Using a TextSearchBox, I would like to filter a table called "OUTILS" by using a field called "SITE" in the subtable called "OUTILS_SITE":

In my gallery I use Concat(Filter([@OUTILS_SITES];'ID OUTILS' = ThisItem.ID);SITE.Value) to get all the sites of each record in the label. So i thought i could use it to filter on the field "SITE": but it doesn't work:

Filter([@OUTILS]; TextSearchBox.Text in Concat(Filter(OUTILS_SITES; 'ID OUTILS'= ID);SITE.Value))

Could you help my correct the formula or maybe there's a better solution?

Thank you !!

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

bnastase 17 on at

Like
a
(1)

Report
Copy link

Link copied!

I think a lookup would be better for this case:
Filter( OUTILS, Not( IsBlank( LookUp( OUTILS_SITES, 'ID OUTILS' = OUTILS[@ID] && SITE.Value = TextSearchBox.Text ) ) ) )
laurent68000 27 on at

Like
a
(0)

Report
Copy link

Link copied!
It works 🙂 but :
If the searchbox is empty, so is the gallery (but i can find a workaround)
I wish i hadn't have to enter the entire word to get a result
Do you have a workaround the latter?
Verified answer

bnastase 17 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay.

Filter(
OUTILS,
If(
IsBlank(TextSearchBox.Text),
true,
Not(
IsBlank(
LookUp(
OUTILS_SITES,
'ID OUTILS' = OUTILS[@ID] && InStr(SITE.Value, TextSearchBox.Text) > 0
)
)
)
)
)

So for number one we can add a condition to check if the TextSearchBox is empty. If it's empty, we can show all results; otherwise, we'll filter based on the entered text. For number two instead of checking for an exact match, we can check if the SITE.Value contains the search text. This will allow for partial word matches.

Let me know if this works,
Bobby
Verified answer

laurent68000 27 on at

Like
a
(0)

Report
Copy link

Link copied!

I just replaced InStr with Find and added Lower to help get a match :

Filter(
Outils;
If(
IsBlank(TextSearchBox1_8.Text);
true;
Not(
IsBlank(
LookUp(
Outils_sites;
'ID application' = Outils[@ID] && Find(Lower(TextSearchBox1_8.Text);Lower(Site.Value)) > 0
)
)
)
)
)

It works perfectly now, thank you so much i've been stuck on this for hours !!!