Answered

Change Visibility of a button based on mulitple fields being blank

(0) Share

Report

Posted on by golfnutt82

1,362

I have tried a coulple different ways to hide the Icon/button that launches/submits the patch but without success.
What am I missing?

Formula #1: If(IsEmpty(txtPurchaseFrom.Text) || IsEmpty(txtAddress.Text) || IsEmpty(txtCity.Text) || IsEmpty(txtProjectNumber.Text) || IsEmpty(txtTaskNumber.Text),false,true) && gblAction = "edit" || gblAction = "new"

Formula #2: f(!IsEmpty(txtPurchaseFrom.Text) || !IsEmpty(txtAddress.Text) || !IsEmpty(txtCity.Text) || !IsEmpty(txtProjectNumber.Text) || !IsEmpty(txtTaskNumber.Text),false,true) && gblAction = "edit" || gblAction = "new"

Formula #3: If(!IsBlank(txtPurchaseFrom.Text) || !IsBlank(txtAddress.Text) || !IsBlank(txtCity.Text) || !IsBlank(txtProjectNumber.Text) || !IsBlank(txtTaskNumber.Text),false,true) && gblAction = "edit" || gblAction = "new"

Formula #4: If(And(!IsBlank(txtPurchaseFrom.Text), !IsBlank(txtAddress.Text), !IsBlank(txtCity.Text), !IsBlank(txtProjectNumber.Text), !IsBlank(txtTaskNumber.Text)),false,true) && gblAction = "edit" || gblAction = "new"

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @golfnutt82,

It would be great if you could also explain your requirement? Do you want to hide the icon/button unless all fields are filled in and the hblAction is 'edit' or 'new'?

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like (0)

Report
Copy link

Link copied!

Yes, as I said, I want to hide the icon if any of the fields mentioned in the formula isEmpty.
I have tried many different ways and none are working.

Here is some more context.
The variable gblAction is set on from the App "OnStart" property.

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (1)

Report
Copy link

Link copied!
@golfnutt82 wrote:
Yes, as I said, I want to hide the icon if any of the fields mentioned in the formula isEmpty.
No, you did not.
If( !IsBlank(txtPurchaseFrom.Text) And !IsBlank(txtAddress.Text) And !IsBlank(txtCity.Text) And !IsBlank(txtProjectNumber.Text) And (gblAction = "edit" Or gblAction = "new"), true, false )

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@golfnutt82

IsEmpty() refers to tables, IsBlank() refers to a single record or Value. You never need If() when using the visible property as the formula you use reduces to true or false by itself. ie.

Or(!IsBlank(txtPurchaseFrom.Text), !IsBlank(txtAddress.Text), !IsBlank(txtCity.Text), !IsBlank(txtProjectNumber.Text),, !IsBlank(txtTaskNumber.Text) ) && gblAction = "edit" || gblAction = "new"

Is either true or false

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like (1)

Report
Copy link

Link copied!

I apologize I wasnt more clear.
This worked so thanks for your time.

Was this reply helpful? Yes No