Hi all,
I'm trying to build a flow in PAD that updates 16 different excel files. The general idea of the flow is to
1) Collect input from the user regarding what period the report should be for
2) Open the first excel file and unprotect it
3) Open Power query editor and update the parameters asked for as input
4) Refresh all data
5) Protect the workbook again
6) Close the excel file
7) Open the next file and run through steps 2-6
I have managed steps 1-6. However, it seems like the UI elements cannot be re-used - new UI elements have to be created for each file since the newly opened file is considered by PAD to be a new window. It would of course be possible to capture all UI elements for all files and just repeat all actions for each file in a separate subflow. But it would be neater to loop through the steps and re-use UI-elements.
Is this possible to achieve?
Best regards,
Erik
