Checkbox save data to excel

(0) Share

Report

Posted on by sirch2020

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

sirch2020 28 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sirch2020 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks Sik 🙂

Was this reply helpful? Yes No
Lacoste 93 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-siky-msft ;
I read your comment and i have the same question, i have three checkbox and i want to save value in excel table once i check one of the them. thanks.

Was this reply helpful? Yes No