Add Radio button control in PowerApp for choice field in SharePoint list

(0) Share

Report

Posted on by manjotsingh057

164

I have a choice button field in SharePoint List and i am developing a PowerApp for that list.

I want to render that choice field as radio button on form in PowerApp.

I added a radio button control in the desired datacard.
I set the "Default" property for dropdown field to radio button selected value.
Once i select radio button as "Yes" , dropdown field also set "Yes".

Issue: Once i click on save it gives error "The requested operation is invalid. Server Response. A value must be provided for item".

Any suggestions ?

Screenshot below.

custom field issue.png

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @manjotsingh057,

This is because the Choice field is a record type.

Single text value will not work for saving the Choice field.

Please take a try to change the Default property of the Choice field as below:

If(Radio1.Selected.Value="Yes", {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:0, Value:"Yes"} )

This assumes that the Choice field definition under SharePoint list is:

Yes

No

Other

Which means the Yes value should be at the top of the Choice value.

Doing this would make the Saving work as expected.

Further, for the error message, please make sure you have all the required field entered with a valid value.

If any required field is not provided with a valid value, there would be error messages popped out, so per this error, you should have the Item field not entered or left blank.

Regards,

Michael
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-micsh-msft
Thanks Michael,

I tried doing that. It stores "
#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference
" as field value rather than yes/no. However item is getting saved fine but with wrong values.

Please suggest.
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!

Solved by modifying the advanced properties of control. Setting value property instead of odata
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Just a note for others who may stumble on to this. I found that you need to set the default property of the CARD, not the dropdaown control to the JSON value noted. in my case I set the CARDs Default to

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:1,
Value:RadioRegionalApproval.Selected.Value}

note that you can refernece the radio buttons value directly in the Json( no need for that if statement).
rgbrasel 68 on at

Like
a
(8)

Report
Copy link

Link copied!

If it appears in the OOTB web form in SharePoint as multiple checkboxes or radio buttons, the PowerApps development team should have done the work to make sure that it shows up as such in PowerApps. I would like for my users to be able to select multiple items from a Choice datatype. This isn't some esoteric request--this is basic, simple functionality for any form creation tool. This is ALMOST as ridiculous as Microsoft Forms not being able to handle time fields.

Do better by your power users, please. I'm sick of the constant disappointment every time you launch something that looks promising.