I require assistance with a Power Automate Desktop flow to open Excel files with same identical names located in two separate folders.

[Ahmedmuz]

Hi Everyone,

I want to create a system in Excel where the content of cell 2 in the current open Excel file is used to determine and open another Excel file with the same name from a different folder. Here's a rephrased explanation:

"I need to set up an Excel automation where the value in cell 2 of the currently open Excel file using (Get files in folders) is used to identify and open a different Excel file located in a separate folder. For example, if cell 2 in the current file contains the word 'Apple,' the system should automatically open a file with the name 'Apple_123.xlsx' from a other specified folder."

How to achieve this - Please help

[UshaJyothi20]

Hope this clarifies,

Usha.

[Ahmedmuz]

Hi Usha, 

I'm facing a challenge while attempting to open files retrieved using the 'Get Files in Folders' action and implementing a 'For Each' loop. Please refer to the attached snapshot for a clearer understanding of the situation.

File - it will open one by one - If ex its open and read in cell 2 as apple12344.xls and i want in file2 it should open any file name cantinas with Apple only not the 1st one. 

[UshaJyothi20]

use if condition inside for each

as shown  below image

 write your variable name instead of AI

Hope this clarifies

Usha

[Ahmedmuz]

"Hello Usha,

I apologize if my previous communication was unclear, but I'll attempt to explain it once more:

1. First, we use the 'Get Files in Folders' action, which opens files in a specific sequence.
2. Then, within a 'For Each Loop,' we launch Excel files based on the current item stored in 'Files.'
3. Next, we read the content of Cell A2, where, for instance, it contains the word 'Apple.'
4. Subsequently, we use 'Get Files in Folders' again, but this time, we aim to open an Excel file from a different folder path if it contains the same word as read in A2 (e.g., 'Apple1234' or 'Apple245665'). In essence, if the Excel file's name includes 'Apple,' it should be opened."

I hope this reworded explanation clarifies the process for you. please help

[UshaJyothi20]

Hi

@Ahmedmuz 

please try with this way

[UshaJyothi20]

Hi @Ahmedmuz 

please try this 

[Ahmedmuz]

Hi,

its not working - i mean not launching the excel 10 step below is the flow snap shot and in the 8 step we have to enter the secound folder path only right 

[UshaJyothi20]

In step 8 we need to give currentitem2 which we use iteration in files2

[Ahmedmuz]

given still its not launching the excel the 10 step -

[UshaJyothi20]

try this

step 9 change if condition

[Ahmedmuz]

Hi,

Same result its not opening the other excel file from other folders its not executing the step 10 only 

[UshaJyothi20]

take 7 to 12 steps out of for each and try

or do one thing just provide input folders so that I will try and solve it

Usha