Answered

I can't sort a gallery bij a date column.

(0) Share

Report

Posted on by Steven | TIMI365

After yor great help earlier I have one more issue which I would like to solve.
See the pictures below as examples for more info.

In my SPO list I have a lookup column with starting dates of a training. The training is created in another list and in this list I store the people who are attending the list so I need the Start time from the parent list. This works like it should be.

I even have a filter on the gallery that work with the date from a datepicker to find the training dates in the futere

Pic sun2.png

This works but now I would like to sort the gallery on that Date/time Column....... And I tried and tried. more than 2 day now. Thats OK, It rains in the Netherlands so I have time. But it's also annoying that I don't get it done.
It tried also with this
SortByColumns(Filter(Sessies; dpFilterCT.SelectedDate <= DateValue(Datum.Value));"datum"; Descending)
but that want work also.

Maybe, I must work with a collection but as a starter in PowerApps that pretty hard to figure out.
Here are some more pictures

Pic sun1.png Pic sun2.png

Kind regards
Steven

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @StevenTIMI263 ,

If you say that you don't have more than 100 records in this list, you can you try to move the filter on user-side trying this:

Sort( Filter(AddColumns(Sessies;"Date"; DateValue(Datum.Value)); dpFilterCT.SelectedDate <= Date); Date; Descending)

Hope it helps !

Was this reply helpful? Yes No
Steven | TIMI365 86 on at

Like (0)

Report
Copy link

Link copied!

Thanks for replying. As you see I have an error massage. I tried "Datum" , Datum.value etc but one way or the other I want work.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@StevenTIMI263 - I used Date in my reply not Datum.Value.

Was this reply helpful? Yes No
Steven | TIMI365 86 on at

Like (0)

Report
Copy link

Link copied!

yes Thank you for your help But when I take your solution I don't see any error massage. But It want return any items to my gallery

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@StevenTIMI263 Can you show me the error please ...

In my formula I wrote DateValue not Value ...😊
Sort( Filter(AddColumns(Sessies;"Date"; DateValue(Datum.Value)); dpFilterCT.SelectedDate <= Date); Date; Descending)

Was this reply helpful? Yes No
Steven | TIMI365 86 on at

Like (0)

Report
Copy link

Link copied!

Hi Gabibalaban,
Thanks for helping. This works. but........ Now the connected form gives me an error massage. I suppose that the something with the " Date" value returns this error. See the screen shot. The field "Hoogwerker" is a fixt field and don't need the selected.item.The other field aren't loading........

I hope you can help
regards Steven

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!

@StevenTIMI263
put on item property of the form the following formula:
LookUp(Sessies;ID=galCursistem.Selected.ID)

Was this reply helpful? Yes No
Steven | TIMI365 86 on at

Like (0)

Report
Copy link

Link copied!

Hi Gabibalaban ,
Thank you so much. Everything works now.
Very happy with you sharing your knowledge 👍

Kind regards
Steven

Was this reply helpful? Yes No