Announcements
Hi,
I have a list in sharepoint lists that has a yes/no column and I want to be able to display these values on my dropdown. I've tried using filter and distinct but all it prints out is true.
Thanks
Typically a yes/no column in SharePoint evaluates to true or false. So you won't see yes/no. I am guessing that you are trying to set the default value of your column to the value in the list item?
You can just set the dropdown's Items() property to ["Yes","No"] and achieve the same result
I have another function that updates and changes the value of the yes/no column and your solution was in my original try but powerapps wouldn't let me patch the change as it was a text value and not a boolean value
I'm trying make the drop down display yes no OR true false because I want to patch whatever the user chooses into a yes/no column
Sorry, I wasn't aware that you were trying to patch things (based on the first post I assumed you were just trying to display "Yes" or "No").
Edited:
n your patch statement you can use a switch or an If statement in that specific value.
So you could do this:
Patch(datasource, defaults(datasource),
{
Somecolumn: somevalue,
Somecolumn: Switch( dropdownX.Selected.Value,
"Yes", true,
"No", false,
Somecolumn: somevalue
})
Patch(MMB_desks,Defaults(MMB_desks),{DeskAvailability: Switch(drpDeskAvailable.Selected.Value,"Yes", $true,"No", $false)})
This gave me an error, I was getting a type error in the switch statement, and DeskAvailability was expecting a Boolean but I got an error instead
I edited my reply. Remove the $ before the True and False.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
