Reset Gallery and Textinput with only 1 button

(0) Share

Report

Posted on by FZ80

148

Can you help me with this:

A 'clear' button becomes vissible when entering text in a searchfield (Textinput). OnSelect of this button formula is: Reset(TbSearchInput). This works fine.

The searchresults are shown in a Gallery1. How do I adapt the formula in a way that OnSelct the searchfiels as wel as the Gallery will be Reset so that no previous results are shown.

I tried this 2 adaptations but both do not reset the Gallery1.

1. Reset(TbSearchInput);Reset(Gallery1)

2 Collect( [TbSearchInput, Gallery1], Reset )

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

@FZ80

Please provide the items formula of gallery. if you are using textbox input as filter condition. Once you clear the Text input, gallery resets automatically.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
This is the Fx I use:
Items Fx: Distinct(Filter(TblSAK; StartsWith(Storing; searchQuery)); Storing)

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FZ80 ,

You can try the following:
If( !IsBlank(searchField), Distinct(Filter(TblSAK; StartsWith(Storing; searchField)); Storing) )
Hope this helps

Was this reply helpful? Yes No
FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ethan,
Sorry but I am realy new to Power Apps. Does your suggestion replace the Items Fx in the Gallery I gave you or is it for the button?

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FZ80
Use below formula for gallery
Distinct(Filter(TblSAK; StartsWith(Storing; searchQuery)||Isblank( TbSearchInput.text));Storing)
output : if TbSearchInput is empty all items will be displayed else it will filter based on Value in text box
for button :reset(TbSearchInput)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@FZ80 ,

Its for gallery items,
When you reset the Textbox then you won't see any records in Gallery.
Else it will filter data based on textbox.

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

@FZ80

you want output like this?
When you reset the Textbox then you won't see any records in Gallery.
Else it will filter data based on textbox.

Was this reply helpful? Yes No
FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Ethan, your formula works fine. I see have to learn a lot 🙂

Was this reply helpful? Yes No
FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help AJ. It works fine. Just before your formula I got a somewhat simular suggestion from Ethan that did the job also. So I think it is fair to accept that one as solution. Thanks again!

Was this reply helpful? Yes No