Using document location table to add a SharePoint Library to a Power App Portal

[Rich2]

I've setup integration between Power Apps and SharePoint. Successfully pulling the library, document names and the modified date into the model and portal apps. Now I want to add and remove a few columns. First, I tried adding and modifying columns in the document library. That didn't work so I went to the "document location" table in dataverse. That appears to point to the SharePoint Library but doesn't give you the ability to add or remove columns for each document in the library. Can anyone help or point me in the right direction?

Thanks, a heap!!

Rich

[cchannon]

The out of the box integration doesn't really account for SharePoint metadata. What you see in that grid OOB is pretty much what you get.

however... in the last few months SharePoint FINALLY added dynamics.com to their list of allowfrom domains in their site iframing restrictions, so you can now IFrame in a SharePoint page directly into Dataverse. So... while there isn't much you can do about the way the OOB grid looks, you could add your own IFrame to show the SharePoint library/folder. It would take a bit of code and some gymnastics to look up your site/library/folder, but it shouldn't be too difficult.

[Rich2]

I appreciate the response. 

That might be a bit much for me. I'll have to run that by our SME. 

Thanks!

Rich

[cchannon · Accepted solution]

Meh. You know what? I have been looking for an excuse to do a quick blog post here on the community anyway. I'll write it up for you, just for fun!

[Rich2]

Thank you very much.

[cchannon]

OK, @Rich2, here you go: cchannon/SharePointIFrame: A basic PCF for displaying the native SharePoint document library experie...

That GitHub contains the code and a solution file for a PCF that will display the native sharepoint document library experience within dataverse, so all you need to do in order to display any custom metadata columns you want is just to update the default view in SharePoint, and you'll see those changes instantly in Dataverse. I'll write a blog post in a bit that gives more detail on how it works and how to implement it, in case you've never used a custom control before.

[cchannon]

As promised, @Rich2, here's a more detailed blog post that will walk you through how the control was made and how to use it. Enjoy!

A Native SharePoint Document Library Experience In... - Power Platform Community (microsoft.com)