Hello All,
I have a situation I can't seem to get working right. I have an edit form that is pulling from a static excel table (table1) that I imported. I used this important rather than a sharepoint list because it contains more than 2,000 records and encountered issues with delegation when pulling options for the combobox dropdown. So now that I have a static list, delegation issues have been resovled, however, now I cannot figure out how to get a second combobox dependent on values in the first.
So in combobox1 I have the following formula
Items = Distinct(SortByColumns(Filter([@Table1], StartsWith(Part_Num, TextSearchBox1.Text)), "Part_Num"), Part_Num)
This give users a choice of part numbers to select.
Combobox2 allows users to choose a mold number. However, I only want molds listed that actually create the parts from Combobox1. So for example if a user selects Part Number 100000, and only 2/1200 molds run part number 100000 only those two mold number should appear as choices.
Currently my formula for combobox2 is as follows:
Items = Distinct(SortByColumns(Filter([@Table1], StartsWith(Mold_Num, TextSearchBox1.Text)), "Mold_Num"), Mold_Num)
For a sharepoint list I could simply append , Result = ComboBox1.Selected.Result) to this formula to get the correct filter. However, this does not seem to work on static lists. Is there a way I can modify the formula to still get my results filtered correctly?
