Contact Us

Kockpit is here to help you

Business Form

Shriya Narang

How to View Related Tables Columns Into one Form In Powerapps

What is the purpose of the Quick view form?

  • With the help of ‘Quick View Forms,’ you can add the columns of related tables to another table’s form.
  • To add the columns of one table to another table, you need to create a relationship between them.

We will see here how we can do that by example.

When we use the Quick view form?

Quick view controls are associated with a lookup field which requires a relationship between tables. If the lookup field value is not set, the quick view control will not be visible. The fields shown in quick view controls are read-only and cannot be edited.

We can add quick view forms to another table's forms as quick view control. The quick view control provides the capability to view information about a related record. Adding a quick view form means that users do not need to worry about viewing related table information in a single form.

Create relationships among the tables :

Suppose we have two tables

  1. Business Requirement Table
  2. Mediocre Table

If we want to add the columns of the “Business Requirement Table” to the “Mediocre Table,” we cannot do that directly into the form as we can do in the Lists. So we can do that in the forms with the help of Quick view forms. We will see by the example screenshots which are given below:-

In the above-given screenshot, you can see the rows in the first columns, such as Job-id, Salary Range(Min), Experience, Location

If we want to add those columns to the mediocre table forms, it is impossible to add them directly.

So we can do that with the help of quick views forms by creating quick view forms in the Business Requirement Table of the columns which we want in the mediocre table.

And we can add that quick view form in the mediocre table, which consists of the columns which we wanted from the business requirement table.

Note: There must be a relationship between the two tables. In our case, we have created the relationship between the Business requirement table and the mediocre table, as you can see in the screenshot below:-

Now you create Quick View Forms in the Business requirement table. So you can get the columns of the business requirement table to the mediocre table.

How to create a Quick view Form?

You can see the process of creating a quick view form in the given screenshots:-

  1. Go to Solution -> Tables -> Click on Forms -> New Form -> Quick View Form
  2. You will be able to see the following screen where you can add columns in the forms according to your requirements. In our case, we needed the following column you can add the columns as per your need.
  3. After saving and publishing, you can access your Quick view form in another related table.
  4. Note: - In the table, you need to create the main form and add the Quick view form. As you can see in the below screenshot:-

  5. After clicking the main form, you will see the following screen where you can add the quick view form you created in another table.
  6. Click on components.
  7. Click on Display, then click on Quick view.
  8. Now, you can select the lookup table or relationship which you created.
  9. From the dropdown, you can select the quick view form you want to add here.
  10. Click on Done Your Quick View Form is added to the form.
  11. You can do some extra editing, like can hide the label or you can rename it, then save and publish your form.
  12. Now, you can add the form according to your need, just like we added it on the powerapps portal as summary forms. We are adding business requirement table columns in the Summary form of the Mediocre tables list, which is not possible directly by the main form.

You can only add the same tables from on the list of that table, not another table form, but you can add related table columns with the help of the Quick view form.