cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALambert
Frequent Visitor

Read from Excel worksheet does not capture line breaks

I have some cells in excel that are themselves a list of values (product options) such as:

"

Participant rate type:Dance for PD member rate
Participation mode:I plan to use the On Demand option only
Add a donation:Just the tuition

"

(this is a single cell)

 

I need to go through each individual option and check the response. But if I read the value of the cell, and then split text on new lines, I get an array with only one item. How do I split the text of a value I read from excel based on line breaks? Is there a special character I need to use?
flow.PNG
This isn't the exact flow I'm using, but it's one I made to test the responses and it has the same behavior.

1 ACCEPTED SOLUTION

Accepted Solutions
Nived_Nambiar
Resolver II
Resolver II

Hi @ALambert 

 

You can try this approach

 

Assume you had string in single cell like this

 

Nived_Nambiar_0-1653150358946.pngRead from excel action detailsRead from excel action details

 

 

Now the steps used here

 

1. Launch the excel 

 

2. Read the cell A2 using Read from excel action

 

3. Now use the parse text to extract the required text from the cell A2 using the regular expression

 

Parse Text action detailsParse Text action details

 

 
 

 

1. Now loop through Matches variable with the following format in Power Automate Desktop
Looping through Matches variableLooping through Matches variable

 

You will get the required result as each row (as per the fig) is each line u need

 

Hope this helps

 

Thanks & Regards,

Nived N

View solution in original post

1 REPLY 1
Nived_Nambiar
Resolver II
Resolver II

Hi @ALambert 

 

You can try this approach

 

Assume you had string in single cell like this

 

Nived_Nambiar_0-1653150358946.pngRead from excel action detailsRead from excel action details

 

 

Now the steps used here

 

1. Launch the excel 

 

2. Read the cell A2 using Read from excel action

 

3. Now use the parse text to extract the required text from the cell A2 using the regular expression

 

Parse Text action detailsParse Text action details

 

 
 

 

1. Now loop through Matches variable with the following format in Power Automate Desktop
Looping through Matches variableLooping through Matches variable

 

You will get the required result as each row (as per the fig) is each line u need

 

Hope this helps

 

Thanks & Regards,

Nived N

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,418)