Answered

how to concatenate SortByColumns with date

(0) Share

Report

Posted on by HEITORBICUDO

i would like to know how to concatenate SortByColumns(Filter([@'Labor Request - Agency']; StartsWith(Title; TextSearchBox1.Text)) with the solicitation date information that is also in the same sharepoint list as title "@'Request for Labor - Agency'"

i would like to have two search fields:
TITLE

Solicitation date

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @HEITORBICUDO ,

To search Data fields, you need a couple of Date Pickers to select the range of dates between them, so

SortByColumns( Filter( [@'Labor Request - Agency']; StartsWith( Title; TextSearchBox1.Text ) && 'Solicitation date' >= DatePicker1.SelectedDate && 'Solicitation date' <= DatePicker2.SelectedDate ) )

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
HEITORBICUDO 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thanks so much,

Should I insert 2 data pickers and put the function in BrowserGallery?

thanks
WarrenBelz 156,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @HEITORBICUDO ,

Yes - I assume the date pickers are outside the gallery.