Clear(deptCollection);Clear(sectionMapping);
ClearCollect(deptCollection,["Architects","Community and Cultural Development","Corporate Services","Finance & Water Services","Forward Planning Infrastructure","Infrastructure & Climate Change","Planning"]);
ClearCollect(sectionMapping,{Department: "Architects", Section: "a1"},{Department: "Architects", Section: "a3"},{Department: "Architects", Section: "a4"},{Department: "Community and Cultural Development", Section: "a2"},{Department: "Community and Cultural Development", Section: "a5"},{Department: "Corporate Services", Section: "a6"},{Department: "Corporate Services", Section: "a7"},{Department: "Corporate Services", Section: "a8"},{Department: "Finance & Water Services", Section: "a9"},{Department: "Finance & Water Services", Section: "a11"},{Department: "Forward Planning Infrastructure", Section: "a12"},{Department: "Infrastructure & Climate Change", Section: "a14"},{Department: "Planning", Section: "a15"});
deptCollection
Filter(sectionMapping, Department = DataCardValue2.Selected.Value).Section
DataCardValue6.Selected
ClearCollect(sectionMapping,
{Department: "Architects", Section: Choices([@'Department and Section'].'Section')},
{Department: "Community and Cultural Development", Section: Choices([@'Department and Section'].'Section')},
{Department: "Corporate Services", Section: Choices([@'Department and Section'].'Section')},
{Department: "Finance & Water Services", Section: Choices([@'Department and Section'].'Section')},
{Department: "Forward Planning Infrastructure", Section: Choices([@'Department and Section'].'Section')},
{Department: "Infrastructure & Climate Change", Section: Choices([@'Department and Section'].'Section')},
{Department: "Planning", Section: Choices([@'Department and Section'].'Section')}
);
{Department: "Architects", Section: LookUp(Choices('Section (Department & Sections)'), Value ="a1").Value},
{ Department: "Architects", Section: 'Section (Department & Sections)'.a1 }
{Department: "Architects", Section: LookUp(Choices('Section (Department & Sections)'.a1), Text(Value) = "a1")}
Hello, try putting the update in this format.