Update SharePoint choices column with Slider Value

[MH5]

I have a Form which source is a SharePoint list, within the form are a number of combo boxes which update the respective SharePoint choices columns.

I didn't like the look of the form with the combo boxes and due to the volume of choices columns, I want to replace them with sliders where it seems feasible.

There's about 20 Choices columns where the values are text.

I removed the ComboBox in the first datacard and placed a slider input and added a label with a bunch of IF statements to update the label with appropriate context to the 1-5 values, the label text matches the choices.

However, now I need the datacard to update the SharePoint list's choices column and I can't get it to work.

I've used a previous post here which covered this same issue, but the solution offered there does not seem to work for me.

For reference, it's this post: Solved: Re: Pass global variable value to select drop down... - Power Platform Community (microsoft....

I've tried the below on the Default property of the ComboBox, with the intent to just make the Visible property false after.

LookUp(Choices([@'Skills-Matrix'].'Presentation Skills'),Value = SliderContext_1.Text)

However that did nothing for me.

I added the below as the OnChange property of the slider

UpdateContext({DCV5ID:Slider1.Value})

The context variable gets updated but the Update property for the DataCard doesn't update the choices column with the below:

 LookUp(Choices([@'Skills-Matrix'].'Presentation Skills'),Value = (DCV5ID)

For testing purposes, I modified one of the choices columns in SharePoint where each string was replaced by a value between 1-5

I then used the below as the Update property for the DataCard

LookUp(Choices([@'Skills-Matrix'].'Presentation Skills'),Value = Text(DCV5ID))

This successfully updated the choices column I modified, but I can't get the choices columns for the other datacards to function in the same way.

Am I making an obvious mistake with the above?

Is there another method to updated a choices column using a slider in a form?

[WarrenBelz · Accepted solution]

Hi @MH5 ,

This may not be perfect, but it seems to work - Max of slider (Min is 1)

CountRows(Choices([@'Skills-Matrix'].'Presentation Skills'))

Default of Slider>

Round(Self.Max/2,0)

and the value you are after is

Index(
    Choices([@'Skills-Matrix'].'Presentation Skills'),
    SliderName.Value
).Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[MH5]

Thanks @WarrenBelz 

---

Index(
    Choices([@'Skills-Matrix'].'Presentation Skills'),
    SliderName.Value
).Value

---

I used the above on the DataCard Update Property which worked after removing the .value for the index (it wouldn't take value, just records).

This updates the column in SharePoint with the numerical value of the slider (which is all I needed for most columns).

Is there a way to get the text value displayed for these dropdowns? For example the marked value below?

Am I better off just removing the choices in SharePoint and turn them into text input only?

[WarrenBelz]

Hi @MH5 ,

I do not use SharePoint Choices columns at all unless I need the multiple value structure for storage. The Max of the slider can simply be the number of items in your choice selection, so it may be a filtered list. You then just need the Index of the same filtered list using the number chosen in the slider.

[MH5]

I did a whoopsie, was indexing the wrong choices column. Your formula works exactly as needed!

Thanks 🙂