You’re offline. This is a read only version of the page.
51
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!
you are a wizard 🙂 thank you @v-mengmli-msft this worked perfectly!
Hi @ImaKickUrAsh ,
Please try this:
Share
Report
All responses (
Answers (
ClearCollect(collProjectCategories,Distinct(Ungroup(Projects,"ProjectCategories").Value,Value))
Best regards,
Rimmon Li
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
