I have a SharePoint list that contains a multi-select column (BN), a numeric column (CountBN) and a calculated column (TotalBN). The calculated column TotalBN is CountBN*50.
In my PowerApp, I do not display the CountBN column -- it's only used in the SharePoint list for the purpose of calculating TotalBN. How I envision this working is that a user can select many choices in the BN column. The OnChange of the BN column would update the CountBN column with a value of CountRows(BN). Then when the form is submitted, the CountBN column is updated as well as the calculated TotalBN.
Even better, when the form appears, I would like to have a text label of CountBN appear (showing the value of CountBN SP column), and have that text label change when BN is changed. So if the form opens with CountBN having a value of 5, and I change the values in combo box BN to remove one option, I would like the text label to change to 4 and then of course, when the form is submitted, the SP list column CountBN changes to 4 as well.
Is this possible, or should I set it up differently?


Report
All responses (
Answers (