News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps How to get the max val...

Power Apps - Building Power Apps

Answered

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

(0) Share

Report

Report

Posted on by Sweety

40

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)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni on at

Like (0)

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

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.
v-jefferni on at

Like (0)

Report

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

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.