I swear Microsoft is making things super difficult for super basic things.
Why is it so hard to check the value of a sharepoint Yes/No column in a flow? I checked 10 responses in this forum and they are all different.
Why do I need to:
- initialize a special variable;
- deal with triggervalues and stuff;
- deal with "null" values because apparently "unchecked" means "null"???
To simply check a Yes/No field. Why do I need to reinvent the wheel for this?
[
{
"ID": 1,
"Available": true
},
{
"ID": 2,
"Available": null
},
{
"ID": 3,
"Available": true
},
{
"ID": 4,
"Available": false
},
{
"ID": 5,
"Available": true
},
{
"ID": 6,
"Available": true
}
]
Hi,
I am having the same issue. I difined a Yes/No colume in a LIST and check it in Power Automate.
I am sure it's a Yes/No column not Choice or anything else.
I got it worked in Power Automate Condition node as below shows,
However, Filter arrary node did not work for me
If the column is defined in SharePoint as a Yes/no column then it should work. Are you sure the column isn't a choice column or something else? Have you added a Compose just before the condition to see what the actual value of that column is?
@Pstork1 This does not work for me.
@Pstork1 Hi, I know this is an older thread, but I am also dealing with an issue getting Power Automate to update a column based on if a Yes/No column changes from its default "No" to be "Yes", and it will not recognize the status change from "No" to "Yes", using either "true", or "Yes" in the Condition. I found this screenshot you posted here and put that in and it is still showing the Expression result as being false.
Could you take a peek?-
https://powerusers.microsoft.com/t5/Building-Flows/Update-Item-Not-working/m-p/2625282#M294264
I made a Choice column, added No and Yes, made No the default, and used a Condition action where if Choice is equal to Yes, perform Yes action.
The logic is actually quite simple. You do the same check, as you do for an empty field.
If the field isn't EMPTY/NULL then it must be checked.
Same logic applies if you do a conditional check.
EASY WAY using "Get Items" to get all or specific "Checked Items" as usable array.
After adding your initial Trigger (Manual, When an Item is created or modified, etc.)
1. Add Get Items
2. In Get Items go to Filter Query
3. Enter ODATA like so
ColumnName ne null
(note if typing null doesn't work for you, then click on add as an expression (fx) and add the null this way)
Now when you run your Automation the Get Items connector will get all Items that are checked.
Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later. It would also help if you provided more details. Checking a Yes/No field in SharePoint in Power Apps using an actual Boolean value will work. If its not working for you please post screenshots in a new post and we'll get you an answer.
I used the Initialize a Variable action to take the boolean data collected and convert it into a string. Once a string, the conditional parameter can be a True or False
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional