Sharepoint List Column having comma separated value; load in gallery

Like (0) Share

Report

Posted on 14 Jan 2020 08:14:26 by SivaAnanth

I have a Sharepoint List (Skills) with a multiline text field (SkillList) that has comma separated values. I would like to have each skill which is delimited by comma listed in a gallery.

Example of the SkillList column:-

PowerApps, PowerBI, Power Automate, Azure

Would like to have the above data listed in a gallery as below:-

PowerApps

PowerBI

Power Automate

Azure

Have tried with few formula that were available in this forum. Struggling to get it working when it comes to Split.

Tried Split(Skill.Skilllist, ",") but it does not work.

Looking for guidance here.

Categories:

General Questions

All responses (2)

Answers (1)

SivaAnanth 4 on 16 Jan 2020 at 03:32:06

Like (0)

Report

Re: Sharepoint List Column having comma separated value; load in gallery

@v-siky-msft

Thank you so much. The formula that you suggested, worked!
Verified answer

v-siky-msft on 15 Jan 2020 at 07:41:53

Like (0)

Report
Re: Sharepoint List Column having comma separated value; load in gallery

@SivaAnanth
please try this:
Clear(MyCol);ForAll(Skills.SkillList,Collect(MyCol,Split(SkillList,",")))
Sik