Creating a 1:1 relationship in Dataverse

(0) Share

Report

Posted on by LA-30040116-0

I have a table containing 40 questions and would like to distribute them into 3 separate tables.

All users need to answer Q1-18. Q19 is a choice column type, if a user selects Choice A, they should be presented with Questions 20-29, if they select Choice B, they should receive Questions 30-40.
Could you kindly guide me on how to achieve this using a custom model-driven app?

Categories:

All responses (6)

Answers (0)

LA-30040116-0 27 on at

Like (0)

Report

Creating a 1:1 relationship in Dataverse

@Vahid Samimi
I value your input—thanks!

Using PA, I think there will be a delay and might need refreshing the form could affect the user experience.
I'm really interested in the classic workflow approach—would you mind showing me in detail on how to create a record in the lookup table (Q20-29 or Q30-40), link it to the main table, and also prevent record duplication?
Vahid Samimi 41 on at

Like (0)

Report

Creating a 1:1 relationship in Dataverse

Sorry for the misunderstanding. You can use a business rule just for hiding and showing, or set a value based on the existing value. But if you would like to create a record dynamically, you have to use Power Automate or a Classic workflow
LA-30040116-0 27 on at

Like (0)

Report

Creating a 1:1 relationship in Dataverse

Hi @Vahid Samimi

I appreciate you taking the time to reply to my query.

Would you mind sharing more details on how to create a record using the business rule.

3.use business rule:
When a user selects Choice A, create a record in Table A and link it to the Main Table.
When a user selects Choice B, create a record in Table B and link it to the Main Table.
Hide/show related questions dynamically based on the selection.
Suggested answer

Vahid Samimi 41 on at

Like (0)

Report

Creating a 1:1 relationship in Dataverse

1. create 3 tables
Main Table: Stores Q1-18 and Q19 (choice column).

Table A: Stores Q20-29 (for users selecting Choice A).

Table B: Stores Q30-40 (for users selecting Choice B).

2. then Add a lookup column in the Main Table pointing to Table A.

Add a lookup column in the Main Table pointing to Table B.

Ensure each record in the Main Table has only one corresponding record in either Table A or Table B.
3.use business rule:
When a user selects Choice A, create a record in Table A and link it to the Main Table.

When a user selects Choice B, create a record in Table B and link it to the Main Table.

Hide/show related questions dynamically based on the selection.
LA-30040116-0 27 on at

Like (0)

Report

Creating a 1:1 relationship in Dataverse

Thank you for your response!

I’d prefer to use a custom Model-Driven App with a 1:1 relationship, if possible.

I’ve just updated the post to clarify my question.
Suggested answer

ankit_singhal 553 Super User 2025 Season 1 on at

Like (0)

Report

Conditional Question Assignment in Model-Driven Apps

You can use customer survey and apply the expression for hide/show the questions. When any user submit the customer survey then response will be save in dataverse automatically.

If you want this in model driven, then create a form and created columns for your question answer. you can write the business rule for JavaScript for hide/show the column. It will trigger on the change of column value.

Note: Please Mark Verified, if it is useful for you.

Community site session details

Creating a 1:1 relationship in Dataverse

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Apps - Microsoft Dataverse

Featured topics

Product updates

Community site session details

Creating a 1:1 relationship in Dataverse

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Apps - Microsoft Dataverse

Featured topics

Product updates