cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rak
Level: Powered On

Calculate Sharepoint list fields

Hello,

 

I'm making some kind of calculator for our sales department. The thing is we have our price list in Sharepoint and I want to addition every price value when checkbox=true and show total price. Is that even possible? If so, how? Thank you so much for answers.

PowerAppsMarketing.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Level 10

Re: Calculate Sharepoint list fields

Hi @Rak

Yes, please try this:

Sum(Filter(Gallery1.AllItems, MyCheckbox.Value), MyPriceColumn)

Where obviously you substitute the actual names from your app.

Please let me know if it works.

 

PS You might want to do this as well:

Text(Sum(Filter(Gallery1.AllItems, MyCheckbox.Value), MyPriceColumn), "#,##0.00")

View solution in original post

2 REPLIES 2
Meneghino
Level 10

Re: Calculate Sharepoint list fields

Hi @Rak

Yes, please try this:

Sum(Filter(Gallery1.AllItems, MyCheckbox.Value), MyPriceColumn)

Where obviously you substitute the actual names from your app.

Please let me know if it works.

 

PS You might want to do this as well:

Text(Sum(Filter(Gallery1.AllItems, MyCheckbox.Value), MyPriceColumn), "#,##0.00")

View solution in original post

Rak
Level: Powered On

Re: Calculate Sharepoint list fields

Yes! It's working. Thank you so much 🙂

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,886)