Issue in Search function where a column is a Sharepoint Person Type Column

(0) Share

Report

Posted on by Antonioclk

Hello

I have a sharepoint list with columns of different type.

User - a person type column, which gets the user from the office group
Location- a location type column, who store a city information
Whatsapp - a number type column
Team - a text type column

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.User.DisplayName
ThisItem.'Location: Name'
ThisItem.Whatsapp
ThisItem.Team

I have no problem in visualizing the data but i do have issues when i try to search.

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,"Whatsapp","Team")

But i need to search also by User.DisplayName/Location.City and when i try to add them it doesn't work.

Search(myData,SearchBar.Text,"Whatsapp","Team",User.DisplayName,Location.Name)

this is how i tried, what am i doing wrong?
Thank you so much

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Silvester. Akakpo 783 on at

Like (1)

Report
hi @Antonioclk ,
use this formula instead.
Search(myData,SearchBar.Text,"Whatsapp","Team" && User.DisplayName,Location.Name)

Accept it as a solution if it works.

Was this reply helpful? Yes No
Antonioclk on at

Like (0)

Report

hello, sadly it doesn't works... it seems like won't accept values not in " "

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (2)

Report
Hi @Antonioclk ,

Try to use the following formula:
Search(AddColumns(datasource,"UserDisplayName",User.DisplayName,"LocationName",'Location: Name',"WhatsappText",Text(Whatsapp)),SearchBar.Text,"WhatsappText","Team","UserDisplayName","LocationName")
I have made a test for your reference.
1. Here is my list.
2. Here is my App.
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Antonioclk on at

Like (0)

Report

That's great! it worked! but sadly while it fixed my search function, seems like it broke my detail form.
the gallery has onSelected Navigate(DetailScreen, Cover). It opens a screen with a Detail Form, where my item property is set with Gallery.Selected.
It was working but now it gives me an error "invalid formula. Expected a value compatible with "DataSource". Should i cast the value or something like that?

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (2)

Report
Hi @Antonioclk ,

Try to select the Form and apply the following formula on its Item property as:
LookUp(datasource,ID=Gallery5.Selected.ID)

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Antonioclk on at

Like (0)

Report

ur my hero! thank you so much

Was this reply helpful? Yes No