Issue in searching in text box for gallery where a column is a Sharepoint Person Type Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

‎

Hello

I have a sharepoint list with columns of different type.

Company - a text type column

Project – a text type column

NPP# - a text type column

Sales Account Manager - a person type column, which gets the user from the office group

In my power app i have a gallery who uses a sharepoint connector to grab data from the list.

the labels of my gallery are

ThisItem.Company

ThisItem.Title

ThisItem.’NPP#’

ThisItem.’Sales Account Manager’.DisplayName

I have issues when i try to search using text box

On the Items property of my gallery i have the following function. if i just use the following code it works fine –

Search(myData,SearchBar.Text,"Company","Title", “NPP_x0023)

But i need to search also by Sales Account Manager and when i try to add them it doesn't work

Search(myData,SearchBar.Text,"Company","Title", “NPP_x0023”, “Sales Account Manager.DisplayName”)

this is how i tried, what am i doing wrong? Please help me.
Thank you so much

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Two things I can see - you need to turn that into a Text column to Search as below - you also had the wrong Quotes (I assume you typed that in Word - consider NotePad in future)

Search( AddColumns( myData, "SalesName", 'Sales Account Manager'.DisplayName ), SearchBar.Text, "Company", "Title", "NPP_x0023", "SalesName" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Warren,
Thank you very much for guiding me. However, something went wrong and I could not see the result. Attached is the screenshot of new formula that I used in gallery.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

You should need

Search( AddColumns( ['VPI Projects 2023'], "SalesName", 'Sales Account Manager'. DisplayName ), TxtsearchPraf.Text, "Company", "Title" "NPP_x0023"," SalesName" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps