Unanswered

Need proper code for power app search function

(1) Share

Report

Posted on by NJ-06081605-0

I've created a power app that is connected to share point list. i can't get the search function of the power app pull up information from the share point list. Below are the different codes that I've tried. Does anyone have the right code for my issue?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

abc 123 784 Moderator on at

Like (0)

Report

This code will store the retrieved data into a collection.

ClearCollect(colCats,

Filter('SharePoint List', StartsWith(Title, "Cat")

)

Once you have the data in the collection, it's easy to use for a Gallery.

That said, are you sure you have the word "Cat" in the Title column?

(I've never used Search, but you can check the specs on the proper use.)

Was this reply helpful? Yes No
Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report

The proper way to format a search in Power Apps is to just write the column name without quotes (if it's one word) or use single quotes.

Search('data_source',txt_search_field.Value,Title)

or

Search('data_source',txt_search_field.Value, 'Column Name with Spaces')

Was this reply helpful? Yes No
NJ-06081605-0 8 on at

Like (0)

Report

I tried both of those code inputs and keep getting this warning

And I have nowhere near the amount of data to exceed the record limit. This is how I typed the code for both tries

Was this reply helpful? Yes No