Hi All,
I am working on expense report app, user can submit up to 50 expenses in one request. So the user uploads the expense excel which the is read and dumped in (child list)SharePoint list using power automate and now user can submit new expense request(master list) along with other fields it has gallery where we are auto populating the expenses uploaded in child list using a unique code from step 1.
So I have an expense list which has child item of expenses and I have one list which has all master item requests.
We are expecting 50 requests per day which can have up to 50 expenses per request, so
50(everyday)x50(per request)x30(days)x12(1year) =900,000 entries in child list
I know delegate concept and I will also do indexing of columns, at any given point if any old item is viewed it would get maximum of 50 entries from child list using some unique code.
Lets consider the app should work fine for 10 years, now that becomes
900,000 x10 = 9,000,000
Do you think this is good design and would work smoothly ? We could do archiving but the data is needed for auditing and also data cannot be deleted.
No budget for CDS so it has to SharePoint.
Please guide.
@WarrenBelz @RandyHayes @mdevaney @eka24
