Unanswered

Replace Multiple Values in Excel Based on List of Input Values

(0) Share

Report

Posted on by UiPath

I want to open an excel file go to second sheet use the txt or .xlsx file to find specific values in Column A rows and replace the value in the Column L row.

e.g I find the Number1 in the excel file from a list of input values and replace the value in column L in that row with custom text that is in the input file. Then I will look for Number2 and replace the value with custom text in input file, after all numbers are replaced in the sheet switch to sheet1 save and close the excel.

Excel File:

txt.File

Is it possible to do that with Power Automate Desktop?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (0)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes, use this action to get your row index where your "Number1" value exists, and then you can then use the other Excel actions to update values using that row index and the columns you want to update

Was this reply helpful? Yes No
UiPath 16 on at

Like (0)

Report
Copy link

Link copied!

How to switch between sheets?

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
UiPath 16 on at

Like (0)

Report
Copy link

Link copied!

I started to create the flow.
First step is to open excel files in a folder. I created an input variable %ExcelFilesFolder% that opens a .txt file. The txt file has list of excel files path. e.g C:\5 Sep 2022\Testing\From\names of excel.xlsx
I refereed the variable in Launch excel.
But, It opens the .txt file list in excel rather than opening each individual excel file.
Should I create a For Loop?
Step 1
Step 2

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I'm not really following your question. But if you are saying that you have a list of Excel files in a text file, yes, the Launch Excel action can open a tab delimited text file, you can then Read from Excel for that new Excel instance, and then use that output to get started.

Was this reply helpful? Yes No
UiPath 16 on at

Like (0)

Report
Copy link

Link copied!

I mean this now it opens each excel file. Now I get to the hard part of find and replace.

I don't see find and replace in my desktop

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You have to expand the "Advanced" section

Was this reply helpful? Yes No
UiPath 16 on at

Like (0)

Report
Copy link

Link copied!

I found it now.
I managed to replace by entering single number to Text to Find then followed by write action.
I am stuck at Find and Replace >> Text to Find
In my case, I have input as a list of values and associated new text.
I need to check one value at a time, if excel value has a match with the values in input file. I would replace the text in column L with new text that is specific to that number. I do that for all the numbers in the excel agaist my input list finally save and close.
How to I refer my input file that has list of values and associated new text.
Do I need to loop through the input file?

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yep, loop through it.
If your input file is two columns (one with the value you are searching for and the other the value you are going to write), you'd use %CurrentItem[0]% as the value to search for in Excel, and then %CurrentItem[1]% in your write action

Was this reply helpful? Yes No
UiPath 16 on at

Like (0)

Report
Copy link

Link copied!

I created an input list variable with default value as C:\path\files.txt it won't accept. Input variable has to be List or Object or Data table. Actually, I want the input files to be an excel file because replace text has line breaks after each line.

This is my flow so far. Excel file would be my input file.

Was this reply helpful? Yes No