Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Create, View and Update results of Checkbox



My App uses the basic flow of opening screen with gallery to create and select records, an edit screen then another gallery screen with a Checkbox on it to record a number of possible outcomes and scores.

The checkbox get its values from a list


I have set the checkbox to be reset to false each time that screen becomes visible using the Onvisible property UpdateContext({ResetCheckbox:true});UpdateContext({ResetCheckbox:false}) then setting the Reset property of the checkbox to ResetCheckbox

I am successfully writing to 2 other lists. If I go back to my start screen and select an existing record I can successfully update the list results of the Edit form but as is expected my checkbox has been cleared. Is there any way to show the results form my List in the check box gallery so that I don't need to check all boxes again.




Off out for a well earned break now. 





Community Support Team
Community Support Team

Re: Create, View and Update results of Checkbox

Hi @KennyDon ,


Could you please share more about your gallery and your form?

Is Title in your SP list is Single Line type or Choice?

What is the formula expression of your controls in your form?

I try to reproduce your situation and your issue on my side.




Best Regards.


Level 10

Re: Create, View and Update results of Checkbox

Thanks for posting in the community @KennyDon - can you review the above reply and update the thread when you have a chance? 


Thank you,



Level: Powered On

Re: Create, View and Update results of Checkbox

Thanks for your response Yumia.

'Title' is single line text in the sharepoint list called TM_Pedestrian_Generators. The other field called PF_Score is used to apply a score to the value of the title. So if I select 'School Entrance' and 'Playground Entrance' my total score would be 30.

I have 2 other list that I am writing to. 'List A' accepts data into choices fields and depending on the choice selected applies a score. All these scores are added up and held in and held in a variable which is then written to my list.

Set (
varDetScore, varARVal + varPed16plusVal + varPed16minusVal + varTSVal + varTFVal + varGradVal + varFrontVal
UpdateContext({ResetCheckbox: true});


'List B' holds the result of each check box value and score. I use the following statement to add up all the values checked.


OnSelect Check runs the following code:

RemoveIf(TM_Priority_Ped_Gen, SiteID = editMainForm.LastSubmit.ID);
ForAll(Filter(galPedGen.AllItems,chkPedGen.Value = true),
SiteID: editMainForm.LastSubmit.ID,
PedGenID: ID,
PedestrianGenerator: Title,
PFScoreVal: PF_Score
Set (varPedScore,Sum(Filter(TM_Priority_Ped_Gen,SiteID in Text(RecordID)),PFScoreVal));
Patch(TM_Prioritisation,First(Filter(TM_Prioritisation,ID = editMainForm.LastSubmit.ID)),

DetailScore: Value (varDetScore),
PedGenScore: Value(Ped_Gen_Score.Text),
TotalScore: Value(varDetScore) + Value(Ped_Gen_Score.Text)


I think I need to add an If statement to check if a record exists. If it exists I do an update, if it does not exist I should create a new record.

The two lists I am writing to are related with a site ID. List A holds the unique site Name and Site ID and List B contains multiple scores based on the check box relating the each unique site.

Hope this makes more sense now.



Helpful resources


Power Apps Super User Class of 2020

Check it out!


New Badges

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,758)