Disable Button if All Collections are Empty

(1) Share

Report

Posted on by Phineas

5,323 Super User 2025 Season 2

I have two Buttons.

I have six or seven Collections.

Funciton: If any of the collections has one item or more, set the button DisplayMode to 'Edit'.
If all Collections are empty set button DisplayMode to 'Disabled'.

The below isn't working. What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Disable Button if All Collections are Empty

Hey @Phineas,

Since you want that the formula respects all your arguments you should use And instead of seperating them.

You can also use the IsEmpty Formula for better performance.

If(IsEmpty(col1) And IsEmpty(col2) And IsEmpty(col3) And IsEmpty(col4) And IsEmpty(col5) And IsEmpty(col6) And IsEmpty(col7), DisplayMode.Disabled, DisplayMode.Edit )

This should work as expected.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No