web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Browse Gallery not wor...

Power Apps

Answered

Browse Gallery not working

(0) Share

Report

Report

Posted on by soyasticks

12

New to Power Apps. I am having this weird issue with Browse Gallery.

When I include the table under 'Items', I see the data but the search bar won't work.

And if I apply the below code to 'items', I don't see any data to search. The gallery is blank

SortByColumns(Search([@Table1], TextSearchBox1.Text, "column1","column2"),"column1", If(SortDescending1, Descending, Ascending))

any idea?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @soyasticks ,

I suggest you check the types of "column1" and "column2", because the column to be searched in search() needs to be a text column.

If there is a column in these two columns that is not text, an error occurs, here is the test I did:

Create a collection with the following formula, column1 is the number column, column2 is the text column.

Items uses the formula you provide without any data and prompts an error:

Create a collection with the following formula, column1 and column2 are both text columns.

Using the same formula, it is able to display data.

If this is the case, I suggest you modify the column type or use the following formula:

SortByColumns(
    Filter(
        [@Table1],
        TextSearchBox1.Text in column1 || TextSearchBox1.Text in column2
    ),
    "column1",
    If(
        SortDescending1,
        Descending,
        Ascending
    )
)

In other cases, If you can provide more detailed information such as screenshots, which will greatly help us solve the problem in the future.

Best Regards,

Wearsky
soyasticks 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you~!

Join the conversation