Hi all,
I couldn't find anything existing that answers my issue, apologies if I failed searching,
In the data source 'Document Control Data Tables' I have three columns, 'Business_Area_code' a multi value choice column, 'Business_Framework' a text column, and 'Business_Area' a text field. I want to use a textbox to enter a Business Area, then using that value, populate a dropdown items with all items from the Business_Framework that have a value in the corresponding Business_Area_code column that matches the text field.
I.e. I want to search a multi value field for a value (from the textbox), and return all the rows that have that value as the items list for a dropdown box.
I have tried,
Filter('Document Control Data Tables',Business_Area_code = txtBusiness_Area_code.Text).Business_Framework
but this only return one record
I hope that isn't confusing.
thank you in advance,
Brad