Returning value from datatable based on find and replace

(0) Share

Report

Posted on by BlitzenWaters

Hi all,

I'm looking for some help with searching and returning values from a data table.

%DatafromWebPage%

#	Value #1	Value #2
0	3.99	Potatoes
1	1.99	Mushrooms
2	.99	Tea

I'm then using a "Find or Replace in data table" to find "Mushrooms" which results in this.

%datatablematches%

#	Row	Column
0	1	1

Now what I'd like to do is return the value from %datafromwebpage% that match based on the %datatablematches% result. (in this case 1.99)

I'm not sure if my brains just fried from staring at this all day but I'm running into a wall with this one.

Thanks everyone.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

kinuasa 801 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
You can retrieve values from the data table based on the row numbers found by 'Find or replace in data table' action.

Regards,
kinuasa

Sample flow:

Variables.CreateNewDatatable InputTable: { ^['Value #1', 'Value #2'], [3.99, $'''Potatoes'''], [1.99, $'''Mushrooms'''], [0.99, $'''Tea'''], [1.23, $'''Mushrooms'''], [4.56, $'''Tea'''], [7.89, $'''Mushrooms'''] } DataTable=> DatafromWebPage Variables.FindOrReplaceInDataTable.FindItemInDataTableEverywhere DataTable: DatafromWebPage AllMatches: True ValueToFind: $'''Mushrooms''' MatchCase: False MatchEntireCellContents: False DataTableMatches=> DataTableMatches IF DataTableMatches.RowsCount > 0 THEN LOOP FOREACH CurrentItem IN DataTableMatches Text.ToNumber Text: CurrentItem['Row'] Number=> TextAsNumber Display.ShowMessageDialog.ShowMessage Message: DatafromWebPage[TextAsNumber]['Value #1'] Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed END END

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

If Searching for Mushrooms is returning you 1st row and 1st column then

1st row and 0th column is having the 1.99.

For clarity purposes save these as separate variables.

Set myRow as DataTableMatches[0][0]

Set myCol as DataTableMatches[0][1]

To get 1.99 your row is the same, only the column should be subtracted by 1.

So, set myCol = myCol - 1

Now myRow is 1

and mycol is 0

%DatafromWebPage[myRow][myCol]% will give you the element present on

%DatafromWebPage[1][0]%

which is 1.99

or you can refer it by its column name as %DatafromWebPage[myRow]['Value #1']%

The ones in blue are your two options.

Was this reply helpful? Yes No
catto16 56 on at

Like
a
(0)

Report
Copy link

Link copied!

U saved a lot of my time with this. Thanks a ton!

Was this reply helpful? Yes No