Sharepoint List Column having comma separated value; load in gallery

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-siky-msft on at

Like (0)

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

Was this reply helpful? Yes No
SivaAnanth 4 on at

Like (0)

Report

@v-siky-msft

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

Was this reply helpful? Yes No