Hi all,
I'm new to PAD and I am having trouble opening Excel files that contain external links (that need to be updated) or when other warning message are prompting user's to click a box at the launch of Excel such as the following (when using "Launch Excel action"):
I tried:
1. to include a subflow ("SB1") that would wait for the pop-up and click on EI element to answer for me, but the issue is that the I never get pass the "Launch Excel function" (the flow get stuck at this function/action until I click manually to chose to update or click continue so I never get to execute SB1). I also tried to run SB1 "on error" of Launch Excel, but that does not seem to resume the Launch Excel Function (or at lease does not create an "excel instance").
2. I also tried to implement the solution suggested under this post:
Solved: Opening Excel with External Links - Power Platform Community
Again, I'm fairly new to this and I tried to copy and past @rolign's script into "Run PowerShell script" changing the filepath the mine (i.e. one pre-defined previously in my flow as a flow variable) , but all it does is open excel and close it (the file does not appear to even open). My issue might be that his instructions says to "afterwards attach to the instance and continue with the steps", but frankly I don't know how to do this. The Run PowerShell script does allow me to produce a variable, but this variable does not seem to be an "excel instance" (i.e. I'm not able to continue to interact with it using other excel actions (such as Set Active Excel Worksheet or "read from excel worksheet") - which I have disabled in the screen shot below). Any idea how to implement this script and create an excel instance out of it to run other excel actions?
It is noteworthy that I also tried to disable automatic link updates in Excel app and disallowing updates via Trust Center, but this will not solve my issue.
Any ideas what I'm doing wrong or other ways to avoid these popups, close them automatically or disable them completely?
Many thanks!
