Power Platform Community Forum Thread Details

Good day,

I have a PowerApps form with data from a SharePoint list. Some of my fields from SharePoint are "Number" type fields, and I would like to have 1 field as the sum of other Number fields.

For Example: I have a Field called "TOTAL AMOUNT", which should be the sum of other fields (SERVICE 1 AMT, SERVICE 2 AMT, etc..)

I don't seem to be able to achieve this in a formula, so I added a LABEL to the form "and tried to make the "SUMOFAMT" and point the Default Value of my SP Field "TOTAL AMOUNT" to it. "SUMOFAMT" successfully sums the fields, but pointing my SP FIELD "TOTAL AMOUNT" to "SUMOFAMT" doesn't work for some reason.

This is the formula for SUMOFAMT:

Value('SERVICE 1 AMT'.Text) + Value('SERVICE 2 AMT'.Text) + Value('SERVICE 3 AMT'.Text) + Value('SERVICE 4 AMT'.Text) + Value('SERVICE 5 AMT'.Text) + Value('SERVICE 6 AMT'.Text) + Value('SERVICE 7 AMT'.Text)

I tried this formula to assigned the value of "SUMOFAMT" to "TOTAL AMOUNT" without any success:

Value(SUMOFAMT.Text)

I would like some advice on whether I could directly add the "SUM" formula to my original SP field "TOTAL AMOUNT" or to assign the value of "SUMOFAMT" to "TOTAL AMOUNT"

Many thanks in advance

Luca

Categories:

Building Power Apps