Check Box Visible condition tied to another tables value

(1) Share

Report

Posted on by CP-23071818-0

107

Im building an App from a powerapps Table lets call it Table_1. Modern Controls are OFF.

In Table_1 I have a column called Product.

in Data I added Table_2 as an available datasource. In this table_2 I also have a Column called Product and 4 other Yes\No columns associated with "Cavity"

in the app i dropped a container with 4 check boxes unassociated with any column in Table_1

is it possible to change the Visible property of the Check box to look for if a Yes\No column in Table_2?

I want the check box to be visible IF for Product selected in the Product field of the form has Yes (True) listed for Cavity_A column in Table_2.

Is this possible? Naturally if it is i will just repeat the process for the remaining 3 check boxes.

I tried IF(Table_2.Cavity_A = True, True, False) but that did not work.

Categories:

General Questions

All responses (2)

Answers (1)

CP-23071818-0 107 on at

Like (1)

Report

Check Box Visible condition tied to another tables value

That worked!

I actually Tweeked it to target a DataCardvalue9.SelectedText.Value and it changes live while the form is in Edit mode since the next step is to change the OnCheck and Uncheck properties to Relate and Unrelate and inevitabbly Patch information

Thank you!
Verified answer

BCBuizer 21,999 Super User 2025 Season 1 on at

Like (0)

Report
Check Box Visible condition tied to another tables value

Hi @CP-23071818-0 ,

For this you can leverage the LookUp function. Try setting the Visible property of the first checkbox to:

!IsBlank( LookUp( Table_2, Product = Gallery1.Selected.Product && Cavity_A ) )

This works under the assumption that you have a gallery (Gallery1) where users can select a product from Table_1. If your gallery has a different name, or you use another method of selecting a product, changes will need to be made to the first condition in the LookUp formula.