How to print excel datatable value from a column with line break?

(0) Share

Report

Posted on by bradt30h

134

Hi Community,

I would like to print value ABC from the column with linebreak in Excel as per the image below. Understand that it can be done using %RPData[0][0]% to get "ABC". But, I would like to call out using Column name instead, to avoid error if col is moved. I tried with %RPData[0]['TEST1TEST2']% or %RPData[0]['TEST1 TEST2']% but fail.

Any ideas on how to call out columns with line breaks?

Appreciate it very much!

Categories:

Power Automate Desktop

All responses (6)

Answers (2)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What if you replace text in the datatable and get rid of the column line break?
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bradt30h ,

Here is a working way to do that..

Read the Column Heading in a variable
In this case the variable is MyColumnHeading.
You can give a name similar to your Excel column headings.
Also you can use a loop if you want to read all headings.

Then use that column heading variable to get its value.
Below is an example to display the 1st item (actually 2nd) from the data table.
You can use the same inside a loop too.

Here is the output after running the flow at line number 5.

Below is how the overall flow looks like
bradt30h 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Great one VJR,

But when reading, can it be dynamic? Now we are hardcoding the column cell. I am worried if the column is moved. So, I use Read from all available values from the worksheet.
Verified answer

bradt30h 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey VJR, I manage to do the alternative, I use "Find and Replace" function to replace the column name (with line break) with column (without line break). See the image below.
With this method, I can assure that even the column is moved, it will still work 🙂. Nevertheless, thanks so much for your help!
bradt30h 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Michael,

I didn't see your post earlier. Yes, replacing works! Thanks so much for your input 🙂
VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay @bradt30h , no worries 🙂. Since the original post said only about "how to call out columns with line breaks" therefore I didn't share any information considering you needed anything as flexible as moving columns.

1. Some recipients do not like replacing column headings. They need it as they are in the original file.
2. Using wild card as TEXT1* has the potential to replace any other column heading or also any other text in the entire file that matches this criteria (if All matches is selected).
3. If "only the first match" option is selected, this would not work if you want to skip the first match and replace only the second or the third.
For ex;
If you want to replace only the second column then using Name* wont work with the screenshot you have shared.

Again not sure how much flexibility you are looking for, but I'm sure you are okay with these above caveats and therefore you have gone ahead and implemented this approach.
Good to know you have found a solution to what you were looking for 👍.