Text seach in Gallery no longer works when set from other screen

[TheAudioPolice]

Hi, 

I need to create a searchable gallery based on a textfield. So far so good: 

SortByColumns(Filter(Ledenadministratie, TextSearchBox1.Text in Lidno || TextSearchBox1.Text in Achternaam), "Lidno")

Works great.

Now, I need to set the Gallery items from a second screen by using Icon.onSelect: 

Set(Filterlist1,SortByColumns(Filter(Ledenadministratie, Type.Value = "Lid"), "Lidno"));Navigate(ZoekScherm,ScreenTransition.None)

Gallery.items = Filterlist1

Also works... 

But now, I would like to search in that filtered list. And that's where stuff breaks: 

Set(Filterlist1,SortByColumns(Filter(Ledenadministratie, TextSearchBox1.Text in Lidno || TextSearchBox1.Text in Achternaam), "Lidno"));Navigate(ZoekScherm,ScreenTransition.None)

After setting the gallery options and transitioning to the screen, the gallery no longer updates when changing the value of the textfield.

What did I miss? 

[iAm_ManCat]

You don't need to set the variable - you have created a static list that does not reference the TextSearchBox,

So this is not needed: 

Set(Filterlist1,SortByColumns(Filter(Ledenadministratie, Type.Value = "Lid"), "Lidno"));Navigate(ZoekScherm,ScreenTransition.None)

Instead you filter your second gallery similar to this:

Gallery.items = SortByColumns(Filter(Ledenadministratie, Type.Value = "Lid", TextSearchBox1.Text in Lidno || TextSearchBox1.Text in Achternaam), "Lidno")

[TheAudioPolice]

thanks for the reply, I'm however not sure how that would help me. 

Your example results in a fixed gallery list which I can search, which I already had in step 1.

What I want to achieve, is a gallery result that is filtered based on criteria set on another page (in my case, in a number of icons.onselect actions), and have a search field that searches within that subset. Basically a nested filter.

At this stage, I can create the first filter to produce the subset of data that I want in the Gallery. However, I can't get the 

TextSearchBox1.Text in Lidno || TextSearchBox1.Text in Achternaam

 part to work in that subset when I pass it through the OnSelect action. There is no error, it just does nothing. 

When I replace that part with a specific second filter criteria (static), it does the job. There's no "OnChange" action that happens like in the first scenario. 

[iAm_ManCat · Accepted solution]

Ahhh, ok, well what I was suggesting will still work in that fashion, we are assigning static search variables to filter the gallery by then having some that can still be searched by.

So, those icons.onselect, you have them set a variable, not create a whole filtered gallery as a variable

So for example you could do something like

On the icon page, (So that we can distinguish whether search parameters have been set)

OnVisible=
Set (Filter1, "NoValue");
Set (Filter2, "NoValue");
Set (Filter3, "NoValue")

and for the icons onSelect

icon1.onSelect = Set (Filter1, "FirstValue")
icon2.onSelect = Set (Filter2, "SecondValue")
icon3.onSelect = Set (Filter3, "ThirdValue"

Then your second gallery, which you want pre-filtered already by the icons, but also searchable using the textbox:

Gallery.items =
SortByColumns(
   Filter( Ledenadministratie,
           Type.Value = "Lid",
           //AND
           (Filter1.Value = "NoValue" || Column1 = Filter1.Value),
           (Filter2.Value = "NoValue" || Column2 = Filter2.Value),
           (Filter3.Value = "NoValue" || Column3 = Filter3.Value),
           //AND this OR Block below to enable further filtering by searching
           TextSearchBox1.Text in Lidno || TextSearchBox1.Text in Achternaam
         ),
   "Lidno"
)

So we are filtering by Type.Value being equal to "Lid", then we are saying

Filter by Filter1.Value = "NoValue" - which will return true if the value is 'un- set' and then not filter by that choice, or else filter by Column1 having a value equal to Filter1.Value

Alternatively,

You could put blank toggles on top of your icons, and have the toggles set variables/colours onCheck and on Uncheck:

I've attached a Proof of concept app for the hidden toggles if you want to have a look,

Cheers,

@iAm_ManCat

[v-xida-msft]

HI @TheAudioPolice,

Could you please share a bit more about your scenario?

Do you type your Set formula within the OnSelect property of the Icon button (set your Filterlist1 variable within the OnSelect proeprty fo the Icon button?)?

Based on the issue that you mentioned, I think there is something wrong with your Operation. You should not put your Set formula within the OnSelect property of the Icon button.

If you type your Set formula within the OnSelect property of the Icon button, the Set formula would be executed only when you click the Icon button. If you changed the text value within your Text Search box, the Filterlist1 variable would not be updated automatically.

As an alternaitve solution, I think the Timer control could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Add a Timer control within your app, set the Duration property to following:

1000

set the AutoStart property and Repeat property to following:

true

set the OnTimerEnd property to following:

Set(
    Filterlist1,
    SortByColumns(Filter(Ledenadministratie, TextSearchBox1.Text in Lidno || TextSearchBox1.Text in Achternaam), "Lidno")
)

Set the Visible property of the Timer control to following:

false

Set the OnSelect property of the Icon button to following:

Navigate(ZoekScherm,ScreenTransition.None)

Best regards,

[iAm_ManCat]

A timer to repeatedly pull data from the server every second seems like an extremely inefficient way to do this and will result in 60 data source calls per minute, which on a mobile device would be a large overhead and many delays - also if you have 500 users with the app running then... that's 3000 calls to server per minute.

I'm sorry but this does not seem like good advice to me.

You can have the items clickable and then each of them set a filter that a gallery is filtered by - the filtering of the gallery and the data source call then only happens when you change one of the values by clicking the icon.

I've updated my POC app to include the gallery, A Day filter (Title filter), filtered by the choices made by clicking the icons, and to be searchable - I've attached this.

Gallery with no filters applied:


Click the Write icon, Gallery filters with anyone who has a Write value in the Write column:

..then clicking the Food icon filters the gallery by those who have Write in the Write column and Food in the Food column

...then filtering by those who have Write in Write Column and Speech in Speech column:

...then searching within that subfiltered list for only 'john':

...then clearing that search filter and filtering the gallery additionally by the Day dropdown, Write and Speech:

...then searching for rae within that already 3x filtered list (Filtered by Day, filtered by Write, filtered by Speech):

[TheAudioPolice]

Thanks all, 

I need to get my head around the demo app; the testfilterlist is missing, but I'll figure it out.

Standby...

[TheAudioPolice]

Works brilliantly. 

I now need to get working on a date filtering, but I'll address that in a different post. Thanks again!