Power Apps - The IsEmpty function does not work

(1) Share

Report

Posted on by LR-25101357-0

I have developed an application in Power apps and I am creating a collection from the database.
When I look in the collection, canceled columns sound empty, but the IsEmpty function does not work correctly, it gives me false, when in fact it is true.
If I replace the condition and check with "" then the check is correct.
I noticed that this IsEmpty function does not work correctly when I check for a collection.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report

Hi LR-25101357-0

That is because IsEmpty and IsBlank are two different things. IsBlank tests for a null value whereas "" is an empty string and will return true for IsEmpty, The easiest way is to use Len(YourValueHere) = 0 - a Length of zero will return true for both blank and empty elements. If it is a Table (collection or gallery), then use CountRows(YourTableHere) = 0

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

So you would have to share your code and actually share the run time value of your Collection. IsEmpty does work, but it depends on what you have in the collection.

[] would be true

but "" isn't

and so on. So when you say it doesn't work I'd be a months deserts you don't have an empty collection, at least not one that fits the definition of IsEmpty

Can you please share a picture of a text label, on the screen, with IsEmpty(CollectionName) and at the same time, you can open and look at the Collection itself and sow a picture of what it says is in it

Was this reply helpful? Yes No