Hi Guys,
I am using "Attach to running Excel" action to navigate through running excel instance,
but the document name is dynamic(Output.xls, Output(1).xls, Output(2).xls....).
Please help me into this how to handle dynamic document name.
I have something similar. First, change Output.xlsx to Output(0).xlsx; you can do that with Rename File.
Next, run your process through a loop to do whatever you need. The loop should start at 0, increment by 1. In the file name of attach to Excel, replace the number with %LoopIndex%.
For dynamic windows UI elements, after you have captured an Excel UI, edit the selectors, go to Name, change to “contains” and change the text to just “Output”; therefore, all the UI connectors will work for any workbook with the title containing Output.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.