Unanswered

SearchbyColumns

(0) Share

Report

Posted on by NCDewey

I am a new to PowerApps. When I created an app. It defaulted the SearchByDolumns to the title. 1st, I would like to display data to be sorted by the most recent ID number at the top. Next, I would like to be able to search based on ID, Title and date. Listed is the current code for the "TemplateGalleryList1": I appreciate the help.

SortByColumns(Filter('CC IT Project Request Form', StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Here is the screen shot of the Browse screen:

Browse Gallery screen shot.png

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
1. To simply show your records from Highest ID put this formula:

SortByColumns(
'CC IT Project Request Form',
"ID",
Descending
)

2.
StartWith function can only evaluate string column types but you can wrap them in Text() function to turn them into strings, however it then becomes undelegatable.

To allow searching by TItle, ID or Date put the following function in the Gallery1.Item:

SortByColumns( Filter( 'CC IT Project Request Form', StartsWith(Text(ID), TextSearchBox1.Text) || StartsWith(Title, TextSearchBox1.Text) || StartsWith(Text(DateColumn,ShortDate),TextSearchBox1.Text) ), "ID", Descending )
Replace DateColumn with the name of your DateColumn

Was this reply helpful? Yes No
NCDewey 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your help!!!. That worked.

Was this reply helpful? Yes No