Answered

Sort gallery by calculated Label text

(0) Share

Report

Posted on by dev12753

Hi,

I'm pretty new to Power Apps and having a problem I can't quite solve with the resources I found online, especially in this forum.

I've created a Gallery inside a Container, that Gallery works on an Entity as its data source (I hope I'm using the right vocabulary), the "Items" code is: "Filter(Entity; 'Entity (Views)'.'View'). I've translated this from German.

I've then added another Label to the Gallery that is used to calculate and display something using data from another entity:

Sum(Filter(Entity_2; Entity_2_Column1.Name = ThisItem.Name; DateDiff(Entity_2_Column2;Today();Days)<=7);Entity_2_Column3)

Entity_2_Column1 is a lookup column pointing to the Entity the Gallery uses as data source.

I would now like to sort the Gallery by the calculated values displayed in the Label's Text. How can I do that?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did you manage to resolve this issue?
If not, share a little bit of how your data is structured so I can better elaborate on a way to do this.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @dev12753 ,

Sorting in a Gallery is actually sorting on the Items of this Gallery. In your case, you will need to add the values to an additional column. So, you need an AddColumns function to help achieve this:

Sort( AddColumns( Filter(Entity; 'Entity (Views)'.'View'); "SumDays"; Sum(Filter(Entity_2; Entity_2_Column1.Name = ThisItem.Name; DateDiff(Entity_2_Column2;Today();Days)<=7);Entity_2_Column3) ); SumDays; Ascending )

However, you should be noted that this formula is not delegable so it will not work for a large data set.

Best regards,

Was this reply helpful? Yes No