web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How do I Update a Shar...
Power Apps
Answered

How do I Update a SharePoint Choice column with values that don't match the Item choices in PowerApps?

(0) ShareShare
ReportReport
Posted on by 25

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 

PaulineShare_0-1650965733953.png

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"}})

PaulineShare_1-1650966108387.png

 

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

 

Categories:
I have the same question (0)
  • Verified answer
    PaulineShare Profile Picture
    25 on at

    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"})

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard