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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create radio button wi...
Power Apps
Answered

Create radio button with three options that writes back to an empty column when selected

(0) ShareShare
ReportReport
Posted on by 9

Hi,

I have a table with a blank column LOCATION_ID that I want to use to capture the user selection in my app from a radio button.

How do I create the radio button to display the three options : HERE, NOT HERE, OFFSITE in my gallery, then when the user selects one of those options, it writes back to the table- replacing the blank value with the selection. 

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,488 Super User 2025 Season 2 on at

    Hello,

     

    You can't, not with a single radio button. You would need Checkboxes or a Dropdown or 3 radio buttons.

     

    What is the ID a string?

     

    Either way, you would have to have them select and then use a Patch statement to update that table (is it excel, dataverse?)

     

    Are you binding the Row itself to a Form in which case you can just submit? Although it will possible not create the multiple viewed select option you want, so you'd have to customize it per my details above.

    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Amy_Archibald Profile Picture
    9 on at

    Thanks for the quick response!

    I originally designed a radio button with the three options- but it doesn't write back to anything. But now I need to create a PBI report based on the table, so I need to update the selections from the app.

     

    I have a lot of customized formatting in the UI based on the radio button selection that I couldn't figure out how to do with multiple fields. I.E. when selected, add/remove from collections based on the value of another field. 

     

    So the best option is to create three separate fields in the UI, each that patch to the same blank LOCATION_ID column. And then just figure out how to make them toggle on/off when another button is selected. Then rebuild all the conditional formatting and collections. ?

     

  • Michael E. Gernaey Profile Picture
    53,488 Super User 2025 Season 2 on at

    Hello :-),

     

    Well, I guess in your situation it is the best option. Without seeing your code, the collections etc I cannot really explain how to do it for your design.

     

    However, are you saying now that you did this and it works, or you are asking if that is what you should do. It sounds like you already did it, so I am not sure 🙂

     

    let me know can I can help. If you need help patching the back end, it depends a little on how you bound the data to the front end. Writing a patch is pretty straight forward if its an update.

     

    Patch(mydatasource, fieldToUpdate = newValue, LookUp(mydatasource, someuniquefield = someuniquevalue));

    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Ami K Profile Picture
    15,679 Super User 2024 Season 1 on at

    @Amy_Archibald - I am reading your question very differently from @FLMike.

     

    As I understand it, you have what I am assume is a SharePoint list and there is a field in that list called LOCATION_ID. The data type for that field is Single Line Text.

     

    You have embedded a Radio control inside your Gallery. You want the Radio control to display 3 options. You also want to save the selected option for the selected record back to your SharePoint list, presumably via a Button.

     

    If the above is correct, try:

     

    1. Inside your Gallery, insert a Radio control

    2. In the Items property, enter:

     

     ["HERE","NOT HERE","OFFFSITE"]

     

     

    3. Set the Layout property of the Radio control to Layout.Horizontal 

    4. Add a Button control inside your Gallery

    5. On the OnSelect property of the Button, enter: 

     

    Patch(
     'Your Data Source',
     ThisItem,
     {LOCATION_ID: Radio1.Selected.Value}
    )

     

     

    6. In the Default property of the Radio control, enter: 

     

    ThisItem.LOCATION_ID

     

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

    Imran-Ami Khan

     

  • mbarbosa Profile Picture
    146 on at

    Hi @Amy_Archibald ,

    I guess you could try this without having to give up on the radio button.

     

    You first should set your radio control "items" property to the options you want, in your case:

    ["HERE", "NOT HERE", "OFFSITE"]

     

    Then, you can use an if formula in the OnSelect property something like this:

    If(Self.Selected.Value="HERE", Patch(...patch your datatable column here with value "Here"...),If(Self.Selected.Value="NOT HERE", Patch(...patch your datatable column here with value "Not Here"...), Patch(...patch your datatable column here with value "Offsite"...))

     

    You can also try a Switch formula, it may be more neat than the nested ifs.

     

    Hope this helps!

  • Amy_Archibald Profile Picture
    9 on at

    If I make the button inside the gallery, I will have a button on each item and the user will have to select the radio, then click the button to send the update to the table.

    Is there a way to use a button outside the gallery? I already have one that navigates to another screen that displays the contents of the collection created by the selection.

    If not, can I add that code to the OnSelect field of the radio button itself rather than an additional button in the gallery?

  • Verified answer
    Michael E. Gernaey Profile Picture
    53,488 Super User 2025 Season 2 on at

    If you want to patch the moment that they update it,

     

    Then you should use the OnChange event of the radios. Then do a Patch in the OnChange event. I dont really recommend that, but it sounds like what you want.

     

    however that means every single time they click it it patches even if they were like whoops I meant this one and it would keep patching.

     

    Otherwise yes, you would add Button (lets called it SaveButton), outside of the Gallery. And lets pretend that the Gallery is called MyGallery. 

    You would access the gallery by using MyGallery.Selected.InsertControl/ColumnName here

    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Amy_Archibald Profile Picture
    9 on at

    Yes, the app is shared with multiple people accessing the data at the same time, so immediate updates are necessary.

    I put the code in the OnSelect and it updated the table.

    Will add to the OnChange as well.

    Thanks so much for all your help!!

     

  • Ami K Profile Picture
    15,679 Super User 2024 Season 1 on at

    @Amy_Archibald - the solution I provided above was purely based on how I interpreted your description:

     

    "...then when the user selects one of those options, it writes back to the table- replacing the blank value with the selection. "

     

    You can of course create a button outside of the Gallery, and save each Radio selection in Bulk into whatever your data source is. I am happy to share how that is done with you, but I think you have identified a satisfactory solution.

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard