No video

Approve a Document in Microsoft Forms

Watch this video to learn how to approve a document that has been submitted in Microsoft Forms. First, we will show you how to create a form in Microsoft Forms for a user to upload a file. Next, we will show you where that file is stored in OneDrive. Following that, we will show how to use Microsoft Power Automate to create a flow to send an email to a specific email address to approve or reject the document. Once the document is approved or rejected, we will then show how to automatically move the file to an approved or rejected folder in OneDrive. This video is great for anyone wanting to understand how to take a file that has been uploaded in a form in Microsoft Forms and approve that document.
📥 Visit our blog for many samples of Office files at
www.myexcelonline.com/blog/ho... ‎
⌚ Time Stamps:
00:00 - Introduction to Approve a Document in Microsoft Forms
00:29: Create an Upload File Form in Microsoft Forms
02:05 - Find Uploaded File in Microsoft OneDrive
02:38 - Microsoft Power Automate Flow Description
03:52 - Create a Flow Trigger in Microsoft Power Automate
05:45- Add Approval Step in Flow in Microsoft Power Automate
06:27 - Add Condition in Flow in Microsoft Power Automate
09:05 - Review and Test Flow in Microsoft Power Automate
11:24 - Conclusion for Approve a Document in Microsoft Forms
------------
👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...
Join Now ► www.myexcelonline.com/107-42....
📚 Download Our Free 101 Excel Tips & Tricks E-Book: www.myexcelonline.com/101-exc...
💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: www.myexcelonline.com/107-125...
🔥 OUR BEST EXCEL RESOURCES 🔥
Get All Our Excel E-Books: go.myexcelonline.com/101-exce...
101 Most Popular Formulas Paperback on Amazon: www.amazon.com/dp/1700300911
101 Ready To Use Macros Paperback on Amazon: www.amazon.com/dp/1700729675
101 Best Excel Tips & Tricks Paperback on Amazon: www.amazon.com/Best-Excel-Tip...
👷 Excel Consulting Services: www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: / @myexcelonline
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MicrosoftForms #Office365 #documentapproval #MyExcelOnline

Пікірлер: 33

  • @user-sn2ps7hl4e
    @user-sn2ps7hl4e Жыл бұрын

    You made this easy!

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Oh, thanks! Glad we could help you out!

  • @ammarabbasi
    @ammarabbasi Жыл бұрын

    Thank you.

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    You're welcome!

  • @martinchochiov
    @martinchochiov Жыл бұрын

    BTW: this is excellent.

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Thank you!

  • @XcelWTony
    @XcelWTony Жыл бұрын

    Thanks for the tutorial. it was very insightful. however, what flow can you add that the document is opened and every information is correct before approval is given

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Hi. Thanks for the comment. I think that would be a part of your internal process. Maybe don't let people approve a document unless they check the document first? I am not sure there is a way to see if a document has been checked unless you have certain things on the document that you specifically want to check. If you do have specifics, then you could create more steps in the flow to check for that first. We have consulting services if you would like further help. Just visit www.myexcelonline.com/microsoft-excel-consulting-services/

  • @officialpatrick1
    @officialpatrick1 Жыл бұрын

    Thanks for the tutorial. Very helpful. I didn't see where the approver email shows the file to be approved. Was there a link in the email or does it just have the approval buttons?

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Thanks for the question. It just has the approve button.

  • @np5352
    @np5352 Жыл бұрын

    Hi That was excellent. I want to add a response to the form in my approval ,how do i do it ?Thanks !

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Thanks for watching. It would be another step after the approval step in Power Automate.

  • @ycq824
    @ycq82411 ай бұрын

    Thanks for the tutorial. May i ask how can i automate the flow without clicking the "test"?

  • @MyExcelOnline

    @MyExcelOnline

    11 ай бұрын

    Great question! In the edit flow mode, click the three dots besides recurrence at the top. You should be able to edit the schedule there.

  • @aanchaljoshi9803
    @aanchaljoshi9803 Жыл бұрын

    Hi, I am working on a project where I have to create a form to gather employee's IT device information. Than, the form answers should navigate to the program Manager for approval and the approvals should be save into an excel sheet which will be operated by IT manager. Please guide me.

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    It might be better if you use a different platform for this given your requirements.

  • @tungpangkhien546
    @tungpangkhien546 Жыл бұрын

    I noticed MS TEAM Approval App run the similar but easier setup

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Hi. Thanks for the comment. Yes, there is often more than one way to accomplish an objective. Glad that one works for you!

  • @rezasadr1698
    @rezasadr16983 ай бұрын

    Very helpful. How about when the forms have more than one question? For example, if I want approval for a new response (with more than one questions and uploaded file). I'll try to use Response ID

  • @MyExcelOnline

    @MyExcelOnline

    3 ай бұрын

    Thanks for the question! That process would be a little more involved. We do offer consulting services here for custom solutions if you are interested: www.myexcelonline.com/microsoft-excel-consulting-services/

  • @MyExcelOnline

    @MyExcelOnline

    3 ай бұрын

    Glad you liked it! Your request would be a little more involved. We offer consulting services for custom solutions here if you would like some help: www.myexcelonline.com/microsoft-excel-consulting-services/

  • @championshipbeltreviews
    @championshipbeltreviews Жыл бұрын

    I am not getting the emails for approval. I checked and my name/email address is in the assigned to section of the workflow. What could it be?

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Hi. Thanks for the question! it depends on how you set up the flow. If you are having trouble you could try to create a Microsoft Business account instead of a home one. Hope that helps!

  • @martinchochiov
    @martinchochiov Жыл бұрын

    Is there a way to add the uploaded document to the approval request so that the approver can review?

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Yes, there should be. Just check the options in the approval step. Or you can add another step. Maybe an upload to One Drive if you can't attach it in the approval step?

  • @kp7688
    @kp7688Ай бұрын

    How can I create a form approval for dynamic approver list?

  • @MyExcelOnline

    @MyExcelOnline

    Ай бұрын

    Great question! It'd be too much for me to answer here, but please feel free to contact our consulting services to help! www.myexcelonline.com/microsoft-excel-consulting-services/

  • @zerogravitychannel2650
    @zerogravitychannel2650 Жыл бұрын

    I am working with forms and I want to get one person to approve when the user has filled a form. Typically thing is, once this has been submitted by a user then get a person to approve their request.

  • @MyExcelOnline

    @MyExcelOnline

    Жыл бұрын

    Are you saying you would like a double approval? First for filing it out and then a second one?

  • @linhinson

    @linhinson

    Жыл бұрын

    Yes I would like to know how a second approver can be added to the flow

  • @MyExcelOnline

    @MyExcelOnline

    7 ай бұрын

    Maybe try using Power Apps instead.

  • @shlomobachar4123
    @shlomobachar41237 ай бұрын

    I am trying something similar (and cannot succeed): We are conducting “ccb configuration change board” meetings where board members should reply or give their decisions to a some change in a product. I want to automate this by mail. I want to send a file (where I describe the change) to specific mail list and want to collect their approval and any requests or references they have. I want to collect these replies in one place or document.

  • @MyExcelOnline

    @MyExcelOnline

    7 ай бұрын

    A combination of Forms and Power Automate may help you. Also, we offer consulting services if you need help with a specific project. Check out www.myexcelonline.com/microsoft-excel-consulting-services/