PowerApps Model Driven (Dataverse) how to embed SharePoint Document Library

[@ProfessorPopTarts]

Hey Darrin wanted to say THANK YOU for your excellent content. Really appreciate your videos and the time you take to explain concepts.

[@ThamerAffara]

thanks so much for this straightforward easy to digest video!

[@David863006]

Thanks, it was an easy walk-trough with your explanation.

[@saltysponge9965]

wow, omg thankyou, spent 2 days trying to figure this out, your video put a end to my misery lol thank you

[@365assistdarrenlutchner9]

Thank you very much for the kind words. So glad I could help.

[@antonioskokiantonis7051]

Very clear and helpful video about its subject. Thank you!

[@SPrichard]

Hey Darren...one of only a few videos showing this. I have two questions. You created a specific site and used that site address to enable sharepoint integration and in document management settings. That is great for that project. What if I have another app...I don't want to store to that sharepoint site. Can you add multiple sharepoint sites or is it one per environment?

[@17avskadoo]

Thanks a million !! You did a really great Job🤩

[@michielleijzer8189]

Excellent! Very helpful en well explained!

[@leonardomenezesdasilva5222]

Thank you for the excellent video. Would it be possible to embed OneDrive or a SharePoint document library within PowerApps Model Driven (Dataverse)? I'm interested in learning how to do this. Additionally, I would like to synchronize it with my computer using OneDrive.

[@muriwangul.chinyerere5381]

Well explains! Thanks!

[@darkspeed62]

How well does this soluttion integrate with Power Pages for people wishing to upload?

[@365assistdarrenlutchner9]

Thanks good question. Not sure.

[@Keathar]

Hi Darren and thank you for a helpful video. Do you know if there is a way to reference the path to the folder or any added documents in ms flow for example? I would like to use the file added to the unique folder for an approval process.

[@365assistdarrenlutchner9]

Sure. At the 11 minute mark of my video I show where in SharePoint the document library and folder is. When creating a Power Automate flow you can just reference that library and file location.

[@petervanlierop3431]

Thank you for this video, Darren. Do you have a solution in case the namevalue is changed the URL and Sharepoint foldername is also changed? When using this with companies they sometimes change their company names and users in Sharepoint can't find the documents any longer.

[@365assistdarrenlutchner9]

Hi Peter, Good point. No I haven't come across what occurs if the namevalue is changed. I imagine its some kind of manual redirect.

[@aniketbanerjee1226]

Hey Darren, this was really helpful. I had a quick question though. Is there any way to show more SharePoint columns(custom) within the MDA subgrid?

[@365assistdarrenlutchner9]

Great question. Yes there is a standard Dataverse table called SharePoint Document. Just change the view called all SharePoint Document.

[@MrBrianKariuki]

I am not sure is someone else has pointed this out but the Relative url, where you point to a table name (8:17) is not working, If I put the name of the document library then it works

[@17avskadoo]

You need to click on that link first time and folder get created and then your connection will say Already exists.

[@acradic]

How do permissions work? If the user only has access to some of the records in the table (DemoPerson), if they go directly to the SharePoint site, will they be able to only see the documents they have access to?

[@365assistdarrenlutchner9]

Great question. Yes you do need to make sure that users have access to the SharePoint library. The permissions in the Dataverse and SharePoint are managed separately.

[@sudhanshu2009]

Hi Darren, Thanks for the helpful video. Is it possible to connect an existing document library to a an entity/table? I cant seem to find any solutions on the web. I would like to create a docset in a exitsing sharepoint library. Please help.

[@365assistdarrenlutchner9]

Good question. You won't be able to do it using the technique in my video. The other suggestions are you could create a URL field in the table and perhaps use Business Rules to populate the URL with the library location.

[@smp394]

Is there a way to change the folder naming convention to remove the ID? Also, is there a way to create a folder template system inside the folder it creates?

[@17avskadoo]

I think Darren mentioned its default setting

[@michielleijzer8189]

Is it possible to change which columns are shown in the embedded library?

[@michielleijzer8189]

I've found how to do this but I can't seem to find where I can edit the form that pops up when you want to edit the document properties. Is it not available?

[@365assistdarrenlutchner9]

Great question Michael. I also looked for it. I believe its a Virtual Dataverse Table and therefore there is no way to change the View. If you are a developer perhaps it could be done via code. But that's beyond my "pay grade" :)

[@aniketbanerjee1226]

How did you do that?

[@ChrisTsafos]

For whatever reason, I can't see any action buttons (e.g. + NEW) on the ribbon menu inside "SharePoint Document Locations". I'm stuck...Any ideas?

[@365assistdarrenlutchner9]

Perhaps you do not have permission. Are you a Power Platform administrator and do you have access to add new documents to the library directly in SharePoint?

[@ChrisTsafos]

@@365assistdarrenlutchner9 Hi Darren. I figured it out. Once you add the default SharePoint site, it creates a clickable link under the SharePoint Document Locations that opens a Model Driven App that enables you to add/edit/etc. additional Doc Locations. It seems the ribbon may have been deprecated and this is a just a strange UX straddling b/w the old and the new worlds

[@alejandrocamargo8394]

Thank you for your video, just what I was looking for. But, if I understand, you can just connect your model - driven app to ONE SharePoint site?. Do you think it is possible to connect to many? Say that every "DemoPerson" has a unique SharePoint site within the same environment Thank you again.

[@dlutchner]

Hi Alejo, Glad I could help. Good question. Using the solution I provide I can't think how you could set up multiple for the one Dataverse record. However another solution is you could create a URL field on the form where the user can paste the additional site address.

[@alejandrocamargo8394]

@@dlutchner Thank you again, Darren. Yes, actually I am using the ulr workaround, but its not "that cool". 🙂