Unanswered

Can You Create A Bulk Approval Containing Multiple Excel Entries?

(0) Share

Report

Posted on by rych

As far as I know, creating an Approval from data in Excel are usually done per row in a table. I am wondering if there is a way to create an Approval for multiple row entries and have the Approval process done by bulk. Thank you

All responses (2)

Answers (0)

rych 13 on at

Like (0)

Report

Re: Can You Create A Bulk Approval Containing Multiple Excel Entries?

Thank you for giving me an idea/option to go about this. However, I am currently doing a workaround using another sequence, I hope I get this done :).

Your response is very much appreciated 🙂
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (1)

Report
Re: Can You Create A Bulk Approval Containing Multiple Excel Entries?

Hi @rych

If you can turn-on/off flow once approvals are done you can try below flow
We have run flow independently for every row we've in excel as every approval would wait till approval is complete

Step 1 : In excel we need unqiue column like Serial number and Status column that would be used to filter

Step 2 : Create a scheduled flow as per snap below

Condition :
length(outputs('List_rows_present_in_a_table')?['body/value']) > 0

Step 3: List rows would be specific
it would pick only first record and with filter where status ne ''
Step 4: To get only first record from list of rows

first(outputs('List_rows_present_in_a_table')?['body/value'])['Sl']

Step 5 : Update as ongoing if approval has started ahead of starting approval
Step 6: Once you've the response update the outcome back to column so it can be ignored for next pick

Step 7: Once all approvals are completed you can turn-off your flow. This tried as workaround.🙂

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.