cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Approval from forms

I am trying flow today for work and I am really struggling with the approval process. We create a Microsoft form for passenger complaints and then we want the form response and a pdf with supporting documents being sent to a manger for approval. Once the manger decides I am trying get his response recorded in excel where we collect our form results.Right now we're manually attaching files and sending him an email every time we receive a response and then based of his approval we edit the spreadsheet with yes or no. Was wondering if this could be automated with Microsoft Flow

2 REPLIES 2
Community Support Team
Community Support Team

Re: Approval from forms

Hi @Anonymous,

 

Where are the pdf with supporting documents and the excel saved in.

 

I would offer you the workaround if your pdf with supporting documents and the excel are saved in your onedrive for business.

 

If your pdf with supporting documents and the excel are saved in your onedrive for business, please refe rto screenshot below to create the flow:

Capture1.PNGCapture2.PNG

 

 

 

Best regards,

Alice

 

 

Anonymous
Not applicable

Re: Approval from forms

Thanks alot for the help! However the supporting documents is different for each response. They supporting document is filed according to the respone.

 

Currently the form asks for the reservation number from each passenger. Then we collect all their supporting documents and upload it one drive in one file with the same reservation number.

 

For example imagine Bob had an incident with our company, his ticket number is XXXXX. We collect information about his incident through the form and any supporting documents is filed in a folder on one drive in one file titled according to the ticket number so in this case XXXXX.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,477)