Radio Control values from SP type column choice

(0) Share

Report

Posted on by Charlie Martharper

943 Season of Giving Solutions 2025

Hi guys!!

I am trying to get Values grom the choices in a SharePoint list column. Those only has 2 types, So I want it to look like an example I see:

What I have looks like this:

On the right is the gallery which will use this radio as filter. How could I make this Radio control get the values from the SP list, and then make the gallery those values to filter from it?

Categories:

Connector development

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Suggested answer

Gil0 128 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

To get values from your SP list, use the following in your radio control's Items property:

Choices([@YourSPListName].ChoiceColumnName)

Then, set your gallery's Items property to:

Filter(YourSPListName, ChoiceColumnName.Value = Radio.Selected.Value)

If this answer helped you out, please mark this post as resolved so that others may reference to it.

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Please try below:

Radio Button Items Property:

Choices([@Admins].'Role') //Replace 'Admins' with your SharePoint List name - Replace 'Role' with your SharePoint list column

Gallery Items Property:

Filter( MyList, //Replace 'MyList' with your SharePoint list name Category.Value = Radio1.Selected.Value //Replace 'Category' with your SharePoint choice column ) //Radio1 - User your control name

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Charlie Martharper

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kalathiya!

Sorry for being late, I tried it but it seems there is an issue:

This is the column in the SharePoint:

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Maybe you’re passing the incorrect column name there. Could you try copying the column name directly from the SharePoint list and pasting it into your code?

Please try this - Update Code:

Choices([@'Guia derivacions 04.12.25'].'Grups_Visites')

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!
@Kalathiya nice it was that

I have 2 questions: Is it possible to have it horizontal and not vertical? So it can be seen all in one line.

The gallery items looks like this:

Filter(

'Guia derivacions 04.12.25',

// AGA filter (ignore if no selection)

(IsBlank(ComboBox_AGA.Selected)

|| AGA.Value = ComboBox_AGA.Selected.Value // If SharePoint column is Choice: use .Value

// If AGA is text: use AGA = ComboBox_AGA.Selected.columnname(depending on Items binding)

)

&&

// ESPECIALITAT filter (your current one, made optional)

(IsBlank(ComboBox_Especialitat.Selected)

|| ESPECIALITAT = ComboBox_Especialitat.Selected.Value

)

)

How can I add that in there?

Filter( MyList, //Replace 'MyList' with your SharePoint list name Category.Value = Radio1.Selected.Value //Replace 'Category' with your SharePoint choice column ) //Radio1 - User your control name

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Charlie Martharper,

Yes, you need to set the Layout property to Horizontal for the radio button and increase the width of the radio button control to display everything on one line.

Radio: Layout Property:

Layout.Horizontal

Question 2:

Since the Radio control expect the value, you should use the Distinct() function directly on the column you want to display.

Distinct( Filter( MyList, Category.Value = Radio1.Selected.Value ), YourColumn )

Distinct() is applied to return a single-column table.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya

Where exactly I have to add this? In the gallery control? What do you mean by column? Items in gallery:

Filter(

'Guia derivacions 04.12.25',

// AGA filter (ignore if no selection)

(IsBlank(ComboBox_AGA.Selected)

|| AGA.Value = ComboBox_AGA.Selected.Value // If SharePoint column is Choice: use .Value

// If AGA is text: use AGA = ComboBox_AGA.Selected.columnname(depending on Items binding)

)

&&

// ESPECIALITAT filter (your current one, made optional)

(IsBlank(ComboBox_Especialitat.Selected)

|| ESPECIALITAT = ComboBox_Especialitat.Selected.Value

)

)

Items in Radio:

Where I add the distinct? There will be no values repeat it so would be great yes.

Should I creat an Icon to clean the radio if want all values again?

If a option in the radio is selected, show the X icon right next to it, and when click it clean the radio and hide the X

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Charlie Martharper,

This you need to do in Radio button item Property:

Radio - Item Property

Distinct( Filter( MyList, Category.Value = Radio1.Selected.Value ), YourColumn //Whatever column you want show as selection that column name you need to place here. )

Yes, you can add one Icon to reset the value.

Icon - OnSelect Property:

Reset(RadioButtonControlName); //Replace with RadioButtonControlName - your radio button control name

Icon - Visible Property:

!IsBlank(RadioButtonControlName.Selected) //RadioButtonControlName - Replace it with your control name

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kalathiya

The icon thing it works, but the radio item property I am stuck.

What should I put in category, or why it's wrong?

Does then the radio filter the things in the gallery?

Was this reply helpful? Yes No