Search Not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Here's my problem:

I created a sharepoint list with the following column names:

Date (Date & Time type)

Name (People or Group type)

Activity (Choice type)

Hours (Number type)

Billable (Choice type)

Project Related (Text type)

Description (Text type)

The Title column is hidden.

The problem is: I'm trying to create an app where I can do a search / filter based on the Name column, but it's not working.

Should "Search('datasource';TextSearchBox1.Text;"Name")" work?

Best regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
You are having an issue because SEARCH requires a string value for the 3rd parameter but your column "Name" is a Person/Group object. However, you can achieve your goal with the help of a ComboBox and the FILTER function.

First, create a new ComboBox with the following properties

Items: [@your_SPlist_name].Name DisplayFields: ["DisplayName"] SearchFields: ["DisplayName"] IsSearchable: true

Then put this code in the Items property of your Gallery.

Filter(NamesList,Name in ComboBox1.SelectedItems)

There we go. Let me know if you have any questions.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

The reason why you met this problem is Name is People or Group type.

This complex data type need special formula.

The first solution is as @mdevaney said, using combo box to filter.

If you insist in using textinput to filter, then I do not suggest you use Search function, cus this function only works for text data type.

I suggest you use filter function ,try this formula:

Filter('datasource';TextSearchBox1.Text in Name.DisplayName)

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Tnks for the fast reply @mdevaney

I created the ComboBox with the properties, but no information appears in the box.

Items: Timesheet.'Created By' DisplayFields: ["DisplayName"] SearchFields: ["DisplayName"] IsSearchable: true

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
Make sure your syntax is exactly the same as mine. You wrote this code

Items: Timesheet.'Created By'

Whereas I wrote this code

Items: [@Timesheet].'Created By'

Use my syntax and let me know the results. I made a test of this solution before my original post.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Still not working :S

I realized that I can't change the value of IsSearchable. It's fixed in false.

I don't know if it affects anything. But I changed the Name column to Created By (which the list itself creates)

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
If you changed the column name you must refresh your datasource on the left side menu before building and further. Try this and test again.

If IsSearchable is set to false permanently, delete this control and try again. Make sure the datasource is refreshed first.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

IsSearchable starts as True, but when I modify the Item, it sets to false.

Was this reply helpful? Yes No