web

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

News and Announcements icon

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

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)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation