Hello guys I'm trying to do a page using checkbox more then 2...but now I'm trying with 2 checkbox and text
but when I'm selected 2 box only 1 data go save in excel table....how do I want to make 2 data save in excel 1 row...
If success i'll proceed with more then 2 checkbox..
Here the screenshot and the code I used:
Any solution for this problem? Hopefully I can get hep ASAP
Rgd
Azzam
Solved! Go to Solution.
Good morning!
You do two calls to Patch, so naturally you get two records in the database. If you want only one record, you have to make only one call to Patch!
Patch(Table1_1, Defaults(Table1_1), {NAME:User().FullName,RESULT1:Checkbox1.Text, RESULT2.Checkbox2.Text})
What you also might want to do is to check if a checkbox have been clicked, so you have to add an If-statement:
Patch(Table1_1, Defaults(Table1_1), {NAME:User().FullName, If(Checkbox1.Value, RESULT1:Checkbox1.Text), If(Checkbox2.Value, RESULT2.Checkbox2.Text)})
Lastly, you might want to store the current user in a variable at app start, using either Set or UpdateContext, so you don't have to do the time consuming call to User() every time.
Good luck!
Good morning!
You do two calls to Patch, so naturally you get two records in the database. If you want only one record, you have to make only one call to Patch!
Patch(Table1_1, Defaults(Table1_1), {NAME:User().FullName,RESULT1:Checkbox1.Text, RESULT2.Checkbox2.Text})
What you also might want to do is to check if a checkbox have been clicked, so you have to add an If-statement:
Patch(Table1_1, Defaults(Table1_1), {NAME:User().FullName, If(Checkbox1.Value, RESULT1:Checkbox1.Text), If(Checkbox2.Value, RESULT2.Checkbox2.Text)})
Lastly, you might want to store the current user in a variable at app start, using either Set or UpdateContext, so you don't have to do the time consuming call to User() every time.
Good luck!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
201 | |
71 | |
51 | |
49 | |
20 |
User | Count |
---|---|
261 | |
123 | |
86 | |
79 | |
72 |