HelloI have a sharepoint list with columns of different type.User - a person type column, which gets the user from the office groupLocation- a locatio

Hi @Antonioclk , Try to use the following formula:Search(AddColumns(datasource,"UserDisplayName",User.DisplayName,"LocationName",'Locat

Power Apps - Building Power Apps

Answered

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

Like (0) Share

Report

Posted on 12 May 2022 14:15:08 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:

Using Apps Using Formulas

Connecting to Data

General Questions

Connectors

I have the same question (0)

All responses (6)

Answers (1)

Silvester. Akakpo 783 on 12 May 2022 at 15:29:16

Like (1)

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

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 13 May 2022 at 06:32:58

Like (0)

Report

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

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 13 May 2022 at 07:19:03

Like (2)

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

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 13 May 2022 at 08:32:22

Like (0)

Report

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

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 13 May 2022 at 08:45:09

Like (2)

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

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 13 May 2022 at 09:01:28

Like (0)

Report

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

ur my hero! thank you so much

Was this reply helpful? Yes No