Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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


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.

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 :
Subscribe :


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


Table 2


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?

Frequent Visitor

@driekesYes you can use it

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,634)