cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Images in Gallery don't show up in mobile App

Hello!

I am still having troubles with displaying images in a gallery. I know there are lots of similar topics - I have read through a lot of them but for some reason I do not find the solution.

 

I have the exact problem that is described in this blog post: 

https://www.practicalpowerapps.com/images/powerapps-sharepoint-images-storing-and-viewing/#ViewLibra...

 

Whats my situation:

  • a Gallery in power apps based on a view in Azure SQL Server
  • one field in this view holds the URL to the image in a SP Library. I called it:

 

https://xyz.sharepoint.com/sites/Article/Article Images/a1/100162.jpg​

 

I also tried this format 

 

https://xyz.sharepoint.com/:i:/r/sites/Article/Article%20Images/a1/100162.jpg​

 

  • My image property in the gallery is set to

 

ThisItem.path_[image]​

 

 

Everything work on a PC but not in the mobile app. The images don't show up.

 

According to the blog mentioned above the solution would be to use

 

ThisItem.'{Thumbnail}'.Large 

 

instead of 

 

ThisItem.'Link to item' (what I using at the moment)

 

I'm just confused what the '{Thumbnail}' part should correspond to in my example...

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Most Valuable Professional
Most Valuable Professional

Hi @dash_7 ,

Is the SPID in your SQL the actual ID of the Library Item? If so you can do a LookUp

LookUp(
   Library,
   ID=ThisItem.SPID
).'{Thumbnail}'.Large

 

Please click Accept as solution 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 Thumbs Up.

View solution in original post

13 REPLIES 13
WarrenBelz
Most Valuable Professional
Most Valuable Professional

Hi @dash_7 ,

As this is my blog, 

ThisItem.'{Thumbnail}'.Large

(you can also use .Small and .Medium) is the only way to show images from a SharePoint Library on a mobile device as a SharePoint URL will not work due to the way the app tries to resolve URLs anonymously (and SharePoint needs a login). As you are already using 

ThisItem.'Link to item'

you are obviously already displaying the Library in a gallery - it is just a matter of changing the reference. What difficulties are you having with this?

 

Please click Accept as solution 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 Thumbs Up.

 

 

 

 

Hello @WarrenBelz 

 

I'm sorry. I don't know how else to explain:

 

This works. You can see part of the picture in the screenshot. My View holds a textfield 'Bild_[image]' with the URL like explained in my first post. 

Bildschirmfoto 2021-04-12 um 12.59.38.png

 

This does not work. I do not have a field 'Thumbnail' in my View. The data source of the gallery is a SQL view. I don't understand how this would connect to my SP library...it needs the url I would think...

Bildschirmfoto 2021-04-12 um 13.00.17.png

 

 

WarrenBelz
Most Valuable Professional
Most Valuable Professional

@dash_7 ,

You need to connect the SharePoint Library and have an identifier in the Library matching an item stored in your main list. This is easier in SharePoint Lists - I just use the ID of the List item and store it in a field I call IDRef in the Library. The Gallery then simply looks up the Library for the matching value as per example below in one of my prod field apps used on iPads (we do over 15k photos annually)

 

ThumbnailLarge.png

I imagine SQL will have a unique identifier you can use.

As mentioned, you simply cannot resolve a SharePoint "external" URL on mobile device.

 

Please click Accept as solution 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 Thumbs Up.

 

 

 

@WarrenBelz 

 

there is still one piece of the puzzle missing, sorry!

 

you said:


The Gallery then simply looks up the Library for the matching value as per example

How??

 

My gallery has the data source = sql view! There no connection to the sharepoint library by now!!

 

But in this view I have the image ID of the image file in sharepoint library. So I do have those corresponding fields: SQLView.ID and SharepointLibrary.ID

 

But how does this gallery get from the ID in the view to the file in sharepoint??

 

Of course I can create a gallery with the data source = Sharepoint Library. In this gallery I can add 'ThisItem.'{Thumbnail}'.Large' to the image property and the image is shown as expected.

 

But the part that missing for me is the connection from my (view-based)gallery  to the sharepoint library. 

 

WarrenBelz
Most Valuable Professional
Most Valuable Professional

Hi @dash_7 ,

You need to do it in the Flow when creating the photo item in the Library - one way is shown in the blog. You use Update file properties in the Flow and send the required value in Ask in Power Apps.

You may have to re-think your photo Library item creation, but this is the only way you will view the photos on mobile devices from a Library.

 

Please click Accept as solution 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 Thumbs Up.

hi @WarrenBelz 

 

I'm sorry Warren! I really appreciate the time you take but I have say that your answers are often not helpful because you don't write the parts that would be the relevant information. No doubt, that I am the limiting factor here because I know so little about power apps... but still.

 

For example you write:


You need to do it in the Flow when creating the photo item in the Library - one way is shown in the blog. 


Do what exactly in the Flow? Why would I need Flow anyways?? I already have the Sharepoint ID in my SQL View to connect those two!?

 


You use Update file properties in the Flow and send the required value in Ask in Power Apps.

This I don't get either?! Why would I need "ask in power apps"?? I don't try to save images...

I do not have an exact replica of your use case - I 'just' want to display images (on pc and mobile) that are stored in a Sharepoint library - where I already have the needed key in my SQL Table (Sharepoint ID; but I also have the complete link).

 

I'm really sorry. Like I said: I appreciate your time! But at this point I am so lost at trying to understand your answers that I am wondering if you are responding to my use case and description of my situation...

If there is anything unclear about what my setting is, what it is I am trying to and where I fail please let me know!

BR

Chris

 

WarrenBelz
Most Valuable Professional
Most Valuable Professional

Hi @dash_7 ,

I will try to frame it another way - firstly forget about the URL you have stored in your SQL table - that simply will not do the job of displaying image thumbnails from a SharePoint Library on mobile devices.
You cannot use your current structure and I was trying to point what you need to do - I will deal with that first and then talk about how you might get there.

To "link" your SQL record to the SharePoint Library picture/s that "belong" to it, you need to store an identical  unique identifier (numeric or text) in both the SQL table record and the SharePoint Library Picture record/s. In SharePoint, I use the ID in a Library field I call IDRef and you have mentioned you have an SQL ID that you can use. The process is then a gallery with Items something like

Filter(
   YourSPLibraryName,
   IDRef=YourSQLItemID
)

The Image/s are then simply 

ThisItem.'{Thumbnail}'.Large

Now to getting there - the one thing you have not mentioned is how you store your pictures in your SharePoint Library. The reason I mentioned a Flow is that is how I do it as the Pictures are either taken by the Power Apps Camera Control or added using the Add Picture Control.  I then simply send the ID with the rest of the data and add it to the Library record just created - the process for this is on the blog.

So how do you store the pictures in the Library - we may think of a process that will work for you.

 

Please click Accept as solution 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 Thumbs Up.

 

@WarrenBelz 

 


To "link" your SQL record to the SharePoint Library picture/s that "belong" to it, you need to store an identical  unique identifier (numeric or text) in both the SQL table record and the SharePoint Library Picture record/s. In SharePoint, I use the ID in a Library field I call IDRef and you have mentioned you have an SQL ID that you can use. The process is then a gallery with Items something like

I already have this unique identifier. I also use IDRef form the Sharepoint gallery.

This might be my big misunderstanding - but I think what you are showing me here is how create a gallery based on the sharepoint data source (Filter( YourSPLibraryName... etc...).

 

That wouldn't be a problem. Building a gallery based on the sharepoint library works fine.

 

But I have an existing gallery (based on the sql view). It holds lots of text information to each product. I would like to add to this gallery the respective image coming from the Sharepoint library.

 


the one thing you have not mentioned is how you store your pictures in your SharePoint Library. 


I uploaded the images manually to Sharepoint. In the end I would upload about 30.000 images (small image size, about 2kb to 10kb). The images don't change often - I would add/update some images about one or two time per year, manually. The library has no other columns/information - just the image files. And from this library I exported the respective IDRef to every image and added this column to my list of products in sql view. So every row in sql holds the correct IDRef of this image in Sharepoint.

So I thought that having this key (IDRef) on both sides (sql and sp) that I could join information from both sides in one gallery: holding all the text information to each and every product alongside the image coming from sp.

And this works on pc like described in the first post. Just not in the mobile app.

WarrenBelz
Most Valuable Professional
Most Valuable Professional

Hi @dash_7 ,

Can we please focus on your statement.

The library has no other columns/information - just the image files.

and agree with your last sentence
So I thought that having this key (IDRef) on both sides (sql and sp) that I could join information from both sides in one gallery: holding all the text information to each and every product alongside the image coming from sp.
The Library needs the ID of the SQL "master" in a field inside it - the IDRef field needs to be in the Library. You simply cannot refer to the URL you have in the SQL table - it will not work on mobile devices due to the way Power Apps resolves all URL anonymously (meaning the image has to be somewhere not requiring a security sign-in - it does not matter you are already signed into SharePoint) - it simply does not work on the mobile app. you will need to add the relevant matching ID to your 30,000 photos.

 

Please click Accept as solution 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 Thumbs Up.

 

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!   This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08  23 @WarrenBelz  31 @DBO_DV  10 @Amik  19 AmínAA 6 @mmbr1606  12 @rzuber  4 @happyume  7 @Giraldoj  3@ANB 6 (tie)   @SpongYe  6 (tie)     Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08  10@WarrenBelz 25 @DBO_DV  6@mmbr1606 14 @AmínAA 4 @Amik  12 @royg  3 @ANB  10 @AllanDeCastro  2 @SunilPashikanti  5 @Michaelfp  2 @FLMike  5 @eduardo_izzo  2   Meekou 2   @rzuber  2   @Velegandla  2     @PowerPlatform-P  2   @Micaiah  2     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27     Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8   SunilPashikanti8

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (1,768)