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

Categories: Microsoft, Office 365, PowerApps, SharePointTags: , , ,

10 comments

  1. 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

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

    Like

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

    Like

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

    Like

  5. 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. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: