web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

UI Element not working

(0) ShareShare
ReportReport
Posted on by 9

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.pngScreenshot 2023-11-02 110009.pngScreenshot 2023-11-02 111741.png

 

I have the same question (0)
  • Verified answer
    NathanAlvares24 Profile Picture
    1,712 Moderator on at
    Re: UI Element not working

    Hi @MosesL !

     

    You can try out the following flow:

    NathanAlvares24_2-1698909737926.png

    NathanAlvares24_3-1698909769721.png

    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.

  • MosesL Profile Picture
    9 on at
    Re: UI Element not working

    Thanks for the assistance, I just learnt how to use OCR and decided to use that instead. Have a great day ahead!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 647 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 350 Moderator

#3
developerAJ Profile Picture

developerAJ 256

Last 30 days Overall leaderboard