New to Powerapps and learning alot along the way. I'm using a multi-select checkbox gallery in a form that's connected to a choice column in a SharePoint list. With each checkbox selection, I want to count it as 10 points. My OnCheck formula is:
Collect(colMultiCheckBoxData, {Value:ThisItem.Value, Points:10}). (Points is not a column in the SharePoint list. I'm adding it as a column in the collection table).
I added a label to get a sum of the selected checkboxes using Sum(colMultiCheckBoxData,Points)
I can save the form to the SharePoint list successfully with the selected items saved to the choice column. Is there a way to fetch the points for the selected checkbox items if I want to view or edit the record to make selection changes using a clearcollect?

Report
All responses (
Answers (