Hi,
I need to create a one to many relationship, between table "Quizzes" and "Questions".
Both tables have been imported through a dataflow.
They both use "Name" autonumber as the primary key. However, the table structure is the following:
Quizzes:
Quiz_id | Date | Order |
1 | ||
2 |
Questions:
Question_id | Quiz_id | |
1 | 1 | |
2 | 1 | |
3 | 2 | |
4 | 2 |
I want to relate Quizzes[Quiz_id] to Questions[Quiz_id]
How to do this?
Hi @WebPortal
By default, it looks for primary column (Name). It appears that you may not have any value in Name column. If I were you, I'd use a business rule or flow to copy quiz Id value to be set as the Name.
The following post may be of help:
Solved: Re: Dataverse lookups are blank - Power Platform Community (microsoft.com)
Please press the like button to support my efforts. If it helps resolve your query then please also accept it as a solution so that it can also help other people with similar issues.
Kind regards
Gulshan
Thanks, but that returns an empty result...
How do I specify that I want the Quiz_id columns from both tables to establish the relationship?
Hi @WebPortal
You can import the Quiz table first.
Then you can have a lookup column on Questions table pointing to the Quiz table and having the 'Name' (Primary column) of the Quiz record as plain text. When you import and define the schema, the system should automatically connect questions with their parent quiz record.
I hope this information helps. Please give it a Thumbs Up if you appreciate my efforts. If it helps resolve your query then please also accept it as a solution.
Kind regards
Gulshan
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2