A lesser-known, but really important update to PowerApps

22 Comments on “A lesser-known, but really important update to PowerApps”

1. Hi Paul. I tried creating a Picture column in sharepoint and added the URL link into it but it does not display the photo as what you have above. Able to advise on how to workaround with this? Thank you

2. Did you format the URL as a picture or hyperlink in SharePoint? Make sure it’s picture…

3. I chose the “Picture” type column and copied the picture URL link in, but i could only view a mini black cross image instead of the actual image..

4. Hi Paul I managed to view the saved images in PowerApps using your Floxy method ! 😀 But I noticed that some pictures shown are rotated by 180 degree when I take pictures with my iPad upside down, any advice on this ??

5. A great way to pair this up with your other post about uploading photos to SharePoint is to just create a hyperlink/picture column in the document library itself and add a link to itself using an Update List Item action in Flow. You will need to run a Get List Item action first to be able to use the Link to Item dynamic content. I was trying to submit and display uploaded pictures in the same app using only 1 list and that approach worked for me.

6. I used this approach and got to view the uploaded pictures in PowerApps, but my users could not view it. I did some troubleshoot and found that his [snip a GUID] part is different from mine..may I know what this is and if I could automate/set a common path for all users ?

7. Great idea! But I have to know… I can’t edit hyperlink columns in flow if they are formatted as picture. Are you saying you got it working this way?

8. The GUID is probably different because each person connects to SharePoint using their own account. Do your users have access to the library in question if they access via SharePoint?

9. Yes I have given them the access to the library in SharePoint. Trying to find a way to extract each user’s GUID to replace in the function in order for them to view the pics. Would appreciate if Zachary could share your approach in details to me also 😊

10. You cannot and should not play with that GUID or do anything at all. That is automatically created and maintained by PowerApps. This is a read-only column and I don’t understand why you would want to write to it?

11. Sorry if I did not state my objectives clearly before this..I am creating an app for users to upload pictures into SharePoint and these pictures need to be reviewed by approvers in PowerApps as well..So I have followed your guide on API swagger file to save pictures in SP and now I need to view these saved images back in PowerApps gallery..next, I followed the guide in this post to view the saved pictures by inserting the function into Gallery control:

    \”appres://datasources/Equipment%20Photos/rows/79/reference/https:%2F%2Fasia-001.azure-apim.net%2Fapim%2Fsharepointonline%2F0a9830dd44d04f14bc631fafed2380de%2Fdatasets%2Fhttps%25253a%25252f%25252fsppower.sharepoint.com%25252fsites%25252fSharepointtechnologytestingserver%2FGetFileContentByPath%3Fpath=%252fEquipment%252520Photos%252f\”&ThisItem.Photo_x0020_Title\”

    This approach somehow works only on myself because the GUID of my users are unique as mentioned by you..So how could I make it such that all users are able to view the pictures?

12. I think you are confusing the two approaches. You cannot use the floxy technique of messing with that URL at all. You simply add a gallery, bind it to the list in question , add an image control and set it to the picture column . PowerApps takes care of the rest.

    You can only mess with the URL with the floxy method which is altogether different. That is the URL of the flow, not the PowerApps magic to make images work…

13. Yes but the problem is picture column could not be updated automatically using flow upon saving the pictures..so in short, is there a way to save the pictures and update its respective picture column as well?

14. That’s right. You can’t work around that issue by combining the two methods. If you want to make that work, you will need to use REST webservice calls in Flow or use an Azure function. Microsoft have acknowledged the issue though but not idea when it will be fixed…

15. Hi Paul, a quick question beside this topic…I wish to export the images in gallery out as a single document/pdf, do you have any recommended approach for this? Or in another term, how can I combine the pictures saved in sharepoint as a single PDF/document ?

16. This doesn’t work on Mobile App. Not sure if they have switched this off?

17. Hi There,
    Sorry to bother you, quick question here. I have my SPL as you describe pictures are hyperlink and format is “Picture” I can see all my pictures in my SPL, I can also can see the pictures in my powerapps, but the rest of the people in my organization cannot see any picture. Any idea what is the issue?

    Thanks in advance for your response,

18. It seems SharePoint pictures don’t appear on mobile. I have it formatted as Picture (not hyperlink) but it still does not display on mobile 🙁 It works in a browser.

19. Hi Paul,
    Great tips and suggestions! I came up with another solution for displaying SharePoint images on mobile devices that you and your audience might be interested in 🙂 Basically convert the images to dataURIs..I blogged about it here https://www.bruce365.com/2018/10/11/display-sharepoint-images-on-mobile-devices-in-a-canvas-powerapp/

20. Hi, I have added a hyperlink field in SharePoint list and I want to upload images to the list using Powerapps form through this hyperlink field, but I am not able to do this.
    Could you please suggest a possible solution?

21. You can use the following formula to extract the user’s GUID in the application.
    ClearCollect(libGUID,Filter(Documents,ID = 266));//do not delete this item set it to read only in document library
    Set(libGUID_Pic,Text(First(libGUID).Pic));
    Set(spGUID,Replace(libGUID_Pic,1,Find(“%2Fsharepointonline%2F”,libGUID_Pic)+Len(“%2Fsharepointonline%2F”)-1,””));
    Set(userGUID,Replace(spGUID,Find(“%2Fdatasets%2F”,spGUID),Len(spGUID)-Len(“%2Fdatasets%2F”),””))

    You can then change the GUID in the link to the PDF file.
    example:
    “appres://datasources/Equipment%20Photos/rows/79/reference/https:%2F%2Fasia-001.azure-apim.net%2Fapim%2Fsharepointonline%2F”& userGUID &”%2Fdatasets%2Fhttps%25253a%25252f%25252fsppower.sharepoint.com%25252fsites%25252fSharepointtechnologytestingserver%2FGetFileContentByPath%3Fpath=%252fEquipment%252520Photos%252f\”&ThisItem.Photo_x0020_Title”

22. Hi All, in case you are still using this in 2024, this seems to have broken today 7/11/24. Let me know if anyone finds another way.

    Cheers