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.
