Power Platform Community Forum Thread Details

Good morning all,

I was wondering if there was a way to send an entire SharePoint list for approval in one approval request.

Example:

Employee adds an item to a SharePoint list 9 times during the week.

3 more employees do the same.

Instead of seeing 27 individual requests, there would be a single timed approval request on Monday at 9am to approve the entire list, and then move the approved items to a new list.

Is this possible? I can do it for individual items, but I would really like to avoid 27 individual requests.

Thoughts?

Thanks

Derrick

Categories:

Using flows

Hi!

Following your example, let's assume you implement a single scheduled flow and perform a 'Get items' every Monday at 9 AM and get 27 items.

Now you can send a single approval, so your flow can wait for somebody to accept it, and if so execute an 'Apply to each' assigning as it input the initial 'Get items' output. This means you will iterate over the 27 items obteined when your flow started execution. Now inside your 'Apply to each' you can add a 'Create item' in a second sharepoint list and 'Delete item' from the original list.

So even if somebody added new items after Monday 9 AM, these new items will not be processed by the 'Apply to each'

Now, the point is, by using a single 'Approval' for 27 items you cannot approve let's say approve 15 items and reject 12. You can just approve all or reject all. If you need an to approve each item individually in a single Approval notification, you will probably need to design your own adaptive card. If so, great stuff here:

https://www.bythedevs.com/post/multi-line-approvals-with-adaptive-cards-outlook-and-power-automate

Hope this helps