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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

ankit_singhal 618 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
LA-30040116-0 52 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Vahid Samimi 60 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
LA-30040116-0 52 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Vahid Samimi 60 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LA-30040116-0 52 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No