Is a SharePoint checkbox (yes/no) a supported field type for Get Items for SharePoint in Flow. I have tried all of the following in the Filter Query Odata Entry in Flow
checkbox eq true
checkbox eq bool(1)
checkbox eq Yes
checkbox eq yes
checkbox eq 1
checkbox eq 'Yes'
checkbox eq 'yes'
None of these work. All give the same error with multiple retries and a status of "Bad Gateway"
I CAN get a checkbox to work fine in an if statement with the syntax below if I nest an if under a get items based upon other fields within the list. So a checkbox is suppported in the If Condition
@equals(item()?['checkbox'], true)
I even tried puttting true in as a function
checkbox eq function(true)
No luck
Thx!
Hi @ skylitedave,
Does the "Checkbox" type column is the "Yes/No" type column that you mentioned?
I have made a test and the issue is confirmed on my side,
Filter Query the "Yes/No" type column is not supported in microsoft flow currently,
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Regards,
Alice Zhang
Correct - Tying to get lis items based upon a Yes No Field in SharePoint....
At least I know it is not presently supported....This is needed for many scenarios......
Follow this link to vote for this capability
Thx
Okay, I banged my head on this one for a while too... In SOME cases, Power Automate (FLOW)'s Filter Query does not recognize SharePoint's boolean field values as T/F or Y/N.... it sees them as 1/0 so the following should work:
checkbox eq '1' (for true values)
checkbox eq '0' (for false values)
I know this was a very old post, but hopefully this helps someone in the future as searches for solutions rarely return this info
I had the same issue, and this worked for me. Thanks for sharing!
THANK YOU ... saved my day 🙂
also take a look at Fusion (nocodesolution) - it might be helpful in many cases where flow just cannot do it 🙂
THANK YOU !! Your tip saved my day!
also take a look at Fusion (nocodesolution) .. it is free and it helps where flow cannot do it.
Thanks so much - this did the trick!!!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
22 | |
18 | |
17 | |
13 |
User | Count |
---|---|
125 | |
37 | |
29 | |
28 | |
26 |