Finding data within a data table

[audra.swope]

Hello all - using an excel file and saving the data of one entire sheet into a data table, I am now looking to extract certain data using an “if” activity (i.e., if a row contains “xyx” text AND “xyz” text then extract number in that row. I am just at the beginning of this process and this is my first time using data tables. The two things I am hung up on, so far, are:

1. in the ‘look up data table’ activity, what am I to put for “lookup value”?
2. in the ‘if’ activity, under ‘condition’ i want to select “current row” as the value and then subsequently ‘equals’ and ‘xyz’…however, when I select ‘current row’ it says “no options found” to the right of it. Does anyone know why I cannot select “current row”?
   I have added a snip of my current flow:
   
   

[ashokkarale]

@audra.swope,

Use Filter Data Table activity to filter the rows contains the desired values and then use for each row in datatable.

[Vamsi_Krishna_Gogineni (Vamsi)]

Hello @ashokkarale,

1. You need to pass ‘xyz’ (as an example) into “lookup value”.
2. Can you please check if you are able to find “.Item” method after ‘CurrentRow’? Like “CurrentRow.Item(“column name”)”.

[audra.swope]

thank you! where in this sequence would you suggest adding the ‘filter data table’?

[ashokkarale]

@audra.swope,

Replace the lookup data table

[audra.swope]

Thank you all. I was able to get the data from third-parties in a more uniform format, with cells that need to be extracted staying in a constant cell block, i was able to use the following flow: