data filter cross sharepoint list

[ratanapouy]

in sharepoint, i have two lists

1. master_company which contain two columns ComCode & Company_name

2. master_project which contain project_id, Project_Description, lookup column from master_company "ComCode"

I insert dropdown list ComCode and project_id. if the ComCode select "abc" then project_id will filter: "PL" & "PL1"

if the ComCode select "xyz" then project_id filter: "TK" into dropdownlist.

Unfortunately, it doesn't work.

please help.

[Leo09]

see if this helps:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Filter-Data-Between-2-SharePoint-List/td-p/16303

[ratanapouy]

there is a message