web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Update SharePoint list...
Power Apps
Unanswered

Update SharePoint list column with a CountRows value when a multi-select combo box is changed

(0) ShareShare
ReportReport
Posted on by

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?

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at
    Re: Update SharePoint list column with a CountRows value when a multi-select combo box is changed

    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.

    vjefferni_1-1715932358529.png

     

    In the Data Card, select the control and set the Default property to be CountRows(comboboxBN.SelectedItems)

    vjefferni_0-1715932259140.png

     

    By default, the Update property of the Card will update the value in the read-only text input box to SP list.

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard