Share
Report
16I have 2 dropdowns in editform.
Items in Dropdown1 and Dropdown2 are - Parent.Allowedvalues.
On changing the selection of value in dropdown1, im creating a new collection called Area and want to display Area values in Dropdown2.
Things tried are below:
Onchange event of Dropdown1----------
Clear(area);
Switch(
DataCardValue24.Selected.Value,"North",
Collect(area,{_eis_area_label:"East Area"},{_eis_area_label:"Causeway Area"},{_eis_area_label:"West Area"},{_eis_area_label:"South Antrim Area"}),
"South",
Collect(area,{_eis_area_label:"North Down & Ards Area"},{_eis_area_label:"South Area"},{_eis_area_label:"South Down Area"},{_eis_area_label:"South West Area"},{_eis_area_label:"Mid Ulster"}),
"Belfast",
Collect(area,{_eis_area_label:"Lisburn & Castlereagh Area"},{_eis_area_label:"South & East Belfast Area"},{_eis_area_label:"North Belfast Area"},{_eis_area_label:"West Belfast Area"}),
Collect(area,{_eis_area_label:""})
);
UpdateContext({RegionSelected:true})
items of Dropdown2------------
If(RegionSelected=false,Parent.AllowedValues,Distinct(area,_eis_area_label))
OnVisible of editablescreen -----------
Collect(data,Meetings);
UpdateContext({RegionSelected:false})
All responses (
Answers (
