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

[Amy_Archibald]

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. 

[FLMike]

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]

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. ?

[FLMike]

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

[Amik]

@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]

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]

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?

[FLMike · Accepted solution]

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]

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!!

[Amik]

@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.