cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rich2
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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!

View solution in original post

6 REPLIES 6
cchannon
Super User
Super User

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
Resolver I
Resolver I

I appreciate the response. 

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

Thanks!

Rich

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!

Thank you very much.

cchannon
Super User
Super User

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.

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)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,936)