
I am designing a questionnaire in PowerApps and the choices are Never, Often, Sometimes All the time. However I don't want the options to be visible to form a table
To evenly space out the radio buttons I have set the Items of the Radio control to
["Option1","Option2","Option3","Option4"] and hidden them using Transparent Color Text.
I now want the Update property of the Datacard in the form to write back the correct value to SharePoint list so have set it to
If(Radio1.Selected.Value="Option1",{Section1ExplainTasksClearly: {Value:"Never"}},Radio1.Selected.Value="Option2",{Section1ExplainTasksClearly: {Value:"Sometimes"}},Radio1.Selected.Value="Often",{Section1ExplainTasksClearly:{Value: "Average"}},Radio1.Selected.Value="Option4",{Section1ExplainTasksClearly:{Value: "All the time"}})
I have also tried
If(Radio2.Selected.Value="Option1",{Section1ProvideSupport: "Never"},Radio2.Selected.Value="Option2",{Section1ProvideSupport: "Sometimes"},Radio2.Selected.Value="Often",{Section1ProvideSupport: "Average"},Radio2.Selected.Value="Option4",{Section1ProvideSupport: "All the time"})
This does not give me an error when submitting the form but it does not write back the selected option to the SharePoint list.
Any ideas please? Thanks
I have just found the answer elsewhere
If(Radio1.Selected.Value="Option1",{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value:"Never"},Radio1.Selected.Value="Option2",{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value:"Sometimes"},Radio1.Selected.Value="Often",{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value:"Average"},Radio1.Selected.Value="Option4",{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value:"All the time"})