web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Add quotes to comma se...

Power Apps

Unanswered

Add quotes to comma separated Collection column

(0) Share

Report

Report

Posted on by pcgriffiths Microsoft Employee

I'm importing to a collection from an excel table.

Text Column: Tags

Format in excel: tag1, tag2, tag3, tag4

Needs to be: "tag1", "tag2", "tag3","tag4"

I've tried split and concatenating but can't get it to work! How do I transform that column (or add a new column) during the import?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@pcgriffiths

This would be the basic function to do this. You'd substitute the hardcoded "tag1, tag2, tag3, tag4" value with a reference to your input field.

With({valConcat:Concat(Split("tag1, tag2, tag3, tag4", ","), """" & Result & """,")}, Mid(valConcat, 1, Len(valConcat)-1) )

Was this reply helpful? Yes No
pcgriffiths Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you - and how would I build that into the Collection?

Was this reply helpful? Yes No

Join the conversation