cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Memorable Member
Memorable Member

Working with large SharePoint lists

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 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@jinivthakkar 

Is this a duplicate post?  It seems like this post.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

2 REPLIES 2
Super User III
Super User III

@jinivthakkar 

Is this a duplicate post?  It seems like this post.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Yes, this post was marked as spam I dont know by someone so was removed so I had to post another question.
This is answered to the other post by you only.
Thanks !

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (43,551)