Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Automatically assign k...
Power Apps - Microsoft Dataverse
Unanswered

Automatically assign key pairs from two tables

(0) ShareShare
ReportReport
Posted on by guekjcow 2
Hi all,

 

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:
Tables
Microsoft Dataverse
Entities
  • Drew Poggemann Profile Picture
    Drew Poggemann 9,278 Most Valuable Professional on at
    Re: Automatically assign key pairs from two tables

    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... 

    Screen Shot 2021-11-04 at 4.36.57 AM.png

     

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


    Thanks,


    Drew

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Automatically assign key pairs from two tables

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans