Named Formula Filter error with SharePoint Boolean values

(0) Share

Report

Posted on by pdog763

I have a SharePoint list called "User" with a boolean field called "IsPolicyOwner". The following works on any screen within the app.

Filter(User, UserType="App" && IsPolicyOwner)

What fails is if I create a named formula and then try to filter that formula by the boolan value.

App.Formulas:

fxAppUsers = Filter(User, UserType="App")

On any screen:

Filter(fxAppUsers, IsPolicyOwner)

The result seems to remind me of the old issue querying boolean values. I can use the condition IsPolicyOwner=1 and the filter works and in the process I receive a data type warning. This was the workaround until Microsoft fixed the issue.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Pstork1 69,024 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Instead of just using the boolean have you tried using a formula?

Filter(fxAppUsers, IsPolicyOwner = true);

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
pdog763 66 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1- Yes, I did try adding a condition IsPolicyOwner=true and the result was incorrect. I can't remember if it showed all FALSE values or if it ignored it completely but I knew it was wrong because I only have a few records where the condition is true. I believe it was all FALSE records and again, this reminds me of a past issue with SharePoint boolean values that existed a long time before it was corrected a couple years back.

I'm not looking for a fix. This was just a warning to other developers, especially newer ones who did not experience the boolean issue.

Was this reply helpful? Yes No