Need Help on Passing Values from Excel Rows

Hello,

I am new to the tool and want some guidance.

  1. I have an excel column that has a list of file names.
  2. I want to use these file names one after other to perform an action (have a flow designed).
  3. Once the list of names are completed on excel column, I want the BOT to terminate.

Have tried using For Loop and I am able to get a list of all the files one after other but when I am trying to pass them for the next flow, its not working.

Any help is appreciated. Thanks!

@santosh.krishnamurthy

Welcome to community

For passing the values between flows you have to pass through arguments

Variables will not pass between flows

Hope this may helps you

Thanks

1 Like

Hi @ksrinu070184,

I tried using the arguments. I can get the desired values on message box. But when I try to pass the value to file name entity, it does not pick and comes out of the loop.

@santosh.krishnamurthy

Can you share me the your workflow or workflow screenshot where you are facing issue?

Thanks

Here is where I am getting the names of files.

The above file name has to be passed into Excel Application Scope as strFolderPath + <<out_FileName>>

@santosh.krishnamurthy

You placed in For Each Row, so the Excel Application scope is also need to inside the For Each row activity, then you can pass easily

Before passing the value to Excel Application Scope, Place a message box and pass as str_FolderPath + Out_FileName and check the value is same as the path you are expecting

Hope this helps you

Thanks

Thanks @ksrinu070184. This worked.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.