web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Serach function in gal...
Power Apps
Answered

Serach function in gallery does not work. Please help

(0) ShareShare
ReportReport
Posted on by 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.

 

venka91_0-1628991824446.png

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,018 Most Valuable Professional on at

    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.

  • venka91 Profile Picture
    1,119 on at

    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.

  • Pstork1 Profile Picture
    69,018 Most Valuable Professional on at

    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.

  • venka91 Profile Picture
    1,119 on at

    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 ?

  • Verified answer
    Pstork1 Profile Picture
    69,018 Most Valuable Professional on at

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard