I've not tried this exact method myself but with a little tweaking the below should do the trick
- Set up your data source: Ensure your data is structured in a way that the second ComboBox can filter its options based on the first ComboBox’s selection. For example, if you have a table with categories and corresponding texts, it should be set up like this:
Table
Source (Choice) Category1 Category2 Category3 Category4
Category1 Text1 Text6 Text9 Text10
Category2 Text2 Text7 Text11 Text11
Category3 Text3 Text8 Text12 Text12
Category4 Text4 - - -
Text5
2. Configure ComboBox1: Set the Items property of ComboBox1 to the list of categories.
3. Configure ComboBox2: Set the Items property of ComboBox2 to filter the options based on the selection in ComboBox1. You can use the Filter function to achieve this. Here’s an example formula you could use:
Filter(YourDataSource, 'Source (Choice)' = ComboBox1.Selected.Result)
This formula will filter the data source to only show the rows where the ‘Source (Choice)’ column matches the selection in ComboBox1. Then, you can use the appropriate column for ComboBox2’s options.
