• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

GRISCHKE SOLUTIONS

Website and Software Development | IT | Office

  • Home
  • About
  • Services
    • Web Development & Hosting
    • IT, Networking and Cloud Solutions
    • Email and Office Solutions
    • Design Services
    • Quality Management
    • Document Management
    • Performance Dashboard
    • HR Management
    • Payroll Solutions
    • IT Support
    • GDPR
  • Blog
    • Start Jaguar Engine Remotely with Siri
    • Backup and restore IONOS DNS records using Power Automate, API, including SOA record
    • How to build an Email Parser in Microsoft Flow (Extract text from email body)
    • Windows 10 1803 new OEM (or ESP) Partition
    • Unprotect Excel Worksheets without Password
    • Data protection law is changing – you need to act now
    • Calculate Ratio Between Two Numbers
    • Charts in SharePoint
    • Microsoft SharePoint Services – What you need to know
    • Hide Featured Images in Genesis using 3 lines of code
    • Workflow loop through SharePoint list
  • Products
    • Basket
  • Enquiry

Update the Picture column in SharePoint using PowerAutomate

16th November 2021 By Maciek Grischke Leave a Comment

As of writing this post, there’s still no option to use the content of the Image column in PowerApps. The only way to get the images to show on a non-PC device is to attach an image to a list item in SharePoint and then use the URL of that attachment in the Picture column in a SharePoint list.

Why do you ask? Because if you create a picture gallery using SharePoint’s document library and open that app on an iPad or any other non-PC device, the picture won’t show. This is because the iPad is not authorised to view them, but it is authorised to access list item attachments.

I had an idea to create an app in PowerApps for the company for users to be able to view or even create galleries, to upload pictures to those galleries, but I could not get the images to work and after fiddling with various combinations, this is the solution.

Yes, you can use the old soon to be retired SharePoint Designer 2013. 2010 has already been “disabled”, 2013 will most likely follow the trend as Workflows are slowly being replaced by PowerAutomate. SPD 2013 allows you to update the Picture column, and that’s what I’ve been using thus far, but I want to move away from SPD workflows because it’s just a matter of time when Microsoft decided to disable SPD 2013 too and I want to be ready. I’ve been migrating all my old workflows to PowerAutomate for a few months now.

The app I built allows users to take a picture and assign it to a record (aka SharePoint list item). I will have another post explaining how I did that soon.

When a user takes a picture, PowerAutomate flow is triggered. In my case, I create a new item for each new picture uploaded. That’s because you can only have one URL in the Picture column. Of course, you can create multiple Picture columns if you wish. The flow then uploads the picture to that item as an attachment, takes the URL of that attachment and pastes it in the Picture URL column. The Picture column isn’t just a text column, it’s similar to a lookup column in a way you have to update both, the URL and the Description values of that Picture item.

Filed Under: Tutorials

Reader Interactions

Leave a Reply Cancel reply

You must be logged in to post a comment.

Primary Sidebar

  • Lock and Unlock your Jaguar with Siri
    By Maciek Grischke
    21st January 2023
  • Start Jaguar Engine Remotely with Siri
    By Maciek Grischke
    6th December 2022
  • Travel Mileage Claim Form in Power Apps using TomTom API
    By Maciek Grischke
    24th September 2022
  • Backup and restore IONOS DNS records using Power Automate, API, including SOA record
    By Maciek Grischke
    14th August 2022
  • Update the Picture column in SharePoint using PowerAutomate
    By Maciek Grischke
    16th November 2021
  • Home
  • About
  • Services
  • Blog
  • Products
  • Enquiry

 

Designed in-house by GRISCHKE SOLUTIONS © 2022 · Log in

Address

GRISCHKE SOLUTIONS
8 Sycamore Cottages
High Street
Pembury
TN2 4PJ

Site Info

Privacy Statement

Cookies Policy