Share
Report
183Hi,
I'm creating a canvas app to create new records to a table in Azure SQL DB. The app should have cascaded combo box with items coming from two tables. I'm stuck at implementing the cascaded drop down. Record has to be created in table 1.
Table 1
| Column 1 | Column 2 | Column 3 | Column 4 |
Table 2
| Header 1 | Header 2 | Header 3 |
Combo Box 1
- Data source is Table 2 : Header 1
Combo Box 2
- Data source is Table 2 : Header 2
- Should be filtered based Combo box 1 selection
Combo Box 3
- Data source is Table 2 : Header 3
- Should be filtered based Combo box 3 selection
Formula used for filtering returns no value :
Distinct(Filter(data source, field name = drop down.selected.value),field name)
Categories:
I have the same question (0)
All responses (
Answers (
