Unanswered

Filter the content of a column, search bar

(1) Share

Report

Posted on by Hii_iii

691

Hello,
I have a Sharepoint list called "Note de Frais" and on my Power Apps application I would like to filter from the "Nom Prenom" column (which is a person field). I want to do this because I would like to create a search bar which will filter the "Nom Prenom" of the users.

My SharePoint list :

The basic formula in Power Apps is this:

SortByColumns(Filter([@'Notes de frais']; StartsWith(Title; TextSearchBox1.Text)); "Title"; If(SortDescending1; Descending; Ascending))

I tried to modify it like this but it shows me errors:

SortByColumns(Filter([@'Notes de frais']; StartsWith(Nom Prenom; TextSearchBox1.Text)); "Nom Prenom"; If(SortDescending1; Descending; Ascending))

Thank you in advance for your help !

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report
instead of Nom Prenom try doing 'Nom Prenom'

e.g.

SortByColumns(Filter([@'Notes de frais']; StartsWith('Nom Prenom'; TextSearchBox1.Text)); "Nom Prenom"; If(SortDescending1; Descending; Ascending))

let me know what happens when you make that change

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

It's does'nt work :c @AJ_Z

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

Like (1)

Report
Hi @s44 ，

Do you want to filter records by Person column?
It seems that you cannot use SortByColumns() in the "Person or Group" column of a SharePoint list.
In addition, Is it necessary for you to use SortByColumns()?

I have made a test for your reference.

1.Here is my SharePoint list.
2.Select the Gallery Control and apply the following formula on its property as:
SortByColumns(Filter(AddColumns(recruitrequest,"applicantdisplayname",applicant.DisplayName),StartsWith(applicantdisplayname,TextSearchBox1.Text)),"applicantdisplayname",If(SortDescending1, Descending, Ascending))
3.In addition, you can try to use Sort() function.
Sort(Filter(recruitrequest,StartsWith(applicant.DisplayName,TextSearchBox1.Text)),"applicant",If(SortDescending1,Descending,Ascending))
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

@v-yujincui-msft Yes, I want to filter the records according to the "Person" type column.
No it is not necessary to use SortByColumns ()

Your formula doesn't work or me :c

My Sharepoint list if you want :0 :

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

Like (0)

Report

Hi @s44 ,

The problem seems to be in your reference to the data source, you could try adding single quotes to the data source in the formula.

SortByColumns(
Filter(
AddColumns(
'Notes de frais',//You should reference your data source with a single quotes
"nomprenomdisplayname",
'Nom Prenom'.DisplayName
),
StartsWith(nomprenomdisplayname,TextSearchBox3.Text)
),
"nomprenomdisplayname",
If(SortDescending1,Descending,Ascending)
)

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

@v-yujincui-msft I have this error with this formula 😞 :

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report

Hi @s44 ,

Maybe you should use TextSearchBox1.Text.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

It's work thanks !

Was this reply helpful? Yes No