I am trying to convert an automation built with UiPath into Power Automate Desktop. In my UiPath automation, I have a workflow called "Read_Data" that receives and reads an Excel file and outputs a data table. So my "in" argument would be a string file path, and my "out" argument would be a data table from the bot reading the Excel file. Each time I call "Read_Data," I can pass in a different file path and receive a new out argument that I can then set to a new variable.
I am trying to do the same thing in PAD (and I can ONLY use PAD - not any cloud flows), but can't figure out how to pass dynamic variables into a subflow. I understand that the variables you create in Main and in subflows can all be accessed by each other, but my issue is that I want to invoke my subflow with a different file each time, have the subflow read that file and output me a new data table that I can then assign to a variable in Main.
One solution I've seen online has been to add the files to a list and call the subflow when you iterate over the list using a "for each." This half-works for me - I can add my files to a list and iterate over them, but I get stuck when I want to assign variables to the outputted data table from the subflow.
Is this kind of scenario possible with only using PAD? This starts to get into more of the realm of OOP and I'm not sure if PAD was designed for that purpose.
Thank you!
Angela
