This feature allows for effective data navigation across different tables in the database. In essence, lookups establish relationships between two tables, tying data from one table into another without duplicating it.
Understanding Lookups
In Microsoft Power Platform, lookups are relationships that are created between entities. These relationships allow you to pull information from one table or entity to another. For instance, imagine having a ‘Customers’ table and an ‘Orders’ table. The Orders table might need information from the Customers table such as customer name or contact information. A lookup allows for this data to be referred to in the Orders table without trying to store all the Customer information in it.
How to Create Lookups
To create a lookup in the Power Platform, follow these steps:
- Open the table where you want the lookup field to be located (for example, the Orders table).
- Click the ‘Add Column’ button.
- In the dialog box, you fill out the following information: Display Name, Data type (select Lookup), and the table you want to pull information from (for example, Customers).
- Click ‘Done’ and ‘Save table’.
With these steps, a lookup field is added to your table, allowing for data from the selected table to be displayed.
Use of Lookups in Practical Scenarios
A recommendation for a real-world scenario for using lookups is in a project management system. One might have a Projects table and an Employees table. Each project can be assigned a project manager from the Employees table. A ‘Project Manager’ lookup field could be added to the Projects table, providing data on who is in charge of a project without needing to duplicate the employee data in the Projects table.
Also, consider a situation where you have a ‘Sales’ table and a ‘Products’ table. Each sale entry might need to refer to a specific product. By creating a lookup, you can directly link each sale to a specific product from the Products table.
In summary, lookups in Power platform are an effective way of establishing relationships between different tables in a data set, allowing for efficient and practical data management. They can be implemented in a myriad of scenarios, offering robust data navigation that reduces redundancy, promotes data integrity, and accelerates the retrieval of related data.
Remember, mastering the usage of lookups is critical for app makers taking the PL-100 Microsoft Power Platform App Maker exam. It’s a key skill for building powerful and efficient apps. Therefore, cling to practice, and make sure you understand the concept behind lookups and how to implement them in various scenarios.
Practice Test
Lookups in Power Apps are used to connect two tables.
- True
- False
Answer: True
Explanation: Lookups in Power Apps are used to create relationships between tables, much like in any database management system.
When you create a lookup, you are connecting two tables using a foreign key.
- True
- False
Answer: True
Explanation: In database management, a lookup relationship acts like a foreign key, connecting two tables.
What are the lookups in Power Apps called?
- Lookup fields
- Lookup forms
- Lookup tables
Answer: Lookup fields
Explanation: Lookups in Power Apps are called lookup fields as they work by adding a new column to an existing table that is used to display data from a related table.
You cannot add more than one lookup field in a table in Power Apps.
- True
- False
Answer: False
Explanation: You can add more than one lookup field to a table in Power Apps to represent multiple relationships.
What does a lookup field store?
- The related data
- The record’s unique ID
- The table name
Answer: The record’s unique ID
Explanation: A lookup field stores the unique ID of the related record, not the actual data.
Lookup fields allow users to view and edit related data from a different table.
- True
- False
Answer: True
Explanation: Lookup fields allow users to view and edit data related to the main table’s record without having to switch to the related table.
A lookup field can display data from multiple tables simultaneously.
- True
- False
Answer: False
Explanation: A Lookup field can only display data from one other table at a time. You would need multiple lookup fields to display data from multiple tables.
The information displayed in a Lookup field updates when the original data changes.
- True
- False
Answer: True
Explanation: Any changes made to the original data will be reflected in a Lookup field. This is due to the lookup field being linked to the original data’s unique ID, not the data itself.
A Lookup field can link tables in the opposite direction (i.e., from the related table back to the main table).
- True
- False
Answer: False
Explanation: The relationship represented by a lookup field is unidirectional, not bidirectional.
Which among the following cannot be presented in Lookup fields in Power Apps?
- Text
- Number
- Password
Answer: Password
Explanation: Passwords are generally not stored in fields that can be viewed directly, so they cannot be presented in Lookup fields.
When working with Lookup fields, the data type of the related field should always be text.
- True
- False
Answer: False
Explanation: The data type of the related field doesn’t need to be text always. It can be also be number, date/time, and more.
You can use the data from Lookup fields in calculations.
- True
- False
Answer: True
Explanation: Data from a lookup field can indeed be used in calculations, expressions, and other operations.
Can a Lookup field refer to a field on the same table?
- Yes
- No
Answer: No
Explanation: A Lookup field typically refers to a field from a different, related table. It is not designed to refer to fields on the same table.
Lookup fields are limited to displaying only one type of related data.
- True
- False
Answer: False
Explanation: A Lookup field can be set to display any desired field from the related table and can be changed to display other fields if needed.
If a record referenced by a Lookup field is deleted, the Lookup field still maintains the original data.
- True
- False
Answer: False
Explanation: If a referenced record is deleted, the Lookup field can no longer display any data as the reference is broken. This is due to lookup fields storing the record’s unique ID and not the data itself.
Interview Questions
What does “link tables by using lookups” refer to in Microsoft Power Platform?
It refers to the process of connecting two tables together through a lookup column in order for one to access data from the other. This allows a record in one table to reference or ‘look up’ data in another table.
In what situation would you most likely use lookups to link tables?
You would typically use lookups in situations where you need to maintain a relationship between data stored in separate tables, or when you need to avoid the repetition of data across tables.
How does a lookup field behave in table linking?
A lookup field behaves like a drop-down list box that contains values derived from a table or query, and allows users to select a value from that list.
How many types of relationships can be made using lookups in PL-100 Microsoft Power Platform?
Three types of relationships can be made in the Power Platform using lookups: One-to-many (1:N), Many-to-one (N:1), and Many-to-many (N:N).
What is a “One-to-Many” relationship in terms of using lookups in table linking?
A One-to-Many relationship is a type of table relationship where one record from the first table corresponds to multiple records in the second table. This is typically managed via lookup columns.
Which function would you use to retrieve records from a related table by using a lookup field?
The ‘LookUp’ function is used to retrieve a single record from a related table using a lookup field.
What type of data can be stored in a lookup column?
A lookup column can store unique identifiers (GUIDs) of records from another table, forming a reference to that record.
Can you delete a record that is being referenced by a lookup field in another table?
No, you can not delete a record that is referenced by a lookup field in another table. This is because deleting this record would break the reference, resulting in inaccuracies in the data.
Can lookup columns be made to reference tables in other databases?
No, lookup columns can only reference tables within the same database.
How many lookup fields can you create in a table in Microsoft Power Platform?
There isn’t a specific limit for lookup columns in a table. The actual limit depends on the total number of columns in a table, which is 1024 columns for a non-wide table, and 512 columns for a wide table. These limits include lookup columns.
Can you use a lookup column in calculated fields?
Yes, you can use a lookup column in the creation of calculated fields, but it can only pull data from the primary field of the related table.
Can a lookup field display data from multiple fields in the selected record?
No, by default, a lookup field only displays data from the primary field of the selected record. However, you can use a composite field to display data from multiple fields.
Is it possible to change the text in a lookup column after it is created?
While it is not possible to directly change the text in a lookup column after it is created, you can change the text of a lookup column by changing the primary field of the table it references.
In what order do lookup fields display their list of choices?
The lookup fields display their list in ascending order, based on the primary column of the referenced table.
Do lookup fields support multi-select options?
No, lookup fields do not support multi-select options directly. Users can only select one value at a time from the provided list in the lookup field.
extutorials.com