How to update a value from a cell in an excel file to another excel file for the given column name
Hi @Premkumar_Ganesan , welcome to the forums!
You can use two Excel Workbook scopes contained within one another.
Excel Scope OneFile.xlsx
Read Cell Data from cell in this Excel scope
Excel Scope AnotherFile.xlsx
Write Cell data to cell in this Excel scope
I hope this helps. The flow would resemble something like this in it’s basic form:
There may be other solutions, this is a start.