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)

Sort by

Suggested answer

abc 123 789 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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 993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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