Home >Tips >Power Automate >E-mail input kalmstrom.com site map icon Site map  

Get E-mail Input on New Items

A SharePoint Flows tutorial by Peter Kalmström

Microsoft Flow iconWhen you need input on new list items from people outside the tenant, you can let a flow send an e-mail with an item description and "vote" buttons. The flow can also send the votes back to the list.

In this article Peter Kalmström, kalmstrom.com CEO and Systems Designer, shows how an e-mail input flow can be used for approvals from a legal department that not yet use SharePoint.

Each time a new project is added to a "Projects" list, and e-mail with three options is sent to the legal department automatically. The responsible person at the legal department clicks on the "Approved", "Rejected" or "Need More Info" button, and that input is sent back to a "Legal approval" column in the Projects list.

 SharePoint flow e-mail options

Flow steps

  1. Create a blank flow and use the trigger SharePoint - when an item is created' for the Projects list.
  2. Add the action Office 365 Outlook, send email with options.
  3. Fill out the e-mail details:
    • Receiver e-mail address.
    • Subject: general text, for example New project for approval + the dynamic content Project Title.
    • Fill out the options with comma between them: Approved, Rejected, Need More Info.
    • Add the dynamic content Project Description in the body.
  4. Add the action 'SharePoint, update item? for the Projects list.
  5. At Id, add the dynamic content ID.
  6. At Legal Approval add the dynamic content SelectedOption. That will put the response from the Legal department in the SharePoint list.
  7. Remove all the default options so that all other fields are blank.
  8. Save and test the flow.
 



Learn more






back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved