Power Platform Community Forum Thread Details

Hi there, I am currently working on a flow where I will open multiple excel and amending columns in there, however the excel comes in protected view. I am trying to use UI Element to click my way to make the sheet "unprotected". The issue I am facing is that the UI Element does not work on the excel file it opens. I took the elements from a new Excel sheet, hence it is Book2. I tried editing the element to look for "CurrentItem" as the name of the Excel book but it is still not able to work. The error is "Failed to get window".

Any assistance is appreciated.

Screenshot 2023-11-02 105936.png Screenshot 2023-11-02 110009.png Screenshot 2023-11-02 111741.png

Categories:

Using flows

Hi @MosesL !

You can try out the following flow:

So here I set the excel instance to be maximized and focused in the foreground. Instead of "Click UI element in Window" action, use the "Send mouse click" action. Since the "Review" tab, "Protect/Unprotect Sheet" button and the pop ups are fixed.

Error handling set to continue flow and "Go to next action".

This works fine on my end. Please do let me know if any error still persists. Hope this helps.

Regards,

Nathan Alvares

----------------------------------------------------------------------------------------------------------------------------------------

If this helps & solves your problem, please remember to give a "Thumbs up" and "Accept my solution" as it will help others in the future.