Hi Guys,
I Have a piece of code that's run when the app is Onstart that collects two columns from three datasources (Sharepoint Lists) and combines them into one collection. I.e
If(
Connection.Connected,
ClearCollect(
colNames,
{Name: ""}
);
Collect(
colNames,
ShowColumns(
'Team Records',
"Name",
"EmploymentStatusType"
)
);
Collect(
colNames,
ShowColumns(
'Visitors Records',
"Name",
"EmploymentStatusType"
)
);
Collect(
colNames,
ShowColumns(
'Contract Team Records',
"Name",
"EmploymentStatusType"
)
)
)
I then have a dropdown that displays the all the names using the Distinct Function in the Items i.e
SortByColumns(Distinct(colNames, Name),"Result")
I wish to have another dropdown that Looks up the Name and Shows me the employementstatus results from the Name,
Normally i use the code (CBTeaMem is a Combobox name)
LookUp(colNames, "Name" = CBTeaMem.Selected.Name, EmploymentStatusType)
However since i have used the Distinct Code to Alphabeticallise the first Combobox i have to use Results? however i cannot get it too work with all the combinations i have tried.
Could someone help me writs the Lookup code so i can auto fill a dropdown or text label from the users previous comboboxes choice?
