Sort by date

(0) Share

Report

Posted on by bheijligers

Hello,

I have a problem with sorting by date in my timesheet app.

After reading the community is changed the formula into:

SortByColumns('Urenregistratie Heelektro';"Datumwerkzaamheden";Descending)

Source= Urenregistratie

column = datumwerkzaamheden

and i want to work descending.

But it doesn't work and keeps giving errors.

Thank you

Bob

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

What errors is it returning?
Have you tried using double quotes around the table name?

Was this reply helpful? Yes No
bheijligers 54 on at

Like (0)

Report

Now i did, but still nothing.
It says that invalid argumenttype (text) insteed we expect a table value.
(i have a dutch version, so i do my best ;-))

Bob

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

What errors are showing? In your code you have "Heelektro" after the table name - or is that part of the name?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

The double quotes should be single quotes;

SortByColumns('Urenregistratie Heelektro';'Datumwerkzaamheden';Descending)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bheijligers 54 on at

Like (0)

Report

The tables name is Urenregistratie Heelektro and comes form Sharepoint.

Was this reply helpful? Yes No
bheijligers 54 on at

Like (0)

Report

No it doesn't make any difference.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

Have you tried the suggestion I gave?

Any feedback?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (1)

Report

Sorry - I wasn't paying attention - change all your ";" to","

Was this reply helpful? Yes No
bheijligers 54 on at

Like (0)

Report

no "...." to '..... '

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report

I meant that there are semicolons in the formula where there should be commas. In the Powerapps documentation everything uses double quotes.

Was this reply helpful? Yes No