cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Separate text string to place in cells

Hi, I've searched but can't find a way to separate a text string (extracted from the body of an email in gmail) of the type "Data1;Data2;Data3;Data4;Data5;Data6" so I can put each data in a different cell in google sheets.

I would really appreciate the help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Separate text string to place in cells

Hello @arielesponda 

You can use the split function. Have a look at this thread: https://powerusers.microsoft.com/t5/Building-Flows/Split-string/td-p/140912

Hope it helps!

Ferran

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Separate text string to place in cells

Hi @arielesponda 

 

Use the split expression.

 

Split('Data1;Data2;Data3;Data4;Data5;Data6', ';')

 

This will split each values to Date1, Date2, etc.  



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Solution Sage
Solution Sage

Re: Separate text string to place in cells

Hello @arielesponda 

You can use the split function. Have a look at this thread: https://powerusers.microsoft.com/t5/Building-Flows/Split-string/td-p/140912

Hope it helps!

Ferran

View solution in original post

Highlighted
New Member

Re: Separate text string to place in cells

Excellent, I tried so many things before, but this worked, I leave the expression as I used it with the body of the gmail mail in case someone is looking for the same thing.

Reference each data with []:
split(triggerOutputs()?['body/Body'], ';')[1]

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (10,874)