Hi there!
I have a DropDown control and a Data Table. I want to Filter the Data table with the value selected on my Dropdown (from a SharePoint list).
It is working well like this :
Dropdown Items = ProjectMasterList
Data table Items = Filter('Purchase Requests Follow-up',Project_x0020_Code = Dropdown2.Selected.Title)
I want my Dropdown to be sorted by alphabetic value on a specific field. This work well with the formula :
Dropdown Items = SortByColumns(ProjectMasterList.Project_x0020_Name,"Project_x0020_Name")
But if I do that, the Data table formula doesn't work anymore, and I don't understand why! I've tried different things but I'm missing something...
Any clues?
Thank you!
