Answered

Pull Text Values instead of Row and column # from Find or replace data table

(0) Share

Report

Posted on by Alanisp22

145

Hi!

I am trying to setup a flow that will narrow down each row record from a data table created by Extract data from web page, but only if the value from the 3rd column matches my specific variable. For example, I am trying to pull all the rows (with the exact text values) that have 'Suzanne Demo' listed as the values in column #3 and then insert those rows into a new data table. So for this example, I would expect to pull the row values with 'Classroom 365' and 'Classroom 35'. When I use the Find or replace in data table action, I only get the row # and column # (see picture) not the actual text values I need. Not sure if I am missing a syntax or if another action is needed.

value #1	value #2	value #3
Classroom 365	Middle School	Suzanne Demo
Classroom 333	Elementary School	Green Demo
Classroom 16	Middle School	Joe Demo
Classroom 22	High School	Miller Demo
Classroom 13	High School	Miller Demo
Classroom 35	High School	Suzanne Demo

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

Verified answer

mmonline 169 on at

Like
a
(1)

Report
Copy link

Link copied!
This should work - see caveats & notes below.

CAVEATS
I assume the value you are searching for can only be found in one of your columns (names in the 3rd column - column[2]). If they could be found in other columns but you only want those from a specific column, you would add an If %Found['Column']% = 2 and only add values to your FoundDataTable in that condition.

Also, I create variables for the values I add to the table. You don't have to necessarily. You could reference the columns directly. I recommend variables for readability and maintainability.

NOTES
I re-created your table using the first Create data table (WebData).
I create a 2nd table, FoundDataTable with 3 columns and delete row 0.
Loop through each entry in DataTableMatches - Found
We only need the Row Number from Found - stored as RowNum and convert to a number.
Refer back to your original table, WebData with the RowNum and store your column values.
Classroom = %WebData[RowNum][0]%
ClassType = %WebData[RowNum][1]%
PersonName = %WebData[RowNum][2]%
Hope that helps.
Alanisp22 145 on at

Like
a
(1)

Report
Copy link

Link copied!

This is perfect! Yay! Thank you soooo much!! 😁
mmonline 169 on at

Like
a
(1)

Report
Copy link

Link copied!

You're welcome. Glad it worked!
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

To comment a bit on the caveats part of your response, you can in fact provide a column to search the value in inside the Find or replace in data table action:
This would help make sure that the value is always matched in the relevant column only.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/