Contents
You must have created an app using SharePoint connector that connects to a SharePoint list. The SharePoint list should consist of a lookup column with values from another column. You can use lookup columns in SharePoint that consume values from other lists or libraries.
How does the primary lookup column in the source list work?
The primary lookup column in the source list (Reading List) “looks up” the ID column in the target list (Courses) based on a matching value. A secondary lookup column in the source list automatically inserts the Course Name column from the target list.
Choose your SharePoint site from the Recent sites list or enter your site’s url directly into the text box. Click or tap GO. Choose the main list from your SharePoint site, in this example, Assets. Click or tap the Connect button in the lower-right corner.
How to link two SharePoint custom lists together?
In this tutorial, you link two SharePoint custom lists together, Assets and RepairShop. The Assets list is used to track hardware equipment in a team. Since hardware gets broken from time to time, we use the RepairShop list to track the local shops which can fix it. The RepairShop list uses the ContactEmail field to identify the shop.
How To Filter Form Drop Down That Is A SharePoint 10-06-2020 06:43 AM Scratching my head on this one….. I have a SharePoint Online list which is my data source. I am building a canvas PowerApp on top of it. One of my fields in the SharePoint list is a lookup field, getting information from another SharePoint Online list.
How to use a drop down list in canvas?
When using such columns as a field in a canvas app, you can use a drop-down list with choices. To use the choices in a drop-down list, you have to use the function choices.
How to use choices in a drop down list?
To use the choices in a drop-down list, you have to use the function choices. For example, Choices ( [@’Vehicle registration’].Vehicle_x0020_type) uses the SharePoint list Vehicle Registration and the column Vehicle type for the lookup of the type of the vehicle. Sign in to Power Apps.
How to create a drop down list in SharePoint?
Select + (insert) from the left pane. Select Drop down. Update the Items property with the following formula: Replace Vehicle registration with the name of your SharePoint list and Vehicle type with the name of the lookup column in the list.
https://www.youtube.com/watch?v=KuNpeF0-8dI