Hi @v-xida-msft ,
Thanks for the response, good to know there is no hardlimit on rows inserted into CDS entities.
I am currently doing a POC in powerapps by replicating one of the model we built in MDS. This consists of one master entity and 3 related entities having > 3 million rows as a lookup columns in the master entity. Below are issues i have faced till now.
When trying to load > 3 million rows in child entities i am receiving an error that cannot load more than 500000 rows. By your reply i think this is because i am using a trial subscription and limited by space.
I loaded the data eventually by provide a range (1 - 200000) but when i open that in "Open in Excel " i can see only 5000 rows. Many be this also could be due to limitation it might have loaded only those many rows i think.
If i get this right by getting more storage space, i need to use the child tables > 3 million rows as a lookup in master table. Which means user has to only select or paste values which are in the list. However the only option is to search through the list and select the value. Earlier when i posted this issue got a reply to use functions to lookup the values instead of having users type in, but i cannot seem to use functions in model driven apps. Users will be loading data in bulk.
So is my scenario not supported in model-driven apps?
In my master entity to ensure there is no duplicate rows inserted i have a combination of 6 columns which form unique key which is not supported as a composite unique key in CDS Entity as it only accepts 5 that too should be within a certain lenght. In this case how can i ensure uniqueness of a record with my criteria. In MDS there is a business rule in which we can combine any number of columns to check for duplicate rows. Please let me know if there is any workaround for this.
(Question)I also need to create a custom business rules to check for overlapping dates, can i achieve this. In MDS we wrote a scalar function which can be used as business rule for this scenario. I read about developer documentation of powerapps that we have create a dll.. etc will this work for model-driven app.
Overall we will create base entities and business rules. then create an model-driven app on top of that so users can bulk enter the data abiding by those business rules. We usually would want to store our metadata solution in powerapps.
Also can powerapps be used as an MDS replacement.
