Hi all,
I'm trying to create a dropdown A that, based on the option selected in a dropdown B, displays a different item list linked to a different Sharepoint list (for every option). I tried this code for "Items" in Advanced:
Switch(Dropdown2_1.Selected.Value;
"Resources";Choices([@'GB Resources'].Role);
"External resources";Choices([@'GB External resources'].Item);
"Goods";Choices([@'GB Goods'].Item))
But only get the yellow warning and an empty dropdown with every option. Does "Choices" function not work with Switch? Or there is another proper way to do this?
Thanks for your attention and help!