I have a file name, ex: "8shvytsj.xlsx". I'm using the UI "Click UI in Window" in many places to set values. Is is possible to universally change "8shvytsj.xlsx" to "MyFile.xlsx" all the "Click UI in Window" events?
Solved! Go to Solution.
If you are trying to replace text inside the code of PAD, PAD does not have a Replace function for it's own code. Example, we recently upgraded a server name from XXXXXX01 to XXXXXX02 and I couldn't just replace all everywhere in the code when referring to filenames or addresses on the server.
However, if you are trying to get all your Excel "Click UI elements" to work in a different workbook, follow below:
Open the UI pane in the top right.
Find your Excel UIs...Note how mine are "bok cost test v2.xlsx"
Hover your mouse over the window row so the 3 dots appear, click them and click Edit selectors
Again, hover the mouse to display the 3 dots, click the 3 dots and click Edit selectors again
Here, if you simply uncheck "Name", then the Excel UI elements you have will work on ALL Excel documents; you just have to make sure the one you want is in focus. If you specifically just want it to work for "MyExcel.xlsx", then change the name to match.
Best of luck!
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.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.