View My Drafts
I have a few dropdowns i would like to get to cascading and would appreciate a little help please. These dropdowns are populated from a SharePoint list.
Group(PARENT) - Items: RenameColumns(Distinct(Choices([@SPLIST].'Group'),Value),"Result", "Value")
Owner(CHILD) - Items: RenameColumns(Distinct(Choices([@SPLIST].'Group'),Value),"Result", "Value")
Name(CHILD) - Items: RenameColumns(Distinct(Choices([@SPLIST].'Group'),Value),"Result", "Value")
ive been trying to setup the FILTER but im just not sure how to do it. Any help would be appreciated. Thank you in advance