I have 7 fields that must sum to a specific amount prior to submittal to SharePoint list. I have SP list handling the validation as well as returning them to the selection screen to adjust responses but was wondering if there was a way to calculate these columns and display on the Powerapp form as these amounts are selected from the dropdowns. I do have a total amount field in sharepoint but of course it doesnt sum until submitted.
I was then wanting to not allow the "Submit" button be displayed unless the specified amount was achieved. Any ideas? I can not find anything on the subject.
Solved! Go to Solution.
So you have 7 fields containing an amount and you want the Submit button to be enabled only if the sum of the 7 fields is greater than a specified amount, is that right ?
Your Amount input look like dropdownlist so I assume 7 dropdown named : Amount1, Amount2, ... Amount7. And I will fixe the specific amount to 1000 to enable the Submit button.
if(Sum(Value(Amount1.value), Value(Amount2.value), Value(Amount3.value), Value(Amount4.value), Value(Amount5.value), Value(Amount6.value), Value(Amount7.value)) > 1000, DisplayMode.Edit, DisplayMode.Disabled)