Display Image from SharePoint List Column - Best Practice?

(0) Share

Report

Posted on by mick_swartz

184

Hey All,

I'm creating a training application which will be managed by a SharePoint list. On that list, there will be rich text, an image, and a video URL. I've got the rich text and video working fine...the image is...annoying to say the least. What I'm finding is that to be able to display the image, it has to be the text URI format, can't be the basic Image column type from the list.

So, assuming that's the case, the process I'm seeing is as follows:

1. Have business user upload image to SharePoint library.

2. Have a flow create the URI version of the image, and add that to another column in the SharePoint library.

3. Have business user copy that URI to the SharePoint List which contains the content, paste that into multi line text column.

4. Display Image control in PowerApp which reads that URI.

Is that really the best way to do this? I struggle expecting the business user to wait for a flow to kick off to get the URI and have them manually copy and paste that into the list. Am I missing something?

Thanks for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

natecentric 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you do a LookUp column in the Sharepoint Library for the image to the Item in the Sharepoint List? Then you have options there for the Image control, like using the image link, thumbnail, etc. No Flows, no copy and pasting. There maybe some delegation constrains when filtering the Library to get the right image in your control and some fun with formulas, but creating that relationship in SP and leveraging Lookup/Filter formulas seems like a better option.

Was this reply helpful? Yes No
mick_swartz 184 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm. That'd still be a reference that the business user would have to create though too I think, right?

I've also read that SharePoint links only work with the online version of PowerApps - this will be a 90% mobile/tablet used app.

Was this reply helpful? Yes No
natecentric 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that reference would need to be established. but steps for user would be: 1. Upload image to library, 2. once uploaded to library, then edit that library item and select the referenced SP list item.

As for the option on mobile, I would try to get the thumbnail for the image then. Here is a good reference: https://powerusers.microsoft.com/t5/Building-Power-Apps/Get-image-from-Sharepoint-list-or-library-and-show-the-picture/td-p/471561

There is a mention in that reference of doing this with attachments on a SharePoint List Item, but I have never used that method. This would get rid of the steps mentioned above and simplify it if it works.

Was this reply helpful? Yes No
Verified answer

mick_swartz 184 on at

Like
a
(0)

Report
Copy link

Link copied!

Just figured out with a flow I can just have them attach the image to the list item, convert to URI, and add the URI into the column with a flow.

So...still needs a flow which is just one more point of failure, but this way it doesn't require the business user to do anything besides attach the picture to the list item which is what they would expect. Flow is below. Need to limit the attachments to 1 as well, but that can be managed.

Thanks for the input!

Was this reply helpful? Yes No
ganeshsanap 1,555 on at

Like
a
(1)

Report
Copy link

Link copied!

@mick_swartz You can now also use the Image column type in SharePoint online as Power apps will soon support the image column type from SharePoint Online/Microsoft Lists.

Check more information in this article: Power Apps can now display images from SharePoint Online/Microsoft Lists

Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Was this reply helpful? Yes No
mick_swartz 184 on at

Like
a
(1)

Report
Copy link

Link copied!

That is awesome news! Thank you for pointing that out.

Was this reply helpful? Yes No