Look Up multiple columns from a table in data verse.

[KrishR]

Hello Power Users,

I've used data verse tables to build apps. But, I'm new to the data verse and this table relationships. I'm stuck at handling a situation. I'm trying to build two look up columns from a table.

Columns in Table A:  Request ID; RequestName; Date

Columns in Table B:   ItemID; Request ID(Lookup column from Table A); RequestName (LookUp column from Table B); Stage

How do I set up two look up columns in Table B to lookup from table A?

Thanks in advance! 

[Amik]

@KrishR are you building a Model Driven App or Canvas App?

[KrishR]

Hi @Amik 

I'm planning to have a Model driven app. With this question I had to question myself, what is the best approach? Is there any different approach for Canvas or model driven. Can you please help me with some info.

Based on the suggestions I can choose one.

Thank you so much! 

[parvezghumra]

@KrishR Please refer to my suggestion on a previous similar thread here

[Amik]

Hi @KrishR ,

The differences between a Model Driven App and a Canvas App is too broad a topic for a Forum post. There are a number of materials online to help you identify which one works best for you.

In my experience, if you are already working with Dynamics 365 or if your Business Process is simple and well defined, you need an app up and running quickly, and the only data source you will be working with is Dataverse, than I would recommend building a Model Driven App.

If you can envision complexity and unknown requirements, as well as the need for multiple data sources, then I would recommend building a Canvas App.

The way to relate one Table to another Table with different relationship cardinality (one-to-many, many-to-many etc), as well as manage relationship behaviours remains the same in Dataverse irrespective of which App you choose.

However, the way that relationship is read is fundamentally different. With a Model Driven App you leverage Forms and Views, whereas in a Canvas App you will need to use Power FX functions.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan