Answered

Create gallery with skill set in separate fields

(0) Share

Report

Posted on by Qb00ne

Hi guys,

I am new to power automate and I am looking for a solution to create gallery or any other option with set of user skills. As data source I have SharePoint list. The case is that gallery should have currently logged in user skills in separated fields. However, all the skills are in one field (cell) separated by comma and space ( ", " ) i.e. C#, Python, Excel, Scrum, etc..

Is there anyway to achieve my goal?

Input:

User	Skills
John Doe	Power Automate, UiPath, SQL,

Output example:

Thank you in advance!

Qb00ne

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Qb00ne ,

Please try with this, set following code to Galley.Items property

Split(LookUp('SP list', User="John Doe ").Skills, ",").Result

Hope this helps.

Sik
Qb00ne 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-siky-msft this solution worked! Thank you so much 🙂
I didn't even think about splitting these items.
This is the output I've achieved. It needs some cosmetic adjustments but anyway it fit my needs.