Answered

Multiple tables in one form PowerApps Portal Web Page

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Can I display multiple tables (Input Forms) in one Form with one Submit button? I try to create one table with lookup to another table but it only display one primary field of another table, Not all the fields in the second table. I see the Table Main form in the backend designer and that only allow me to add another table as a sub-grid and set its View Records forms not Input Forms.

Thanks,

-Sal

Categories:

Power Apps portals

I have the same question (0)

All responses (5)

Answers (1)

Sort by

OOlashyn 3,498 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Did I understand you correctly that you want to show to entity/web forms for different entities on one web page and submit them simultaneously with one button? If that's your requirement then unfortunately with using just forms you cannot achieve this. You might try to use Web API to create a fully custom page with custom experience by submitting data view Web API.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Yes, looks like with Entity form I get stuck with one form so looked into Web Forms where I can add multiple entities in steps but Is there anyway I can pull the submitted record in one place as a Join on two tables?

Was this reply helpful? Yes No
OOlashyn 3,498 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

To be honest I don't fully understand what exactly you want to achieve as a final result. Do you want to create two separate records in two separate tables and then based on that data create a new record in a new table? Or you want to be able to view created data in one place? Can you please clarify this?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I have multiple Entities (Tables), with multiple input text fields. If I use Entity Form I can only tie that with One Entity at a time and it display the Insert\Edit\Read only form. I wanted to display Entity 1, 2 , 3 set of input fields in one long form.

Thanks,-Sal

Was this reply helpful? Yes No
Verified answer

OOlashyn 3,498 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I would advise you to check Portals Web API - it will be the easiest way to solve this problem. It is still in the preview, however, in February it should become GA.

Was this reply helpful? Yes No