Unanswered

Visible fields Based on another field

(0) Share

Report

Posted on by RJF61

1,265

I am developing a Power App to perform room inspections. We currently have (4) Zones (A, B, C & D); but, "D" (ZONED) is the only one with Kitchens. There are (137) records with a ZONEA, ZONE,B, ZONEC or ZONED. (37) of those records are ZONED. When a User enters a Building (which is a Lookup from another List) my plan was to set the Visible properties to 'false' for the items in the red box below if the Building was from ZONEA, ZONEB or ZONEC.

Can this occur prior to saving the record?
Is a better method to make fields visible using "IF" statements for the Building name versus the Building Zone?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

What you can do is, When editing App, while holding control button -> select each control within red box, or if you have all these controls sitting inside a container.
Then add this code to Visible property to the control

If( Dropdown.Selected.Name = "ZONEA" || Dropdown.Selected.Name = "ZONEB" || Dropdown.Selected.Name = "ZONEC", false, true )

Hope this helps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ethan_R Thanks for the response. So I currently have a Lookup field for the Building from the pic above and I'm also showing the Zone; however, the Zone only populates after the record is saved. I need the Zone to populate so that the visible function hides the fields (prior to data entry).

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RJF61 ,

Are you using Form?
If yes, you can add the following code in Visible property for Kitchen controls
If( ( Dropdown.Selected.Name = "ZONEA" || Dropdown.Selected.Name = "ZONEB" || Dropdown.Selected.Name = "ZONEC" ) && Form1.Mode = FormMode.New, false, true )

Hope this helps

Was this reply helpful? Yes No
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ethan_R I don't think I'm getting my issue explained properly. Following is a pic of the Form as it is being completed. When a Building "SMTH" is entered, the Zone column (ZONEA in this case) needs to populate immediately so that that the Visible action can occur. The Zone does not fill until the record is saved (which would not occur until after all inspection items are reviewed). Does this make sense?

Was this reply helpful? Yes No