Answered

Radio Button Response Recording

Like (0) Share

Report

Posted on 8 Jul 2022 11:55:10 by Community Power Pla...

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!

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

v-yujincui-msft on 11 Jul 2022 at 07:21:36

Like (0)

Report
Re: Radio Button Response Recording

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
TheRobRush 11,121 Super User 2025 Season 1 on 08 Jul 2022 at 14:52:13

Like (0)

Report

Re: Radio Button Response Recording

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.