web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sort icon for all colu...

Power Apps

Answered

Sort icon for all columns in datatable

(0) Share

Report

Report

Posted on by Roar1

56

I have created a data table in canvas app In that I need sort icons for all columns separately. Already I have given some features like filter and search. Below I have attached the code in snapshot for reference. Can anyone help me with this?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Roar1 ,

I suggest that you create a collection to hold all the filtered data, so that you can update the data in the collection by changing how the collection is sorted, in the sense that the data in the collection will be updated according to the column you choose to sort.

Please try this:
1)Set the OnChange of each dropdown which you use to filter data:
ClearCollect(mm,Filter(Table1,TextInput3.Text in 'Report Name'......))
2)Set the Items of your data table:
mm
3)For each icon you use to sort a column:
Set the OnSelect of icon:
ClearCollect(mm,Sort(mm,column1,SortOrder.Ascending))
The result of my test:
When I select the icon above "student":

Best regards,
Rimmon Li

Join the conversation