New PAD user here.
I am trying to set up a flow like this:
Main_Flow
- open excel sheet with 3 columns: App Name, App Update URL, App Version (empty column to be filled)
- Get values from columns and store them in variables AppName_Var, App_URL_Var
(Sub_flow)
- Open App_URL_Var in browser, extract version value from webpage and store it in variable App_Version_Var
(Return to Main_Flow)
- Write value of App_Version_Var in 3rd Column in excel sheet
- Go to next row in excel sheet and repeat the above process
This works fine, but I need to loop through 250 rows in the excel sheet (each representing an application), and each application requires its own method of extraction, so therefore I need an individual subflow for each.
To avoid cluttering the flow with hardcoded subflow names, I am trying to find a way to call the application specific subflows dynamically (using the AppName_Var), but I can't use variables for subflow or label names (AFAIK ?).
Is there anyone who can point me in the right direction or suggest a better way of achieving this ?
Thank you.