How to cascade multiple lookups column in PowerApps for SharePoint Online add/edit form.

[manzil]

Hi

I am in situation where there is three (3) lists names and images as follows:

1. Property Name

1. Unit Number

1. Tower Lease

In Tower Lease column name PropertyName and PropertyUnit are a lookup column but cascaded, I want this to be in Cascading Dropdown parent-column will be PropetyName and Child- column will be PropertyUnit.

I am using SharePoint Online modern view and i want this in Form created in PowerApps.

[manzil · Accepted solution]

Powerapps Cascading Dropdown - YouTube

I found this its very easy and helpful.

Formula i used as suggected in this video:

Filter(Choices([@'Tower Lease'].Property_x0020_Unit),Value in Filter('Units Number',DataCardValue12.Selected.Value='Property Name Lookup'.Value).'Unit Number')

This works.