cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sirch2020
Regular Visitor

Checkbox save data to excel

Hi guys, just need your help on how to do this.

 

I have 5 checkboxes on a screen, let's say Checkbox1, Checkbox2, Checkbox3, Checkbox4, and Checkbox5 

 

For example if  user tick the Checkbox1, Checkbox3, and Checkbox5

 

How to check which checkboxes  are ticked and get its value?

 

If I want to save the data to Excel in different row, is it possible?

 

What I mean, is something like this:

Excel:

Row 1 = Value of Checkbox1

Row 2 = Value of Checkbox3

Row 3= Value of Checkbox5

 

Thanks for any help, I did some search ForAll syntax is able to do it but i'm still confused just started learning about this PowerApps. Thanks again.

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @sirch2020 ,


if you want to save the checkbox values to different rows, please try put the following Patch() function to OnCheck property of check box. Save the check box value to a new row when chekc box is ticked.

 

Patch('Table Name', Defaults('Table Name'), {ColumnName: CheckBox1.Value}) // CheckBox1.OnCheck

Patch('Table Name', Defaults('Table Name'), {ColumnName: CheckBox2.Value}) // CheckBox2.OnCheck

 

Hope this helps.

Sik

View solution in original post

3 REPLIES 3
sirch2020
Regular Visitor

Basically, i'm looking for ways on how to add  values of  checkboxes into an Excel sheet on different rows?

 

1st row = value of 1st checkbox selected

2nd row = value of 2nd checkbox selected

 

The order does not really matter as long as it is on different rows,

 

Is datacard suitable for this? 

 

Sorry just beginning on PowerApps, thanks for any ideas and help.

v-siky-msft
Community Support
Community Support

Hi @sirch2020 ,


if you want to save the checkbox values to different rows, please try put the following Patch() function to OnCheck property of check box. Save the check box value to a new row when chekc box is ticked.

 

Patch('Table Name', Defaults('Table Name'), {ColumnName: CheckBox1.Value}) // CheckBox1.OnCheck

Patch('Table Name', Defaults('Table Name'), {ColumnName: CheckBox2.Value}) // CheckBox2.OnCheck

 

Hope this helps.

Sik

View solution in original post

Thanks Sik 🙂

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,623)