Read from Excel worksheet does not capture line breaks

[ALambert]

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?

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.

[Nived_Nambiar · Accepted solution]

Hi @ALambert 

You can try this approach

Assume you had string in single cell like this

Read 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 details

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

Looping 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