Answered

[HELP] Strange behaviour with filter gallery true false

(0) Share

Report

Posted on by MS_Gonzo

Hi guys,

I have noticed a strange behaviour in my PowerApp which I just can't seem to figure out. My App is connected to a sharepoint list. The list has a column for "Responsible", which is formated as text with default value "null" and one column for "active" with default value set to true.

In my App I want to filter a gallery which is linked to the sharepoint list for elements, which have as responible the value null AND which have active set to true.

Each filter for itself works fine. If I filter for active = true, I get all the elements of the list, which have active set as true.

If I filter for "Responsible" for null, I get all the elements of the list which have Responsible set to null.

However, when I try to combine conditions, i.e. set active to true AND Responible to null I get wrong results. Even weirder, If I set Resonsible to null but change the condition of active to "not equal false" it returns the correct results.

Anyone has any idea as to why this behaves that way?

Thanks in advance and all the best.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MS_Gonzo ,

Two things here - I assume you mean Blank(), not null and that you are using SharePoint. If so, Boolean (true/false) fields are only partially Delegable in that they will filter by themselves, but not (in a Delegable way) combined with another filter. One way to solve this is to replace the true/false column with a Text column and simply have "Yes" and "No" in it. I have a blog on the process to use true/false (checkbox/toggle) controls with them.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MS_Gonzo 70 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I have changed to single line text and it works.
Regarding the isblank(). I am currently not sure on the correct syntax. How do you check for a sharpoint list element to be empty? Let's say the sharepoints list is "MyList" and the column is "Responible". Is it MyList.Responsible.isblank(), or isblank(MyList.Responsible) or.....

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @MS_Gonzo ,

Depends on where you are using it - in a Filter

Filter( MyList, Responsible = Blank() )

If on a Form or in a Gallery (this would be part of a formula with the result dependant)

If( IsBlank(ThisItem.Responsible, . . . . . . )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No