Hi @Anonymous，
Could you please share a bit more about your scenario?
Do you want to get corresponding records from the Supplier Data table when you select a individual supplier from the Matrix table?
If you want to get corresponding records from the Supplier Data table when you select a individual supplier from the Matrix table, I have made a test on my side, please take a try with the following workaround:
Set the Items proeprty of the Drop down control (Dropdown1) to following:
MatrixTable /* <-- MatrixTable represents your MatrixTable */
Set the Value proeprty of the Dropdown control to VendorName.
Set the Items property of the Gallery control to following:
Filter(SupplierData, Vendor = Dropdown1.Selected.VendorNumber)
In addition, if you want to create a list of suppliers that can carry out a particular service within Supplier Data based on the selected Individual supplier, I have made a test on my side, please take a try with the following workaround:
Set the Items property of the first Drop down control (Dropdown1) to following:
MatrixTable /* <-- MatrixTable represents your MatrixTable */
Set the Value proeprty of the Dropdown control to VendorName.
Set the OnSelect proeprty and OnChange property of the first Dropdown control (Dropdown1) to following:
ClearCollect(
AllSupportedWorkTypes,
LookUp(MatrixTable, VendorNumber = Dropdown1.Selected.VendorNumber, WorkType1),
LookUp(MatrixTable, VendorNumber = Dropdown1.Selected.VendorNumber, WorkType2),
LookUp(MatrixTable, VendorNumber = Dropdown1.Selected.VendorNumber, WorkType3),
...
LookUp(MatrixTable, VendorNumber = Dropdown1.Selected.VendorNumber, WorkType40)
)
Set the Items property of the second Drop down control (Dropdown2) to following:
AllSupportedWorkTypes
Set the OnSelect proeprty of the "Add" button to following:
Patch(
SupplierData,
Defaults(SupplierData),
{
Vendor: Dropdown1.Selected.VendorNumber,
Vendor_Name: Dropdown1.Selected.VendorName,
WorkType: Dropdown2.Selected.Value,
...
}
)
More details about the Patch function, please check the following article:
Patch function
Best regards,
Kris
