Hello,
I am currently pulling data from a sharepoint list and have two combo boxes. I would like to be able to have the user be able to select an option from the first combo box, and then filter the second combo box to only contain values that match the value of the first combo box. I was able to succesfully to this when the first combo box was a "Choice" data type in the sharepoint list, but I need both options to be a "single line of text' in this scenario.
This is what I currently have in the items field, and am getting an error saying "Incompatible types for comparison. These types cannot be compared: error,Text".
Filter('Projects List', ComboBox1.Selected.Value = short_description.value)
