web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery sorting by cal...

Power Apps

Answered

Gallery sorting by calculated fields

(0) Share

Report

Report

Posted on by IR_06

23

hi all,

I am currently working on App to record Employee Absences.

It is based on SharePoint lists:

Employees

Employee ID (text)
First Name (text)
Surname (text)
Department (text)

Absences

Employee ID (text)
From (date)
To (date)
Date of return (date)
Days (number)
Category (text)

This reports counts occasions and days employees have been sick

Occasions are calculated using below:

Days are calculated using below:

I am looking for a way to sort this gallery by Occasions or Days so it's easier to use.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@IR_06 - see example below you can apply into the Items property of your Gallery control:

Sort( AddColumns( Employees As _data, DaysAbsent, Sum( Filter( Absences, 'Employee ID' = _data.'Employee ID' ), Days ), Occasions, CountRows( Filter( Absences, 'EmployeeID' = _data.'EmployeeID' ) ) ), DaysAbsent, SortOrder.Descending )
IR_06 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik thank you for help

This has worked beautifully for my report. I have been trying to do the same for another report but unsuccessfully. This particular one is looking as absence days in last 3 years.
Each column under Days is displaying 1 out of 3 years.
I would like sort it by most absences in in total time period of 3 years.
I have tried applying same logic as for last one but seems that it's not sorting it.
Current code:
Could anyone advice what kind of mistake I have made there?
Thanks😊
IR_06 23 on at

Like
a
(0)

Report
Copy link

Link copied!

This has been solved now. Just a silly error in defining collection 😅
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@IR_06 - sorry I did not receive the usual notification that you had responded. Glad you got it sorted.

Join the conversation