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 / Targeted bulk reductio...
Power Automate
Answered

Targeted bulk reduction of stored photos

(1) ShareShare
ReportReport
Posted on by 27

Hello all,

 

Just trying to sound out whether it's possible to do this with PAD.

 

We have a drive that has individual project folders, and some of them contain large caches of photos.  I've been seeking out the folders that have the largest (bytes) photo cache from a year or more ago, and then reducing the photos.  I was able to make a targeted list using Excel Power Query.

 

The simplest tool I found to reduce the photo resolution is an obsolete tool, Microsoft Office Picture Manager (2010).  It works a treat for selecting all photos in a given folder, and also cropping all said photos to a uniform size.   

 

What I've been manually doing is clicking on the hyperlink in Excel which opens the photo folder in File Explorer, then selecting one photo, right-clicking, choosing "Open with" Picture Manager 2010, then when that program launches, selecting all photos in the folder (click to load all photos, then Control+A to select all), then Edit Pictures, then the Compress Pictures button, then setting the resolution, then OK, waiting for that to process, then hitting save to overwrite all the photos, then closing.  Finally, back to Excel where I delete the row just completed, and on to the next hyperlink.

 

I've really only used PAD with web pages and gathering info, and writing to Excel.  Is it possible to incorporate not only Excel but this Picture Manager program to automate this process?  I saw somewhere else that it was suggested the only way to bulk-reduce photos was to use full Power Automate and run a cloud flow through another app.  I'm never going to talk my boss into all that.

 

I have the same question (0)
  • Verified answer
    mathiaskjeldsen Profile Picture
    224 on at

    Hey

     

    This is more than doable in Power Automate Desktop. Utilize Loop actions, and then inside each loop actions perform the tasks of right clicking on link, waiting for program to open, send keys to mark all photos (CTRL + a), use click actions or send keys (don't know if latter is possible) to compress the photos, save the changes and then delete the row in Excel - and then loop back up from the top and do it again. 

     

    ---

    If this has helped solve your problem, please mark it as Solution. 


    Connect with me on social platforms by using the links below.

    LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/
    YouTube: https://www.youtube.com/@matkjeldsen 

     

  • kilroyscarnival Profile Picture
    27 on at

    Thanks!  This at least tells me it's worthwhile to proceed.  I just have to learn some steps. 🙂

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 167

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard