You’re offline. This is a read only version of the page.
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?
Hi @AnnetteM ,
You can simply add CountBN column into the form, and change the DisplayMode property to be View, means this column is always read only.
In the Data Card, select the control and set the Default property to be CountRows(comboboxBN.SelectedItems)
By default, the Update property of the Card will update the value in the read-only text input box to SP list.
Best regards,
Share
Report
All responses (
Answers (
757
