Announcements
I'm creating a power app that includes multiple screens, each with a sequence of radio button selection options. I want to record all of the collected data neatly but can't figure it out. Does anyone know how to write all of the results back to an Excel file?
thank you!
What is the use case for this going to be? PowerApps may not necessarily be your best Microsoft tool for just collecting responses. So curious what the work flow for this app will be overall.
Hi @Anonymous ,
Do you want to save all selected values to an excel table?
If these Radio Controls are in multiple Form Controls, maybe you could try the following formula:
Patch(DataSource,Defaults(DataSource),Form1.Updates,Form2.Updates)
If these Radio Controls are just on multiple screens, maybe you could try as follows:
Patch(DataSource,Defaults(DataSource),{ColumnName1:Radio1.Selected.Value,ColumnName2:Radio2.Selected.Value,ColumnName3:Radio3.Selected.Value,ColumnName1:Radio4.Selected.Value})
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-patch#modify-or-create-a-record-in-a-data-source-1
Best Regards,Charlie Choi
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.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
