Dependent Dropdown off App Formula?

[Dialect_Junk]

How do I create a dependent dropdown that’s based on a column's auto-populated App Formula?

My app has a “Tasks” table that auto-populates a [Project Number] column via app formula, like so.

Tasks Table

REF column to Work Order Table	The Project Number is auto-populated via app formula: [Work Order ID].[Project Number]
Work Order ID	Project Number	Pay Item Number	Quantity
A23780	23-001	252.00 Brick Sidewalk	125
A23780	23-001	265.00 Concrete Sidewalk	211

I want the [Pay Item Number] column to be a dependent dropdown that’s based on the auto-populated [Project Number] column.

Here’s an example of the Pay Items table.

Unique ID	Project Number	Pay Items
0CC359C0	23-001	252.00 Brick Sidewalk
47620E24	23-001	265.00 Concrete Sidewalk
8F264CAE	23-001	645.00 Catch Basin
0A729BF3	23-200	155.00 Granite Curb
96058835	23-200	345.00 Manhole
3FA49DB0	23-200	525.00 Light Pole

So, if I’m working on Project Number 23-001, only those Pay Items specific to 23-001 will be available.

I’ve tried using SELECT expressions but can’t seem to figure out how to make this work. Any and all guidance is appreciated!

[WillowMobileSys · Accepted solution]

The Valid IF of your "Pay Item Number" column would be set the expression:

SELECT(Pay Items[Pay Item Number], [Project Number] = [_THISROW].[Project Number])

[Dialect_Junk]

Thank you! Worked perfectly.