Dataverse and Model driven app --> solution for our needs?

[driekes]

Hi,

I have 4 Excel sheets that I want to import in Dataverse. That would be the data source for a Model Driven app. Some tables contain 40.000 rows/records. I want to link them like in SQL with a foreign key or something. I don't think I can use a Lookup Datatype field. It is not feasable to couple the records (after creating a 1-N relation between tables) manualy.

Maybe this approach is not something we can use for our needs?

Thank you for your insights.

[rampprakash]

Hello @driekes,

You can follow below steps

1. First try Importing Lookup realted Record first(make sure the Name is not duplicate)

2. Try importing the Whole sheet which contains Related Records(Lookup) 

then try converting to csv and import it. Let me know if you have any queries

Please mark as Answer if it is helpful and provide Kudos

Blog : https://microsoftcrmtechie.blogspot.com
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

[driekes]

Hi @rampprakash  thanks for your reply . I do not understand step 1 and 2. Actually the files are already .csv files.

Below an exerpt from the 2 files. The column with name "ID" in table 1 shoud be "Primary key". The column in table2 with name "werk" should be "foreign key". I can create a form or view in an app with a Lookup function in Table 1 to Table2. But as far as I know that lookup field wil let me select like 40.000 records.

May I just don't understand your steps as I am a Noob.

Table 1

id	vlaccnummer	laatste update op
0	1046713	14/07/2020
1	10161452	22/06/2020
4	67218	30/04/2020
5	67223	12/11/2014

Table 2

id	werk	materiaalsoort
1	0	D
2	1	D
3	4	P
4	139	D

[kulkarni_anuj]

You can also use Custom pages in model application Which let you use different data connector to your Model Driven Application

In the screen shot you can see customs page that I created and used an share point connector  as a data-source you can also use Excel or SQL database

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[driekes]

Hi @kulkarni_anuj ,

Using Custom Pages, can we use an Azure SQL Database as datasource?

[kulkarni_anuj]

@driekesYes you can use it