Unanswered

Power Apps not displaying images from SharePoint/OneDrive links in Excel

Like (1) Share

Report

Posted on 4 Oct 2024 10:42:36 by CU04101039-0

I've stored my image files in Microsoft SharePoint and OneDrive, but when I try to display them in Power Apps, the images don't show up. I've tried copying the image URLs and pasting them into an Excel file as my data source in Power Apps, but it doesn't work.
Why can't Power Apps display images stored in SharePoint or OneDrive directly, even though the files are already hosted on Microsoft services? I've checked and made sure the sharing settings are set to "Anyone with the link." Is there a way to create a direct image link that works with Power Apps, or do I need to store the images somewhere else?

Categories:

Connecting to Data

All responses (3)

Answers (0)

WarrenBelz 146,792 Most Valuable Professional on 19 Oct 2024 at 01:18:26

Like (0)

Report

Power Apps not displaying images from SharePoint/OneDrive links in Excel

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
WarrenBelz 146,792 Most Valuable Professional on 04 Oct 2024 at 22:02:36

Like (0)

Report

Power Apps not displaying images from SharePoint/OneDrive links in Excel

Hi CU04101039-0

I will try to give you a human-generated response here . . . OneDrive links simply do not work as they are not referencing the file name (you will see that there is not jpg/png type extension on the end of the URL), so they have no actual file to resolve.

I have a blog on SharePoint Image Storing and Viewing that will give you some options to consider. Happy to discuss further.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
Amol-Kavnekar 123 on 04 Oct 2024 at 14:31:51

Like (1)

Report
Power Apps not displaying images from SharePoint/OneDrive links in Excel

Hi ,

Why Images Don't Display:

Authentication Requirements: Even though your files are stored in SharePoint or OneDrive and the sharing settings are set to "Anyone with the link," Power Apps doesn’t automatically authenticate the image URLs. This means that even though the links work for users in a browser, they might not work in Power Apps, especially when authentication is required for those URLs.

File URL Format: The URLs generated by SharePoint or OneDrive may not always point directly to the file itself but rather to a page that loads the file (e.g., the web view for the document), and this won't work in Power Apps' image control, which expects a direct link to the file itself.

Solutions:

1. Use the SharePoint Connector in Power Apps:

Power Apps integrates with SharePoint through a connector that allows it to display files directly from SharePoint document libraries.

Steps:

In Power Apps, use the SharePoint List or Document Library as your data source.

Store the images in a SharePoint document library.

Make sure the image URLs are being fetched from the "Link to Item" column or other metadata associated with the image file.

Bind the image control to the image column in the document library, like:
'Image control'.Image = ThisItem.'{Link to Image Column}'

Power Apps can display images from a SharePoint library as long as they are correctly linked via a supported connector.

2. Store Image Files as Base64 Strings:

Another method is to convert the images to Base64 strings, store them in SharePoint, OneDrive, or even directly in a database (like SQL Server or CDS), and bind them to the Power Apps image control.

Steps:

Convert the image file to a Base64 string.

Store this Base64 string in your data source (SharePoint, OneDrive, or other).

In Power Apps, bind the image control to the Base64 string.

Example formula for Base64 in Power Apps:

"data:image/jpeg;base64," & ThisItem.ImageColumn