Unanswered

choise field then search and filter based on choice field

(0) Share

Report

Posted on by arcej

I really appreciate your help.
I am trying to search based on a choice field created in SharePoint, so the PowerApp's user can search the records just selecting the predefined value in the search field ( based on value listed in choice field in SharePoint), and then all records are displayed in the column in PowerApps sorted y date ( date is a column in List / linked in Sharepoint as well)

Categories:

Building Power Apps

SharePOint List.docx

I have the same question (0)

All responses (5)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report

@arcej

You should supply a screenshot of all the error messages you are receiving since they could be relevant to finding the solution.

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

Like (0)

Report
Hi @arcej,
What is the error message? How about replacing 'Choice' by its real column name.
Sort(If(IsBlank(TextSearchBox1.Text), List, Filter(List, TextSearchBox1.Text in 'KPI Name'.Value)), "Period", If(SortDescending1,Descending,Ascending))
Sik

Was this reply helpful? Yes No
arcej 6 on at

Like (0)

Report

please check error attached.
Thanks

error.docx

Was this reply helpful? Yes No
arcej 6 on at

Like (0)

Report

Please check the file that I am attaching with the errors.Thanks

error.docx

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

Like (0)

Report

Hi @arcej ,
Could you please share the detailed error message? What you provided is incomplete.
Are the sharepoint list name and column name correct?
Sik

Was this reply helpful? Yes No