search box is working one column where as not for other columns.

(0) Share

Report

Posted on by yougan

262

search box is working one column where as not for other columns.

For "Title" column it is working

For "Depart" column it is not working

For "color" column it is not working

What could be the wrong. Please help and find attached screenshots.

Categories:

Building Power Apps

c3.PNG

Capture.PNG

c2.PNG

I have the same question (0)

All responses (6)

Answers (1)

GarethPrisk 2,828 on at

Like (0)

Report

Search will only be applicable to columns which contain text/string values. Those are Choice columns, and are not applicable.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Instead, consider providing those Choices as dropdowns for the user to filter by the available choices.

Was this reply helpful? Yes No
yougan 262 on at

Like (0)

Report

Hi Gather Prisk,
Thank you.
It is already drop down choice, can you give me some example how to filter for those drop down choices?
Please find attached screenshot

Capture.PNG

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi@yougan,
Based on the issue that you mentioned, do you want to search Choice column using the Search() function?
Could you please share a bit more about the scenario?
I agree with @GarethPrisk , the Search() function does search only the column containing text strings. As we know, complex field types (Choice, Lookup, Date and time, Person) are non-delegable in SharePoint, so if you have a huge data set (records>2000) you will have the delegation warning.
If your data set is smaller than 2000 records, I think you could try the following workaround.
// Replace the Search() with the StartsWith() function, note that the StartsWith() function could only test for the start string.
Set the Items property of the Gallery as below:

Filter( [@'Gym Pass'], StartsWith( Color.Value, TextSearchBox1.Text ) Or StartsWith( Title, TextSearchBox1.Text ) Or StartsWith( Depart.Value, TextSearchBox1.Text ) )

Note: 'Gym Pass' is my SP list name, please replace it with yours.
Hope it could help you.
Best Regards,
Qi

Was this reply helpful? Yes No
yougan 262 on at

Like (0)

Report

Hi Qi,

Thank you for the support.
I tried to do as you per your instruction. I might be doing some where wrong. Please correct. I have attached screenshots of List and Power app details. Please correct where I am doing wrong.

l2.PNG

pa.PNG

L1.PNG

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi@yougan,
I think there is something lost in your formula, please check my formula again.
The formula you provided loses a parenthesis.
Please modify the formula as below:
Filter( [@'SPListName'], StartsWith( Color.Value, TextSearchBox1.Text ) )
Further, if you want to display corresponding item in the Label within the Gallery, for the Choice column, please set the Text property as below:
ThisItem.Color.Value
Hope it could help.
Best Regards,
Qi

Was this reply helpful? Yes No
yougan 262 on at

Like (0)

Report

Hi Qi,

How do we set below and where we set? Please help with detailed screenshots. Thank you
Further, if you want to display corresponding item in the Label within the Gallery, for the Choice column, please set the Text property as below:
ThisItem.color.value

Was this reply helpful? Yes No