Unanswered

Automatically assign key pairs from two tables

(0) Share

Report

Posted on by guekjcow

I want to develop an information form using a Canvas app and Dataverse. There the user should enter his information in predefined fields but also have the possibility to give own information. This is to be realized via a table, where the user can add columns as desired. Since it is a 1:n relation between the information form and the additional questions, the questions should be stored in a separate Dataverse table. So that the questions in the new table are automatically assigned to the information form with a key when the user enters his own information.

My question now is: How can I automatically map the ID of the respective questions to the ID of the information form?

Thanks in advance!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @guekjcow ，

I see a duplicate threat:

Automatically assign key pairs from two tables - Power Platform Community (microsoft.com)

Please do not post duplicate topics in a short period of time.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Like (0)

Report
Copy link

Link copied!

Hi @guekjcow ,

Instead of adding columns to another table and trying to relate this to the first table (this is not possible) I would flatten this model to allow you to add "N" questions and answers for the person and have them all relate to the original record information through the 1:N relationship. Below is an example of how I would structure this. Now you will not be able to control the type of field on these as the question and answer would both be Text...

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No