Hello folks, welcome back in today's demo I will customize the sharepoint list form using powerapps
I will retrieve lookup drop down from a different site collection sharepoint list and display related columns
As well so stay tuned
This is a list hosted on a sharepoint site called online classes
So the idea is that we have class title the duration of that class and who is the tutor
So at the moment the tutor field is a text field
So if I click on new item, I can see I can provide the class title. The duration is a drop down
So one three or five day, but the tutor is a textbook. But what I want is that this tutor value to be
Automatically selected from a different master data Share|Point list hosted in a different site collection
So if I navigate back to master data site, I can see that there is a list of tutors available here
So what I want is when someone select create a new record or amend an existing record
I want the drop down from these tutor lists to be available here so we can use a lookup now
What I also want is that all these other information about that tutor like email contact number should also display it at the text value
Here once a person select the information and save it
So the first thing we need to do is we need to customize this sharepoint list form using power apps
So if I click on the powerapps icon here and click on customize forms
This will open up the powerapps application form for me now
The first thing I need to do is I don't need this attachment field here
So I select that card and hit delete from the keyboard
It's deleted
Now the tutor field is a text box. I need a drop down. So I need to delete this text box
But as you can see this card is locked
So first thing I need to do is I need to click on advanced while i'm selecting this card
And I click on this to unlock it now. I can select the text box and then hit
Delete from my keyboard. I will come back to these errors later on. We will fix them before that
Now I need to add a drop down. Let me make this form a little bigger
So if I click on insert under inputs drop down I can see the drop down
Type select that make it same width as the other column now
What I need to do is I need to connect
This drop down to this list from sharepoint so I can retrieve all the tutors information
In this form to do that from this left menu. I will click on this data icon and then I will search for sharepoint
Basically i'm searching to connect to sharepoint list
So if I click on that I can add a new connection here, or I can use one of my existing connection
So I got access to the other site collection
So I will use existing connection now it is asking me to provide me the site
Url, or you can select one of the recent sites
so I have already used this site before so I click on master data now it is asking me which
List you want to connect to I will say tutor connect now it is connected to the tutor list
So if I go back to the form now this drop down field is here
Let me just rename this one just to tidy a few things
I will just call it tutor drop down now if I select this tutor drop down and the items
Which is selected by default. It says it's drop down sample. I want to change this
So this drop down value will be tutors dot
Title because we have the title column there from the master data list is title column
So the tutor dot title and hit enter and if I play this it doesn't work
so sometimes it doesn't work the first time so if I just go back and remove it and now if I select
Tutor.title and hit enter you can see the value is already populated here
So if I play now I can see the values here now. We need to fix these two issues
So if I click on the first one now?
Basically the card value 3 data card value three is the text box which we have removed
So it is looking for the dimension for that
So I will just remove this and I will just call it
Tutor drop down dot height and hit enter that will get rid of the error
The other one is if I click on add in formula bar now it is saying that when we update the form
It is expecting the data card value three dot text to be saved in a shape on list
But we now have this drop down instead of the credit card value three
So what we need to do here is we will say tutor dropdown dot selected dot title
So whichever value is selected or title, that's the value which will be saved in a sharepoint list and hit enter
That's all set now
So the next thing we need to do is we need to display that tutor email address and phone number in a label here
So that's the related data from that lookup so if I click on label, this is added a label on the form
so the text for the label will look like I will say tutor email and
What we need to do is we need to look up for that column from that list
So we will use the lookup function powerapps say lookup from which list
We have tutors connection there and which value we need is when the title is equal to tutor dropdown dot selected
dot title
So give me the lookup value from this tutor connection tutor list where when the title is equal to
tutor drop down selected or title
But what field I want to retrieve is I want to retrieve email close bracket now straight away
You can see that the selected tutor email address
Is there I will just copy this now for the phone number label as well
I will copy that i'll add another label and in the text
I will just paste that information there. I will replace this with phone number and instead of email. I will say contact number
And hit enter now you can see the tutor email and content number
Is there if I play this now select a different one? I can see a different tutor
So let's save and publish and see how it looks like on a sharepoint list
So from file menu click on save and publish to sharepoint
Yes
I want to publish these two sharepoint forms now it is all published so I can click here to go to the list
We are in online classes list now
If I click on new I can select I can set it a title. I will say SharePoint lookup training and duration one day
And the person is Ryan Stoke now hit save and you can see the information is saved
So just to wrap up today you have learned how you can connect to a sharepoint list
Which is sitting on a different site collection and use that as a master lookup data into a sharepoint form using powerapps
And how you can retrieve the related columns using powerapps as well consider subscribing if you're new to the channel
By pressing the red subscribe button below this video give this video a thumbs up if you found it useful
If you have any question related to this video or anything related to office 365 in general post in the comment section below
I will be happy to answer. Thank you