Answered

Patch a Radio option Help

(0) Share

Report

Posted on by ICRdatalover1

Hi everyone,

Pretty new here with PowerApps, Im trying to create a form through a template Microsoft offer you to start. Everything works fine except when I try to "Submit" the information to the excell (The datasource).

The problem seems to be the Radio option, it does not give me an error, just doesnt show anything, below is my code for the "Submit" button:

Patch(Responses,Defaults(Responses),
{ ResponseId:CountRows(Responses)+1},
{ Answer1:Radio1.SelectedText.OptionText}
);
Navigate(Done, ScreenTransition.Fade)

I have more answers and they works fine, they stored the info back in the excel when I pressed the "Submit" button.

The Radio1 its just a "Choose" between 6 options. It doesnt display any errors so im confusing what im doing wrong and how to store the selected option of this Radio back to the excell, the column "Answer1"of this excell is "Text".

Hopes someone can help me, I have been struggling with these for two days....

Thank you in advance.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try:

Patch(Responses,Defaults(Responses),
{ ResponseId:CountRows(Responses)+1},
{ Answer1:Radio1.Selected.Value});
Navigate(Done, ScreenTransition.Fade)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
ICRdatalover1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24 ,

Thanks for the fast reply. Unfortunately does not work. Now it gives this error:
"The type of this argument "Answer1" does not match the expected type "text", found type "Error".

The Radio Im trying to use have 6 different options to choose, they are text, the code of the Radio is on the image.

Thank you in advance.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

show a screen shot of the formula with the error.
Patch(Responses,Defaults(Responses),
{ ResponseId:CountRows(Responses)+1,
Answer1:Radio1.Selected.Value});
Navigate(Done, ScreenTransition.Fade)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
ICRdatalover1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, here is the error with the ".Value"

Thank you in advance
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ICRdatalover1 ,

Your original code is perfect, I think the problem is from Reset property of Radio.

You set the Reset property of Radio to Button3_4.Pressed, but the Button3_4 is to Patch data to excel, so every time you click on the Button3_4, Radio control is reset and nothing can be saved in Excel.

Please try to clear the Reset property and try again to see if the issue is fixed.

Hope this helps.

Sik
ICRdatalover1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

That was brilliant and exacly the problem, now it works perfect. Thanks so much really appreciated.

But now how can I reset the whole form?? Is there any other way??

Thanks again!!

Kind regards
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ICRdatalover1 ,

If you want to reset the whole Form, try with ResetForm() function.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form

Sik