cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
driekes
Helper I
Helper I

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

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.

5 REPLIES 5
rampprakash
Super User
Super User

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

 

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

 

idvlaccnummerlaatste update op
0104671314/07/2020
11016145222/06/2020
46721830/04/2020
56722312/11/2014

 

Table 2

 

idwerkmateriaalsoort
10D
21D
34P
4139D
kulkarni_anuj
Frequent Visitor

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.

Hi @kulkarni_anuj ,

 

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

kulkarni_anuj
Frequent Visitor

@driekesYes you can use it

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,137)