Unanswered

Empty Gallery

(0) Share

Report

Posted on by donnacha

141

When I created my vertical gallery I connected it to the needed database and it would come up with the information I needed however when I add a textbox and want to be able to allow the user to search up any name they want that is in the database it now comes up with an empty gallery.

The line I have is

SortByColumns(Search(Players,TextInput8.Text,"PlayerName"),"PlayerName",Ascending) but it comes up with nothing in the gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

If(
IsBlank(TextInput8.Text),
SortByColumns(Players,"PlayerName",Ascending),
SortByColumns(Search(Players,TextInput8.Text,"PlayerName"),"PlayerName",Ascending)
)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
A-Roosevelt 153 on at

Like (0)

Report
Hello @donnacha
Try with this function

SortByColumns(Filter(Players,TextInput8.Text="PlayerName" || IsBlank(TextInput8.Text)),"PlayerName",Ascending)

Cheers!

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
@donnacha

Try this formular
SortByColumns(Filter(Players,TextInput8.Text="PlayerName" || IsBlank(TextInput8.Text)),"PlayerName",Ascending)

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