Answered

Show/Hide button on multiple conditions

(0) Share

Report

Posted on by lejo_69

Hi. I am strugling a bit with a function that probably have an obvious solution.

I have a Gallery with 5 txt fields. The gallery is filtered via a dropdown menu. I want a button to be visible when all 5 txt fields is either blank or better yet have numeric values. I Get that to work on one row in the Gallery but not for all rows displayed in the Gallery when filtered via my dropdown menu

On button Visible:

This works for one row, but not for all: If(!IsBlank(Txt_Nivå.Text);true;false) When i include If(Gallery_Målinger.Allitems;!IsBlank(Txt_Nivå.Text);true;false) it fails.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@lejo_69

The reason it fails is that a single value can be blank. Since the items of a gallery will be a table, IsEmpty() is the appropriate function for evaluating a table.

!IsEmpty(formulafor filtering gallery here)

There is no need for an If() in the visible property of your button since the formula will reduce to either true or false.

Was this reply helpful? Yes No
lejo_69 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, but i must still doing something wrong. I did not get the !IsEmty correct. In the below picture i have used the following formula: !IsBlank(Txt_Nivå.Text) && !IsBlank(Txt_Temperatur.Text) && !IsBlank(Txt_pH.Text) && !IsBlank(Txt_O2.Text) && !IsBlank(Txt_Ledn.Text) && !IsBlank(Txt_Eh.Text)

It works but not correct. As you see from the picture. The green button will show when all 6 fields in the 1st row of the gallery has a number. What i am looking for is that the button shall be visibel only when all 6 fields in all rows have a number, The gallery is filtered by the drop down with this: Filter(
Feltmålinger;
DD_Velgrunde.Selected.Value = Blank() Or Runde = DD_Velgrunde.Selected.Value
)

Was this reply helpful? Yes No
Verified answer

lejo_69 79 on at

Like
a
(0)

Report
Copy link

Link copied!

So, i finally found a solution that works.

CountRows(Gallery_Målinger.AllItems) && !IsBlank(Txt_Nivå.Text) && !IsBlank(Txt_Temperatur.Text) && !IsBlank(Txt_pH.Text) && !IsBlank(Txt_O2.Text) && !IsBlank(Txt_Ledn.Text) && !IsBlank(Txt_Eh.Text)

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lejo_69 ,

Glad that you have solved your issue!

I will mark your replay as a solution so that other community members who stuck with the same question can directly see your solution.
Best regards,

Allen

Was this reply helpful? Yes No