cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheAudioPolice
Level: Powered On

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

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? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

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:
image.png

 

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

 

Cheers,

@iAm_ManCat




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!

View solution in original post

7 REPLIES 7
Super User
Super User

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

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")

 




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!
TheAudioPolice
Level: Powered On

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

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. 

Super User
Super User

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

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:
image.png

 

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

 

Cheers,

@iAm_ManCat




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!

View solution in original post

Community Support Team
Community Support Team

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

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

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

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:
image.png

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

 

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


 

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

 

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

image.png

 

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

image.png

 

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

image.png

 

 




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!
TheAudioPolice
Level: Powered On

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

Thanks all, 

 

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

Standby...

TheAudioPolice
Level: Powered On

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

Works brilliantly. 

 

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 291 members 5,641 guests
Recent signins:
Please welcome our newest community members: