Replace Text - Based on Excel Sheet

[TerryS]

Hi All,

New user of power automate.

I am writing a process that opens a text file and replaces text based on an excel sheet. Basically any text in Column A, should be replaced with text in Column B. The process does not error, but do not think it is doing anything below the For each loop.

Any guidance would be gratefully received.

Terry 

[Nived_Nambiar]

Hi @TerryS 

Did the below process is one you need to do,

you had a text file which contains column A values of excel sheet (not all values , only some). Now you need to replace the column A values in text file with the given column B values (in same row of excel sheet), this is what u need to do , right?

Regards,

Nived N

[amamidwar23]

hi @TerryS 

You're for loop seems not as you want.

Exceldata is a datable and your currentitem is a column , so iterate through each cell of your Currentitem and then use replace action 

or else Do this:- 

1)Search for each keyword in your text file, then

2)check if it is available in Column A using for loop (iterating through each cell in the column)

3)  if it is found, get the row no and then use your replace action and mention column B with row no.

PAD does not have enough excel actions to work, but you can use 4 line VBA code to achieve this. 

Thanks 

AR

Please consider marking my post as a solution! to guide others, if this helps.

[ShanKM]

Hi @TerryS ,

try in this way, this is the easiest method to implement. 

text replace

Thanks,

Shan KM

[Ahammad_Riyaz]

Hi @TerryS 

In for each u hav to mention just read excel output variable.

i think u hav to mention currentitem in foreach loop

currentitem[0] , currentitem[1]

Thanks

Ahammad Riyaz