web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Can You Create A Bulk ...
Power Automate
Unanswered

Can You Create A Bulk Approval Containing Multiple Excel Entries?

(0) ShareShare
ReportReport
Posted on by 13

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

Categories:
I have the same question (0)
  • Shujaath_Khan Profile Picture
    1,111 Super User 2024 Season 1 on at

    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

    Shujaath_Khan_0-1656684336660.png

     

    Step 2 : Create a scheduled flow as per snap below

    Shujaath_Khan_0-1656685311403.pngShujaath_Khan_1-1656685326956.png

     

    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 ''

    Shujaath_Khan_2-1656684470885.png

    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

    Shujaath_Khan_3-1656684536995.png

    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.

  • rych Profile Picture
    13 on at

    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 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard