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.
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
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.
|id||vlaccnummer||laatste update op|
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.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.