Research field and Sort

(0) Share

Report

Posted on by ancorte

Hello every one,

i'm a newbie of Power apps.

in the Browse Gallery i have this :

SortByColumns(Filter([@Time_Sh]; StartsWith(Title; TextSearchBox1.Text)); "Title"; If(SortDescending1; Descending; Ascending))

My sharepoint list has a "choise" field named "Chi". I'd like to order and research by this field. I had a look at other answer, i try to use "Chi.value = TextSearchBox1.text, but without result.

What is the right command that i have to use ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@ancorte

If you are using a Choice type field, it is better to use a dropdown control for filtering your list than a textinput box.

put a dropdown on the screen with the Items property Choices([@Time_Sh].Chi) and set the Items property of the browse gallery to

SortByColumns( Filter( [@Time_Sh]; StartsWith(Title; TextSearchBox1.Text) & Chi.Value=Dropdown1.Selected.Value); "Title"; If(SortDescending1; Descending; Ascending) )

Was this reply helpful? Yes No
ancorte 94 on at

Like (0)

Report
Copy link

Link copied!

Sorry for my delay in the answer. I've put all the elements, but i'm not able to see the elements in the app (also before to make the modification). In my sharepoint list the Title column is always empty (i've decided to use another column): could this be the problem ? Thanks for your help. Herewith you cna find the details of my sharepoint list.

Was this reply helpful? Yes No
ancorte 94 on at

Like (0)

Report
Copy link

Link copied!

Anyone can help me ?
Thanks

Was this reply helpful? Yes No