Serach function in gallery does not work. Please help

(0) Share

Report

Posted on by venka91

1,119

Hi All,

I have sharepoint list created for helpdesk application. This has Issue id, Assigned to column and creator email id. I have a text box placed to type the search item. So gallery will pull the requested record details.

But when i use the Item Property in gallery as Search(helpdesk, textsearch.text,"Assigned To","Email ID", "ID"), this returns an errors.

But i feel the syntax is correct. Could any one help me please.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Pstork1 69,018 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The problem is the "ID" column. That's why it has the darker underline. ID is an integer and you are trying to search it using a string. Remove the ID column and you will be all right as long as the other two columns aren't complex columns.

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

I tried removing ID, but it says Search has some invalid arguments.
My Assigned To column holds an Email id and its type is Person or Group in Sharepoint. And Employee Email is Text column. Moreover If i Remove ID, how can i search the Gallery by the ticket number which is getting stored in ID Column... Please guide.

Was this reply helpful? Yes No
Pstork1 69,018 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Person/group columns are complex objects and can't be used directly in Search(). The common workaround is to create a single line of text column and save the display name or the email of the person to that. Then search on that.

Was this reply helpful? Yes No
venka91 1,119 on at

Like (0)

Report
Copy link

Link copied!

Assigned to column atleast to be a Choice column, so i can choose the technician when i assign the tickets to them. Moreover when they look for ticket from common queue, they must be able to view the tickets assigned to them.
Is there any other way to do this. Pls advise.

Also, if i need to search the Gallery by ID, how to do it ?

Was this reply helpful? Yes No
Verified answer

Pstork1 69,018 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Take a look at the answer in the following post on how to search People columns.

Solved: Searching on a people/person field - Power Platform Community (microsoft.com)

For the ID column you'll need to use a separate search statement so you can search using Value(textBox1.Text).

Was this reply helpful? Yes No