Answered

Extracting columns from excel table

(0) Share

Report

Posted on by powerautomate49

Apologies if this is a trivial question, i am a fairly new power automate user but couldnt find a solution from extensive searching.

My problem:
My flow creates an excel file with a list of user emails. This is in the fundamental form of a table (lets call it Test123):

Attempted solution:

Using the excel "get a row", should i not therefore be able to extract the email list?

The above image has the correct location and Table set as "Table123" but what should the Key Value be? When i run it without the Key Value, the following is produced (the name shows the email as expected):

How do I extract this all the emails from the "Name" column in the "Test123" table?

I have also tried using the "contains" expression to no success.

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

Verified answer

powerautomate49 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Solution found using the approach outlined in the solution of this
https://stackoverflow.com/questions/67868270/how-to-fetch-specific-column-data-from-xls-in-microsoft-flow
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I know you solved your how, but more importantly, I think Get Row is used to find which row a value is in. So, in your example above, you enter "test@email.com" in "Key value" and it returns "3" as in Row 3 for a variable that you can use later.
azimzicar 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@MichaelAnnis
This is for Power Automate 'Cloud' not desktop, how do we report this to admins so they can move it?
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. I ran into this Friday when I tried to do it for myself. I always thought this was possible, I don’t know how a simple vlookup on DataTable type property isn’t available on the desktop version. However, there are 2 workarounds.

1. You could use PAD to write a Match formula to a cell in Excel, and then read the resulting answer. Ex. MATCH(%LookforText%,A:A,0). The match formula will display the row the exact text is found in. PAD can read this and use it to define the row needed.

2. Run a “For each” or a “Loop” on the column set and say if CurrentItem = %LookforText% then do something.

While the loop would obviously take long in large data, I opted for option 2 Friday when I only had about 8 rows, and it worked very quickly.
kbxawork 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ... in the stackoverflow solution, the definition of ColumnName is not displayed. What is meant by "assign the column name dynamically" .. thx for your patience