Search Against SharePoint Choice Field(along side text fields)

(0) Share

Report

Posted on by nemanjasovic011

240

Hello,

While this topic was addressed on the internet, I am not able to have Search formula work along side plane SharePoint text fields(that are working in search by themselves) in galley. The name of the choice column in SharePoint I am trying to add is called "Status Task" (internal SP name "StatusTask").

Below is my formula(there is a "Sort" wrapper that can be ignored:

SortByColumns(
 If(
 !IsBlank(Search_tb.Text),
 Search(
 ActiveRequests,
 Search_tb.Text,
 "Title","Brand"
 ),
 ActiveRequests
 ),
 "ID",
 If(
 Sort_ddl.SelectedText.Value = "Ascending",
 Ascending,
 Descending
 )
)

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @nemanjasovic011 ,

Try this

SortByColumns( If( !IsBlank(Search_tb.Text), Search( AddColumns( ActiveRequests, "StatTask", StatusTask.Value ), Search_tb.Text, "Title", "Brand", "StatTask" ), ActiveRequests ), "ID", If( Sort_ddl.SelectedText.Value = "Ascending", Ascending, Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

nemanjasovic011 240 on at

Like (0)

Report

This is it. Thank you.

Was this reply helpful? Yes No
nemanjasovic011 240 on at

Like (0)

Report

Thanks

Was this reply helpful? Yes No