How to use SharePoint Lists in Model-Driven Power Apps with Dataverse Virtual Tables

I've got something super exciting to tell you about model driven apps if you work with SQL or SharePoint and you want to bring that data across into your model driven app you can do this now low code no effort no need for integration or anything let me show you what's possible I've got my asset management app here in model driven apps and I've got all the information about the assets and a whole process around that but let's say I wanted to link up each asset to the supplier who we purchase it from however the team that does that has already got this going on in SharePoint here we've got you know different suppliers that we work with with the phones they are not working in my model driven app they're not interested in the process because we're using those supplier relationships for other things as well and this is the master list so we don't want to replicate this data in the model driven app we don't want to do a migration it's actually serving us quite well here but we want to be able to use it so here's what we do I'm going to go across into my model driven app and my asset management app solution I'm going to go new table and look at this table from external data now you'll see at the time of recording I've got options here for SharePoint which is what I'm going to show you this will work exactly the same if you are working with data in SQL Server so if you've got something like product lists or great big data sets and things in there and I have this conversation with people a lot you're going to connect to these things and they're going to refresh in real time so that you don't actually have to do an import or another type of connection I'm going to go ahead and use my SharePoint connection here and say next I can put in the SharePoint URL but it actually already knows the team site that I was just on is where I want to be so we'll choose that click next and which one of the lists am I working with I've got a few going on there it's the suppliers list yes thank you I would like to configure table and column names that will be used in dataverse we'll click next and this is going to take the column names from my SharePoint list and put them in here and just give me a chance to check it so if I'm working with something quite comprehensive and deep here this is a pretty quick way of going so my display name is suppliers suppliers that's all good what's the primary field it's the the title that's okay now I'm going to change some of these things because I want the display name to be a little bit different so I want this to be the supplier name the external column here is the street address we're calling that City supplier contact renewal date that all looks good and it's creating my schema name and everything for me using the same prefix as the solution I'm already working in this is so exciting so here we go external data source is creating a dataverse table that looks like that that looks great let's click finish and see what happens with the magic of video editing I'm going to skip ahead this takes maybe 90 seconds or so it's not terribly long and this is what happens when it comes back it has created the table and now I'm in a very familiar place this it looks exactly like my normal dataverse table here table suppliers sitting in my solution let's go ahead and have a look at the columns in here I've got my city my renewal date my supplier contact supplier name so far so good and if I scroll along a little bit here in the data here is the data that I'm working with it's not showing all the right columns there let's just go ahead and edit that so that we can see those columns that were coming through because I didn't really use compliance asset ID so I'm going to go in here and let's get rid of all of those I just really want to see the renewal date the city the supplier contract supplier name and look at that there it is if I real data in there now here's where it gets good because this is going to behave like a dataverse table I can create relationships so remember my initial scenario here is that I have got my asset management app I've got my assets and I want to link to one of those suppliers in SharePoint so what I'm going to do here is go back a level into my app and have a look at the other tables in here click through to the asset table and from the asset table I want to create a lookup to that supplier table so we're going to go in here to columns I'm doing this for the first time as I'm recording this video so let's see I'm confident that it's going to work I've seen it done this is going to be the supplier and the data type is a lookup to which table pliers I'm happy and that's done now let's see if I can create some other elements in here too because what if I want to see that list of suppliers in my app and as a grid in here so we're going to go back into tables now you'll see it's actually in the solution here virtual table data source as well but there it is as a table as if I'm working on it like a normal database table so let's see what else we can do here let's create a view for it there's my all suppliers view there we go supplier name supplier contact renewal date City all exactly the same experience as if I built this table in dataverse so far looking good let's save that let's also see if we can create a quick view form so that when I'm on the asset and I'm looking up the supplier I can see some of that other information in there just because I'm excited I'm excited now and I want to see all the things we can do so I'm going to go into suppliers and I'm going to create a new form quick view form good so if you're not familiar with the quick view form this is a component that I can put on that asset screen to view information read only from another data table so this is looking good we're going to give this one a name we'll call this one the supplier information and we will already have the supplier as a lookup on the form so I don't want to replicate in there I just want to bring in the city and the renewal date and the supplier contact okay I'll save that let's go back to the solution now one more thing add that onto the form my quick view form so we're going to go into tables and now what I want to do is bring up this asset form and put it on this screen here so I'm going to go into my asset table forms my asset main form I'm going to make this description field just sort of drop that right back to just four rows move that underneath here and free up that column to put the supplier details in so I've created a look up to the supplier now so we've got that sitting in there there's my lookup to supplier and then I'm going to add that quick view form in there so I'm going to go into my components I'm going to add a display component oh actually it's up there quick view so we can bring the quick view in which one do I want I'm using the supplier lookup and I want the supplier quick view form done and that's going to sit right underneath it look at that City renewal date supplier contract so now we will save that we go back and I'm going to add it to the navigation menu of my app so let's go in and edit the app go to my navigation and add a sub area which is a table is this going to work oh yes suppliers right everything I'm doing here exactly as if I'm working with a table that I've built in database but it's just pointing to SharePoint look there they are okay great okay let's do this let's save that I'm gonna go back into my solution here and make sure that I've published all of the different components publish all customizations all right back in my model driven app now I've got my asset and my lookup to supplier I can use a little magnifying glass there let's say this one is from phones Ahoy and we're going to choose that and there is the information the city the renewal date and the contract all direct from SharePoint let's save that I've also got my suppliers over here in my app there they all are let's say we get a new supplier now so I'm going to come into my team site here we're going to add another one awesome phones they are in Melbourne supplier contact here is Harry Stevens and the renewal date in July we'll save so we've now got another one in there gonna go back into here and let's refresh this how good is that what if I do it the other way around and this one is actually awesome Phone House saving clothes let's go back to my SharePoint list and refresh that look at that complete two-way sink so this is really exciting ping me with any questions or anything you've got in the chat here around scenarios where you might use this if you'd like to know more about building model driven apps I've got a whole tutorial going on there if you want to get right into that knowing now that you can bring these data sources in and thank you very much for watching

Channel: Lisa Crosbie

Views: 19,209

Keywords: power platform, dataverse power apps, virtual tables dataverse, virtual tables dynamics 365, sharepoint lists powerapps, sharepoint lists and power apps, model-driven powerapps tutorial, model-driven powerapps, lisa crosbie, power apps, powerapps tutorial, virtual tables

Id: mEZSsx8B5HE

Length: 9min 7sec (547 seconds)

Published: Tue Mar 14 2023