One Submit form from 2 different tables columns

(0) Share

Report

Posted on by AwwGregg

Hi I hope I explain myself well.

I am attempting to create a compliance app for fire alarm test data and emergency lighting etc.

Currently I have 2 tables set up in Dataverse.

1st table is an options table. For example operatives names, locations etc.

2nd table is the fire alarm test table.

The issue I am having is that I want to be able to drag data from different tables into one submittable form. I have setup the relationship between tables but I am finding tricky setting up the drop down option linking from two dataverse tables into one form.

Am I missing coding on the drop-down ie lookup( ???

Please can someone help.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AwwGregg ,

You are looking for the "Lookup" field here. Basically if you add a Lookup field to Options table on the Alarm Test table then you will be able to add that field to your form and it will give you the ability to search for that record and select the appropriate Option value on the Fire Alarm Test table.

If this is an "N:N" relationship then this will not work above... In that case the steps are a bit different. Please let me know if this is what you were looking for and it is a 1:N.

Was this reply helpful? Yes No
ndlovusphe 8 on at

Like (0)

Report
Copy link

Link copied!

How many lookups can you create in one Table?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @ndlovusphe ,

See @ChrisPiasecki reply here to that question (Solved: Davaverse lookups increased to 20? - Power Platform Community (microsoft.com)). As far as I know there is no hard limit per table on number of lookup columns.

Was this reply helpful? Yes No