Answered

Can I use number column in sort by columns function?

(0) Share

Report

Posted on by Dipak_Shaw

108

I want sort the sharepoint items according to my number column's number. I am using this column to sort items in powerapps gallery but items are not showing. Don't know why.

Please help.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes you can use number column. can you show the Items property of the Gallery to indicate the formula?

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

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.
Dipak_Shaw 108 on at

Like
a
(0)

Report
Copy link

Link copied!
ID Title Type SortOrder
1 Test Personal 2
2 John Professional 1
3 Tony Personal 3
4 Robert Personal 1
5 Tom Professional 2

I have to galleries to show 2 types and the function I am using is
SortByColumns(Filter(Table1,Type="Personal"),"SortOrder",Ascending)
SortByColumns(Filter(Table1,Type="Professional"),"SortOrder",Ascending)
Abhilash_Swain 901 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dipak_Shaw ,
Yes, You can.
Let's say there is an Employee table with Salary details. To show the gallery by sorting the highest salary on top it will be.
Use a sorting button to toggle ascending and descending. In button "On Select" = UpdateContext({Sorttype:!Sorttype}).
Then In Gallery
galerry Items = SortByColumns(Employee, "Salary", If(Sorttype, Descending, Ascending)).

Please give a thumbs up if I answered to your question and mark it as a solution if it resolve your query.
Thanks
Abhi
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use
Sort(Filter(Table1,Type="Personal"),SortOrder,Ascending)

Also try this if data would show up:

Sort(Filter(Table1,Type="Personal"),ID,Ascending)

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

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.
Verified answer

Dipak_Shaw 108 on at

Like
a
(0)

Report
Copy link

Link copied!

I had to use show columns functions inside the filter function.