Can someone help me create a flow?
User fills out a Microsoft Form, choosing (one of the form questions) who should approve his request.
Flow sends the form information to SharePoint and matches the name of the chosen approver with the correct e-mail address for that person.
Flow sends e-mail to chosen approver, which also contains more info from the Form.
The approver makes his decision in Flow, which is sent to SharePoint.
Flow sends all SharePoint info for this request to the From address from the original e-mail sent to the approver.
If approver denies approval, e-mail sent to user saying so.
Couple of questions:
Form Fills Out
SharePoint save all details of form (useremail, form details)
Is list record created using the form details? Will the form have user email as well?
SharePoint Match Approver Email
Is approver name/email held in a different list in SharePoint?
Send Email with Form details to Approver
If Approved, find the user email address and send reply.
Which List user email address is held? (See step 2)
Will create a list for form details
Form will not contain approver e-mails, just names
No list for approver name/e-mails yet
Is that what I need...a SharePoint list of names and e-mails...sort of like a database, with the approver name as the Key?
Is this something new you planning to design? Have a look on your requirements and find out what's the best for your business. To help you further I need to know where the approvers are stored.
Yes, it's new.
The approvers aren't stored anywhere yet. Do I need to create a SharePoint list of names and e-mail addresses?
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.