Answered

No workable scenario for boolean in a droptown filter (SP Datasource)

(0) Share

Report

Posted on by martinav

3,340

I have a yes/no column in SP. All I want to do is show the "yes" items in a dropdown. Simple, yes? Well... you would think. No combination of statements yeilds a proper result.

First attempt:

1. The logical option: Filter(PDM_PDF_Post,Repost=true)

Result: I get only "no" items. No "yes", nor blank. No statement errors.

2. The sanity check: Filter(PDM_PDF_Post,Repost=false)

Result: I get only "no" items. No "yes", nor blank. No statement errors. (Same as #1... ???)

2. The secondary option: Filter(PDM_PDF_Post,Repost=1)

Result: Correct Items, but a type mismatch. Warning that it cant evaluate my formula. Despite the correct results, its against my sensibilities to leave it. (left Boolean, right Number)

Other combinations of type conversions to not work. Since there is no boolean convertion statement, that is not an option. How to resolve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

timl 36,713 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @martinav

I think this might be due to the SharePoint yes/no column type bug. There's a little bit more detail here.

https://powerusers.microsoft.com/t5/General-Discussion/Filter-using-Checkbox/m-p/200364#M64601

Could you try this to see if it works?

Filter(PDM_PDF_Post,Repost<>false)

Was this reply helpful? Yes No
martinav 3,340 on at

Like (0)

Report
Copy link

Link copied!
Well, I will say it works "better". But only that it does not give me the message of it not being able to resolve the statement, but it does say it is non-delegable. Which seems quite silly. That is still not really acceptable. I also have to throw in the blank condition. Which makes the statement more complex, which is unnecessary. Its only one item on the page, so the increased inefeciency will not be noticeable. But still, its so fundamentally wrong that you cannot make a proper statement for an =true condition.

Filter(PDM_PDF_Post,Repost<>false And Repost<>Blank())

I will likely change the SP column to text, and give up on the yes/no.

Was this reply helpful? Yes No
Verified answer

martinav 3,340 on at

Like (0)

Report
Copy link

Link copied!
Well, I shouldnt of had to do it, but I ended up making the column a text line, 16 char long, and using the text "yes" and "no". Boolean columns take less space (one bit vs 8+). I dont think this should have been necessary, but it was the only way to eliminate the delegation and type problems.

Filter(PDM_PDF_Post,Repost="yes")

Was this reply helpful? Yes No
timl 36,713 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thanks for highlighting the delegation issues @martinav. This is obviously a bug, so I hope it'll be fixed soon.

Was this reply helpful? Yes No