How to find max number from a collection

(0) Share

Report

Posted on by MrShivam

i have this collection and want to find max number without using max,sort function.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't think i am understanding correctly. Do you want a label outside the gallery to show the highest value for the column no but you don't want to sort or use max? can i ask why you don't wish to use them.

Was this reply helpful? Yes No
MrShivam 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@AJ_Z yes , but dont want to use max/sort

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I am trying to understand why we can't use max or sort. Is there a reason for this?

Was this reply helpful? Yes No
MrShivam 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@bipinshan

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MrShivam :

This is easy to implement, but the performance will be worse than Sort or Max. I've made a test for your reference:

1\I assume there is a collection:

ClearCollect(Number,{no:2},{no:6},{no:9},{no:6},{no:12});

2\Add a button and set it's OnSelelct property to:

ForAll(Number,If(no>Last(TheCollection).TheNumber,Collect(TheCollection,{TheNumber:no}))); Set(TheResult,Last(TheCollection).TheNumber)

3\Click the button, the maximum value in the collection 'Number 'will be saved to the variable 'TheResult'

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MrShivam :

This is easy to implement, but the performance will be worse than Sort or Max. I've made a test for your reference:

1\I assume there is a collection:

ClearCollect(Number,{no:2},{no:6},{no:9},{no:6},{no:12});

2\Add a button and set it's OnSelelct property to:

ForAll(Number,If(no>Last(TheCollection).TheNumber,Collect(TheCollection,{TheNumber:no}))); Set(TheResult,Last(TheCollection).TheNumber)

3\Click the button, the maximum value in the collection 'Number 'will be saved to the variable 'TheResult'

Best Regards,

Bof

Was this reply helpful? Yes No
MrShivam 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft not working with negative numbers also it shows only last maximum number saved in that variable 'TheResult'. Can we use With function in ForAll to make further changes ?

Was this reply helpful? Yes No