web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sort and SortByColums ...

Power Apps

Answered

Sort and SortByColums question

(0) Share

Report

Report

Posted on by Paul_M

264

Hello Community,

Looking for guidance.

I have gallery control SortByColumns on Autoincremented ID.

SortByColumns(Database,"id",Ascending)

However my gallery Ascending is wrong:

(I have 1, 2, 3,.... 18 ID in the dataverse)

I wanted the ID to display in ascending order.

I am not sure what is wrong with the formula.

Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

365-Assist 2,324 Moderator on at

Like (1)

Report
Copy link

Link copied!
Your number seems to be Text so I believe you need:
Sort(Database,Value("id"),Ascending)
Although you may get delegation warnings.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No

Join the conversation