Announcements
Hi everyone,
I'm pretty new to power apps. I'm building an application and I need to only store some columns from a sharepoint list. These columns are selected by the user in some checkboxes so they aren't known until runtime. Is there a way to do this?
Thanks in advance.
Hi,Would you like to show some columns based on checkbox selection in a form or you want to save data of some columns based on checkbox selection in a form on button click
I would like to save the data, so I can save it to excel later
Hi @massanaRoger ,
In this case it may be best to use the Patch() function for the individual columns and check per column if the corresponding checkbox has been checked:
If(Checkbox1.Value,Patch(DataSource,Defaults(DataSource),{Column1: TextInput1.Text})); If(Checkbox2.Value,Patch(DataSource,Defaults(DataSource),{Column2: TextInput2.Text})); etc.
Edit: Forget about the above as it will create new items with only the one column specified...
Hello @massanaRoger - If I understood your request right, you have some checkboxes and based on the selected checkboxes you want to display the fields from the form? If yes, you can achieve that by the visible property of the data-cards
Switch( Checkbox_1.Value, true,true, false,false )
Hi,
Thanks for your answer, but besides of that, I also need to store the information so I can then create an excel file from it.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 846
Valantis 532
Haque 410
