Apologies if this is a trivial question, i am a fairly new power automate user but couldnt find a solution from extensive searching.
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):
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.
Solved! Go to Solution.
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 "email@example.com" in "Key value" and it returns "3" as in Row 3 for a variable that you can use later.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.