Unanswered

How to get the max value nd so sum by using for all

(0) Share

Report

Posted on by Sweety

Hi Can some one tell me how to get the max value of each dropdown in gallery and do sum on it I tried the formula Forall(gallery1.all items ,max(tblname,columnname)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-jefferni on at

Like (0)

Report

Hi @Sweety ,

Could you please share more about the scenario? What is the Items of the Gallery as well as the Dropdown in the Gallery? Screenshots would be very helpful.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Sweety ,

I assume you have a gallery and in which there are several dropdowns for each item and a Label to display the max value. If you would like to get the total of all the max value in the gallery, please follow below steps:

1\ Label inside the Gallery set Text to:

Max(Dropdown1.Selected.Value,Dropdown2.Selected.Value,Dropdown3.Selected.Value)

2\ Label outside the Gallery set Text to:

Sum(ForAll(Gallery1.AllItems As A, A.Label2.Text),Value)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No