Approving Photos for a SharePoint Document Library with a Flow

Approving Photos for a SharePoint Document Library with a Flow

Use case of the week: Provide an easy way for attendees at a company function to upload photos snapped at the event for storage in a SharePoint Document Library (SPDL). Also, the images should be approved before they are added to the SPDL. If approved, additional information should be added to a custom column, Description of the image.

The solution includes a Microsoft Form and a Power Automate Flow. Here's a screenshot of the Flow steps.

Approve Images for SP Doc Library

Keep in mind, that generally, MS Form responses are stored on the "run as person's" One Drive (/Apps/Microsoft Forms/[your-form_name]/Question). With that fact in mind, a List files in folder action creates an Apply to each loop, whereas a Get file content action allows the next step, Start and wait for an approval to display the Name and the File Content in the email the approver(s) receive. Being inside the loop, each Start and wait for an approval queues up one after the other. If that's a problem, one can introduce a Child Flow that handles each photo approval asynchronously. A Condition action is applied. If a photo is approved, the SharePoint Create File action is called, then the Get file properties, the Update file properties, and finally, the One Drive for Business Delete file action is run. The One Drive for Business Delete file action is applied if a photo is rejected. Why delete the photos in the One Drive folder? The why is once the photos are processed, they are no longer needed. Leaving the photos would cause them to be picked back up the next time the Flow is triggered during the List files in folder action.


要查看或添加评论,请登录

Mike Givens的更多文章

  • Fun with the Barcode Reader in a Power App

    Fun with the Barcode Reader in a Power App

    A colleague at work asked me the other day if I ever worked with barcode scanning with the Microsoft Power Platform…

  • Leveraging JavaScript in a Power Platform Model-Driven App (MDA)

    Leveraging JavaScript in a Power Platform Model-Driven App (MDA)

    An interesting question popped up today on a Team's channel. Is it possible to do the following.

  • Let Python Make You a Winner

    Let Python Make You a Winner

    A few years ago, two colleagues at HP joked about their ongoing struggle to pick numbers for the Powerball lottery…

  • Eden AI - Try it, and you will love it.

    Eden AI - Try it, and you will love it.

    I have found Eden AI extremely useful in my daily automation tasks. As of January 17, 2025, I counted 60 different…

  • Windows Toast Reminder to Drive the Car

    Windows Toast Reminder to Drive the Car

    Heads-down work or coding might occasionally need a reminder to do something important, like picking your child up from…

  • Converting Videos to GIFs with Python

    Converting Videos to GIFs with Python

    Have you ever wanted to take that best video clip of yours and loop it into a GIF? Whether making a meme, a tutorial or…

  • Story Time with Python and OpenAI

    Story Time with Python and OpenAI

    As a part-time writer and a full-time automation explorer, an idea popped up this evening. I realized that by…

  • Happy Holidays with PIL

    Happy Holidays with PIL

    Using the Python Image Library (PIL) to create a "happy holidays" email blast to your colleagues, friends, and family…

  • Christmas Tree with Python Turtle Graphics

    Christmas Tree with Python Turtle Graphics

    Happy Holiday Season. As promised this is the follow-up to my Thanksgiving Turkey.

  • Image Fun with the Python Imaging Library (PIL)

    Image Fun with the Python Imaging Library (PIL)

    The following code allows one to upload any image file, and the Python Pillow Library (PIL) transforms the original…

社区洞察

其他会员也浏览了