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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Capturing alert messag...
Power Automate
Unanswered

Capturing alert message in excel using Power Automate Desktop

(0) ShareShare
ReportReport
Posted on by 2

I am trying to automate a scenario using Power Automate Desktop where we are opening an excel file run some macro and capture Success Alert or Error if any. I am not able to get the alert message text from the popup in excel file. Any help or pointers will be hugely appreciated

I have the same question (0)
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    I have only been able to use image recognition to capture those message.

  • sobhanbanerjee Profile Picture
    2 on at

    I have tried OCR but somehow its doesn't work, are you referring to the same , if not could you please elaborate how did you implement it to capture alert text in excel? Thanks

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    You only have two options, right?

     

    So, if you are running it on the same computer each time, you can image recognize each possible popup image and direct PAD based off that.  To be honest, I would remove the popup dialogue box and put Success/Error in a cell in the workbook to read from after, but assuming you don't have the permission to do that:

     

    Note:  the PAD action "Run Macro" will not work for this if the dialogue box is in the Macro.  It won't be able to get out of the macro.  You have to run the Macro manually with 'Send Keys {Alt}()wmv', [macro name], and {Enter}.

     

    Loop

        If %SuccessImage% exists

            Exit Loop (will continue the process)

        EndIf

        If %ErrorImage% exists

            Run Subflow ErrorFlow  (create a subflow to manage your error)

        EndIf

        Wait 10 (seconds) (or whatever interval is appropriate for waiting for your macro to be done)

    End Loop

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 419

#2
Vish WR Profile Picture

Vish WR 314

#3
David_MA Profile Picture

David_MA 260 Super User 2026 Season 1

Last 30 days Overall leaderboard