Microsoft snuck in support for SharePoint Libraries into PowerApps

If you haven’t been paying close attention to some recent updates to PowerApps, you may not have noticed that Microsoft has started offering support to connections to SharePoint Document libraries.  They recently posted a video to the PowerApps blog on how to connect to a Document Library, and from some initial testing, this seems to work fairly well.

One big plus to this that I was able to confirm, is the ability to now pull in pictures from a Picture Library into PowerApps:

pw2

So, how can you accomplish this?  It’s actually pretty simple.  Just add a new Data Source, and connect to the SharePoint Site that holds the Picture Library you want to connect to.  In the “Enter Custom List Name” box, type in the name of the Picture Library:

pw1

Once the Data Source has been added, add a new Gallery (or just use and Image Control) to your PowerApp.

 

pw3

In the “Items” Property of the Gallery, change it to your Connected Picture Library:

pw4

Next, select the Image Control in the Gallery, and Change the value to ‘{Link}’  .  This will set the URL of the Image Control to the location of the asset in SharePoint, and the picture will now show up! (NOTE:  This doesn’t seem to work in the current Desktop Version of PowerApps, only in Web Builder.  I wouldn’t be shocked if that was remedied very soon)

pw5

Added Bonus:  Change the ‘On Select’ property of the Image Control to:  Launch(‘{Link}’) .  This will open up the picture in a new Browser window so you can save the image.

pw6

Please check out some of my other articles to take a deeper dive into the product, and as always, please feel free to reach out to me at jo.karnes@centricconsulting.com

12 Comments Add yours

  1. Jim Drahos says:

    I was able to do this and the images showed up on the emulator but not on the mobile phone. Does the phone app from the Microsoft store need to be update? So close…

    Like

    1. Jo Karnes says:

      It looks like this is only working in the Web Version.. Hopefully we’ll have full support soon (Maybe they’ll announce it at Ignite?)

      Like

      1. Jesper Würtz says:

        Hi Jo, Any changes to this? For me it will still only work in the web version.

        Like

      2. jfurtz says:

        Hi Jo, any changes to this? Still only works on the web

        Like

      3. Jo Karnes says:

        So, Microsoft has announced that they will only be going forward with the Web Version of the designer in the future. The desktop version of the builder will eventually be phased out, so I wouldn’t expect any major updates to it going forward.

        Like

  2. David says:

    Something news about it? I need this for data Analysis in a Cultural Heritage

    Like

    1. Jo Karnes says:

      Hi David, are you having an issue? What are you trying to accomplish?

      Like

  3. David says:

    I’m sorry. I forgot! Great blog..Really good job…

    Like

  4. Fleur Williamson says:

    I tried this, but I get an error when i enter the formula value ‘{Link}’ for Image.
    The error says Unexpected token.

    Like

  5. Thomas Kunka says:

    I’ve connected to my on-prem SharePoint document library have a gallery that displays the records. I am attempting the image = ‘{link]’ trick but it doesn’t work. I’ve even tried ThisItem.'{link}’ with no luck. Am I going to have to go to the more complicated swagger/json solution – which I have tried as well but haven’t had luck with.

    Like

  6. William A. Hardwick says:

    Has this been fixed yet, I am able to see my SharePoint Images on my PowerApp on the desktop, but it does not show up on my iPhone PowerApp?
    Does anybody know anything about this issue?

    Like

  7. Hassan Nawaz says:

    Hi, the pictures not showing on iPhone PowerApp please any body could help about this?

    Like

Leave a reply to Hassan Nawaz Cancel reply