Power Platform Community Forum Thread Details

I have a "classic" SharePoint list that has a couple choice columns where the fill-in choices are enabled. See the screenshot.

Now, I've changed the list to use the modern experience and created a custom Power App form associated with it. The Power App is also using the modern controls.

The issue I'm having is the choice column with fill-in's (RAID Level 1) is also displaying choices that were filled in by the user. I do not want to display those as options. I only want to display the choices listed in the field (RAID-1, RAID-5, & RAID 10).

Currently the RAID Level 1 datacard Items property is set to:

Choices([@'New Server Requests'].'RAID_x0020_Level_x0020_1')Thanks for any help you can give!
 
 

Categories:

Building Power Apps

Hi there,

the problem is you are using the function wrong, Choices function does not provide the list of current choices of a column, by default, Choices([@'New Server Requests'].'RAID_x0020_Level_x0020_1') includes both predefined and user-filled choices. To exclude fill-in values, you need to manually filter the options.

Set the Items property of the ComboBox to only include the predefined choices:

Filter(
Choices([@'New Server Requests'].'RAID_x0020_Level_x0020_1'),
Value in ["RAID-1", "RAID-5", "RAID-10"]
)

If you don’t want to hardcode the choices, check if SharePoint’s predefined options have a specific property:

Filter(
Choices([@'New Server Requests'].'RAID_x0020_Level_x0020_1'),
Not(IsBlank(Value)) && Not(Value in Distinct('New Server Requests', 'RAID Level 1'))
)

I hope this helps you to understand better how Choices functions works,

Regards.