Answered

Radio Button Response Recording

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No