UI Flows with Excel

[patrickquarry]

I'm really interested in using UI flows to help complete a repetitive task within my company's web-based platform. 

I currently use Flow to send emails from an excel table.  Each email has an identifying ID number that matches a line item within my company's web-based platform.  I'm trying to create a flow that will go to column A Row 1, copy the ID, paste in the web program, and add a text based note to reflect that an email had been sent. 

I created a test within the Selenium IDE in the Edge browser and it worked perfectly for a single row.  But I'm having trouble creating a loop where the data moves to the next line.  If anyone else has attempted something similar, I'm interested in hearing how you completed this.

[v-alzhan-msft]

Hi @patrickquarry ,

Have you taken more try to achieve the requirement?

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[einarcardona]

Hi @patrickquarry  

Within the Selenium IDE you can define a variable ${VariableA}, representing the value that you want to paste in you web program. 

You then need to have a list of your variables, excel perhaps, created as a table.

When setting up the FLOW, it will automatically recognize that your Selenium recording requires a variable, you can then use "List items present in table" action to get the variables from the excel table. use this as input to your recording. 

this is a helpful video - https://www.youtube.com/watch?v=OJLoypP78Ak&t=960s

/E