Unanswered

Estimate the total of values from a SharePoint list in PowerApps

(0) Share

Report

Posted on by Maurice

Hello together,

I'd like to estimate the total of values of activated checkboxes. The checkboxes in PowerApps look like this (the checkboxes "Workshops" and "Schulungen" are only there to show or hide the minor checkboxes):

These checkboxes are all stored in my SharePoint list:

Now i wan't to look up the price of this object (for example the checkbox "Collaboration") when it's value set on true. I created a separate list with some test prices for the checkboxes. This one looks like this:

For your understanding the column "PreisWSP" stands for Preis = Price, W = the checkbox "Workshops", SP = the checkbox "SharePoint". The total of the prices (obviously it should be possible to dial more than one checkbox) of the checkboxes which are set on true, should be shown in the description field "Total".

Is this possible?

I hope you can understand the question.

Thanks in advance,

Maurice

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Leo09 212 on at

Like (0)

Report
Copy link

Link copied!

How would you like the app to start estimate the values? On click of the checkboxes?

Was this reply helpful? Yes No
Maurice 20 on at

Like (0)

Report
Copy link

Link copied!

Yes, when one of the checkboxes get klicked, the Total should get updated / estimated. @Leo09

Was this reply helpful? Yes No
VincentM 68 on at

Like (0)

Report
Copy link

Link copied!

You could try creating a collection in the onVisible function of the page with all the values of the checkboxes. To then update that collection on the onCheck and onUncheck functions of the checkboxes and finaly save the collection to sharePoint with the click of a button at the very bottom.

Was this reply helpful? Yes No