Unanswered

How can I create one simple form(Intended for Portals Basic Form) with input fields from two related tables

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Is there an out-of-the-box solution or any solution to create a simple form(Main) in the Dataverse form wizard that allows anonymous users(Portal Website) to insert new records into two separate Dataverse tables? I need one form that includes all(four) fields from both tables(1:N.)

Currently, I have table permissions set to global, and I have a lookup column that has created my 1:N relationship.

-Thank you

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

1. Set table permissions for all three tables and add the "Anonymous" user web role ( Check are you happy to do this- the data is exposed to the public.

2. Create a lookup column and choose the table you want to select and select appropriate fields.

There is also a related thread using FetchXML

https://powerusers.microsoft.com/t5/Power-Apps-Portals/How-to-set-lookup-field-value-based-on-another-field-value-in/td-p/956905

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

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

Like (0)

Report
Copy link

Link copied!

Hey @ragavanrajan,

Thank you for responding. I currently have global table permissions for the two related tables and a lookup column that creates my 1:N relationship.

The issue is I can't access related table fields in the form wizard. Unlike when you make a custom view, you can access all related fields.

Thank you,
Nicole

Was this reply helpful? Yes No