Multiple Dataverse tables in one form

(0) Share

Report

Posted on by HannesIvo

Hi guys

is there a possibility in Power Apps to display multiple Dataverse tables in one form?

Looking forward to a reply
Greetings

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

No, a form can refer to only one table. However, you can use LookUp() to find values in other tables to use in your form, or leverage a related table column from Dataverse. In addition, it is possible to use Patch() to update a value in a second table while letting the form do its work with the first table.

If you can share more about what you are trying to achieve, the Community may have some additional info to help.

Regards,

Bryan

Was this reply helpful? Yes No
HannesIvo 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCLS776,
first of all thank you.
I have an app to create a digital report. First, I request certain information via forms. In this process, I feed a large dataverse table. In addition to the large table, I have 3 small tables for information which require multiple inputs.

After the user has filled in all the information, he has the possibility to look at the report again or to edit it.
For this purpose I use a large form in view mode or via a button in edit mode.

So far this form only shows the large dataverse table.
However, the information from the 3 small tables must also be displayed and editable.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@HannesIvo wrote:

Hi @BCLS776,

first of all thank you.

I have an app to create a digital report. First, I request certain information via forms. In this process, I feed a large dataverse table. In addition to the large table, I have 3 small tables for information which require multiple inputs.

After the user has filled in all the information, he has the possibility to look at the report again or to edit it.
For this purpose I use a large form in view mode or via a button in edit mode.

So far this form only shows the large dataverse table.
However, the information from the 3 small tables must also be displayed and editable.

In this case, consider building several form controls adjacent to one another on the screen, with each form control linked to its own table. You may be able to create an interface that is seamless to the user but is in fact composed of multiple form controls.

Form controls are always a good first choice due to their built-in functionality; however, you can still use Patch() to create and edit records in various tables if that's better for your app.

Bryan

Was this reply helpful? Yes No