Power Platform Community Forum Thread Details

Hello everyone,

I'm currently using Power Automate for Desktop to automate testing of a Windows application.

My goal is to capture a screenshot of the screen as evidence after each significant action or step in the test process, and then embed these screenshots into an Excel workbook. This is crucial for documenting the test execution.

Is it feasible to achieve this functionality using Power Automate for Desktop? If so, could anyone provide guidance, tips, or examples on how to:

Capture a screenshot at specific points during the desktop flow execution.
Insert these captured images into an Excel sheet.

Any advice or shared experiences would be greatly appreciated!

Thank you in advance.

Categories:

Power Automate Desktop

Hi there!

Here's one way I would approach this; goes without saying there's a handful of ways to complete this. My favorite go to, because it is easy to implement and show, if to simply add a 'take a screenshot' action at the key steps I want to see.

Inside this loop, as an example, I want to see the screen every time in step #9. So in step #7/8 I get the current time, format as yyyy-MM-dd-HHMMss and then in step #10 I take a screenshot and name file as 9-%formatteddatetime%.png.

So as I loop through this example 25 times, in my folder of choice, I am going to have 25 different screenshots.

How would I go about adding to an Excel worksheet?

I typically have a helper cloud flow with a trigger, when a new file is created (in given folder), add a row (to a table)...

I've used something similar to this format so many times, I can't even count them all but can tell you, as you can see, this is up and running in about 10 minutes.

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

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn