Power Platform Community Forum Thread Details

Canvas App

Fully Individual Text Inputs & Labels (no galleries)

Google Sheets

There are 3 separate tables. All have a header row, and all have the very first column set to DB_ID to be used to filter between two rows.

We use a Dropdown on every page to choose which of the 2 rows to be working from.

For example, here is a Label Text - 'Master Dropdown_40'.Selected.Ninja_Turtles

Here the Ninja Turtles column is chosen based on which row was chosen in 'Master Dropdown_40'

I now must write be able to reference the other tables and make Label formulas that Filter/Lookup which row in Table 2 matches the DB_ID in Table 1.

Categories:

Filter Rows in multiple tables using one Dropdown