web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps sort gallery

Power Apps

Answered

sort gallery

(0) Share

Report

Report

Posted on by eurostar_italia

18

hi to every body.

i have a list called "trains",in which i have a column "date of travel".

i made also a calendar view ....so some days are empty.

may be i travel 1/7/2023 and then 1/9/2023

i built an app to show all records but the one made with the wizard shows even blank records.

i found two different formulas :

-SortByColumns(Filter([@'TRAINS']; StartsWith(LASTNAME TextSearchBox1.Text)); "DATEOFTRAVEL" ; If(SortDescending1; Descending; Ascending)) - allows me to order the gallery and use the searchbox

-Filter('TRAINS'; 'DATEOFTRAVEL' >= Today())- allow me to show only records from today towards the end.

how can i use both formulas together ???? it's driving me crazy.

thanks for your help

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @eurostar_italia,

Please try the following code:

SortByColumns( Filter([@'TRAINS']; StartsWith(LASTNAME TextSearchBox1.Text) && 'DATEOFTRAVEL' >= Today() ); "DATEOFTRAVEL" ; If(SortDescending1; Descending; Ascending) )

See && 'DATEOFTRAVEL' >= Today()

Note: if you just want to filter out the blank records, you can swap && 'DATEOFTRAVEL' >= Today() with && 'DATEOFTRAVEL' <> Blank()

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
eurostar_italia 18 on at

Like
a
(0)

Report
Copy link

Link copied!

it works great!!!!! you're very kind!!! thanks a lot for you help!!!!

Was this reply helpful? Yes No

Join the conversation