Hello!
I have a Sharepoint List called Projects with a multi-select & fill-in enabled column named ProjectCategories
Sample Data:
| ID | Title | ProjectCategories |
| 1 | ProjectA | Cat1,Cat2,Cat3 |
| 2 | ProjectB | Cat2,Cat3 |
| 3 | ProjectC | Cat1,Cat5 |
I'm trying to populate a combobox with all the previously used ProjectCategories values but no matter how I format the ClearCollect, I get syntax errors - mostly invalid argument type (table) expected text because the ProjectCategories column seems to be classed as a table at the record level. I even tried:
ClearCollect(
collProjectCategories,
Concatenate(Projects.ProjectCategories, ", ")
);
and tried to stick it in a ForAll but no luck.
Does anyone know how to get around this? I just need to create a collection that would result in the above data looking like:
| ProjectCategories |
| Cat1 |
| Cat2 |
| Cat3 |
| Cat5 |
(I realize there will be a Distinct needed in here - but I'll worry about that once the Collection part is figured out!)
Any guidance would be great appreciated, thanks!
