web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 6v5FTS3E71rxWZ+/ZQ5mJj
Power Automate - General Discussion
Unanswered

Formatting data pasted from Excel into a text box to a variable

Like (0) ShareShare
ReportReport
Posted on 5 Jun 2023 20:57:38 by 248

Hi, have a column of data from Excel however I'm having a tough time formatting it. 

 

Input:

123

456

789

 

I add the data to a variable however it ends up looking like this: "123,456,789,"

Notice quotes are missing from each batch of data and there's a comma at the very end that shouldn't be there.

Here's the formula I'm currently using: Set(abcList,Concat(Split(TextInput1.Text,""),If(IsMatch(Value,"\n"),",",Value)))

 

This is the variable output I desire: "123","456","789"  because I'm sending it over to a Power Automate flow.

 

Any ideas?

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete