Answered

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

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (6)

Answers (1)

cchannon 4,702 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I appreciate the response.
That might be a bit much for me. I'll have to run that by our SME.
Thanks!
Rich

Was this reply helpful? Yes No
Verified answer

cchannon 4,702 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you very much.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report

OK, @Anonymous, here you go: cchannon/SharePointIFrame: A basic PCF for displaying the native SharePoint document library experience as an iframe in dataverse (github.com)

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.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report

As promised, @Anonymous, 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)

Was this reply helpful? Yes No