Microsoft Flow Approval Workflow With Excel Online

17


What’s up everyone!

Today I am creating this Microsoft Flow Approval Workflow video in response to a request from Cesar Itriago here on YouTube where he asked me to make a video on Flow Modern Approvals using the Excel Online service.

So, In the video I make a Flow that has an approval using two different tables in Excel to achieve this solution.

If you enjoy this video, Please Like it and Subscribe to the channel.

To download this flow and import it into your environment, download it here: https://1drv.ms/u/s!AnFATp1ms-B-jK4OdQxpj1Cg-KQayw

For More information around Approvals, see our Documentation on the topic: https://preview.flow.microsoft.com/en-us/documentation/sequential-modern-approvals/

To see more cool stuff you can do with Approvals, check out the session from Ignite 2017 from Merwan Hade: https://myignite.microsoft.com/sessions/55718

To Follow Me on Twitter, so you can take part in more stuff like this Go Here: http://twitter.com/pnwadventureguy

To Visit the Microsoft Flow Community, to ask questions and connect with other fans: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity

Talk to you later friends!

Checkout Jon Levesque’s Channel

Choose your Reaction!
  • Thanks so much!!!! You are the best!!!!! I´m very thanksful for your Help. Ty for your fast answer and the great video!!!!

  • Hi, thanks for this wonderful tutorial.

    One question please, in the last step (left side) – send an email I cannot choose data from the excel file. I tried to duplicate your step manually and by import the flow but no luck.

    thanks in advanced.

    Nir

  • Do I need to change 'Send for Approval' column from 'Yes' to 'Progress' in SharePoint List to avoid duplicate sending for approval request ?
    Currently, duplicate the approval request per hour

  • Would love to see this process go from estimate to purchase order to invoice!!!

  • Is it possible to export Microsoft Forms replies to an excel online, and then import to a Word Template (such as a contract)? Some people suggeted using Mail Merge, is it the only way? I would like to use Microsoft forms replies to fill a Word online ( in Sharepoint) and the start a Microsoft Flow for the approval of it.

  • Hello, I was wondering how you manage security on this spreadsheet. Is there anything preventing someone from cutting their row from the Proposal sheet and pasting it into the Approved sheet? The last I checked, I thought that permissions for One Drive Excel files were set at the file-level rather than the worksheet level. I worry that people would tamper with this and mark their requests as approved without going through the workflow. Thanks

  • Hi Jon love your videos. I have a question, is it possible to creat a flow for subtracting a column with a total from another?

  • Hi Jon! Great Tutorial and im already using it for some tests. My next goal is to create a task on planner with the necessary items. Any way to do that? Regards,

  • Hi Jon. I’m trying to replicate this awesome flow. However, there is only one step I seem to be doing wrong. I can’t get the new row to add to the “Approved” table. Could you please help me out. It would be extremely useful for me. Thanks in advance

  • Could you pls explain how you add the details (first name, last name etc..) in the "Start an approval" section?

  • Very nice video. I did exactly as you mentioned using Excel business (Get a row) but when I am adding 3-4 row items for approval at same time, flow is picking only the first row and waiting until and unless that is approved/rejected. How to edit the flow to trigger separate approval emails for each of the row item and track it independently?

  • Hi, I have a spreadsheet of some 500 lines which I want to route for approval where the approval can reject and approve at a row level using Flows / List or Sharepoint

  • This is great! But is there a way I could use this function on multiple Excel spreadsheets using the Sharepoint "When files are create or modified in a folder" ? I need to dynamically grab each file in a folder and push the updates into a single spreadheet. I can obviously do this with a VB script, but would be amazing if i could do this totally with flow. I've tried grabbing the values dynamically and pushing them into the "Get Row" function for Excel, but it throws errors. Any ideas?

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.