Hello all,
I have developed a PowerApp which exports data to SharePoint lists. These SharePoint lists will be added to eventually making them greater than 2000 rows. I have a few questions about delegation.
1. Will I have issues adding new rows to a list which is greater than 2000 rows? (I think not but want to confirm)
2. If I use a delegable prefilter such as the example below (from a different community post) will I have issues with CRUD operations?
With({_prefilter: Filter(dataList, Status="Open" && Created > Date(2021, 1, 1))},
Search(_prefilter, TextSearch.Text, "Column1", "Column2")
)
3. How can I overcome CRUD operation issues? Ideally I want to prefilter so I get the last 2000 rows (last 2000 by date would suffice), search within the 2000 lines to find specified row(s), and update these rows within the 2000 rows. Will I come into issues when patching back to the SharePoint list to update? Any example code would be appreciated.
SharePoint maintenance will be performed to reduce number of rows but historic data will need to be kept for data analysis reasons so performing maintenance every 2000 rows isn't an option....more like every 10,000 rows.
Thank you in advance
Rob

Report
All responses (
Answers (