You’re offline. This is a read only version of the page.
I work in Procurement and want to utilize Microsoft Lists with Power Automate to be able to create a "bulk update column" to the list and am looking for advice or other examples / videos how it is done.
Here is some context: We have a list of 100,000 parts with a particular sub category classification we'll call 'Taxonomy Code' and we need the capability for our category team to be able to review and make a mass update request across many parts to correct and reclassify the Taxonomy Code attribute of the part. When category managers make change requests, they need to be reviewed and approved, ideally through a "bulk update column" where they select the correct/new 'Taxonomy Code' for that particular part and Power Automate will create daily batch emails (i.e. grouping all part change requests together instead of individual emails) to the approver for review. After approval, Power Automate should directly update the list by updating the main column and clearing out the bulk update column, or if rejected, it leaves the original main column unchanged and sends an email back to the requester that it's been rejected.
You could build a power app for it, or you could just use a model-driven app for it. MDA will be very similar to that SharePoint List experience, and very easy to build in a hurry.
Hi, Thanks for the feedback. One question I have though is what about the user interface? I was thinking of Lists since it could be used as a database and is user friendly like Excel so end users could easily make their own updates, but per your feedback, it is not the best solution for the database/query side. So in this case, I should use Dataverse as the database, but build a PowerApp user interface on top of this with Power Automate to update the data in Dataverse?
My first advice would be, "don't use Lists for this". List is just a SharePoint List, which is not really designed for large scale interaction. It does not paginate particularly easily, it is almost impossible to query if you have over 10k rows, and it has no native bulk update operation.
Instead, I would recommend using Dataverse, or if you've got access to custom dev resources, maybe your own Azure SQL or Azure Storage Account. Any of these will give you much better querying, pagination, and bulk operation controls for your 100K row needs.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
