In Power Automate you can set up a flow to monitor your inbox and automatically save attachments that have been emailed to you. This post will show you how to create this flow and have the attachments saved to a SharePoint folder.
Display full email message in an approval request
Perhaps you want to initiate an approval request based on an email received. You can insert the body of that email within the approval request, so the approver can see the full message while they action it. Here's how you can do this.
Trigger a flow based on words used in the subject of an email (at least one word from a range used)
When using the Outlook Power Automate trigger, When a new email arrives, you can apply a filter based on the email subject. Rather than just a single string as your Subject Filter, you may want to apply a filter that will work on multiple different words. The advanced settings for the trigger allow you to set these conditions.
Email a link to a file that has been uploaded via Microsoft Forms submission
There is a question type in Microsoft Forms that allows the responder to upload a file. This file is automatically uploaded to OneDrive. With Power Automate, you can build a flow that will extract the responses to questions in a form, including a link to file attachments, then send it in an email.
Power Automate available in Excel Online
Another new feature to come out of Microsoft Ignite 2022- the ability to use Power Automate within Excel Online. This allows you to search for flows that can assist you with data entry or run Office Scripts without leaving Excel. Screenshot of Power Automate button in Excel Online You will see the Power Automate button … Continue reading Power Automate available in Excel Online
Power Automate: Format your data with examples
Format your data with examples is a feature available in the cloud flow builder of Power Automate. It simplifies flow building experience by reducing the need for you to write your own expressions from scratch. If you want to change how data is returned in your flow, typically you would need to write an expression- … Continue reading Power Automate: Format your data with examples
Microsoft Ignite 2022: Power Platform & Microsoft Teams announcement highlights
At last week's Microsoft Ignite conference, there were some big announcements made for new features coming across Power Platform, Microsoft 365, Dynamics 365, Azure, AI and more. In this post I'll highlight some of the announcements across Power Platform and Microsoft Teams that were personal favourites of mine.
You describe it, AI builds it: trying out the new way to create cloud flows
At Microsoft Ignite (October 2022), Microsoft introduced a new feature coming to Power Automate: "You describe it, AI builds it". This feature aims to make flow building even easier, by allowing you to simply type a description of a flow you want to build, and the flow will be automatically generated for you. Screenshot of … Continue reading You describe it, AI builds it: trying out the new way to create cloud flows
Generate documents with information collected from Microsoft Forms
By using the Word Online (Business) connector for Power Automate, you can create documents using the information collected within a Microsoft Form response. Beginning with a Microsoft Word template, you can use the connector in a flow to take inputs from a form submission, populate them in a template, and save the document.
Use Power Automate to add Microsoft Forms submissions to a Power BI dataset
If you're using Microsoft Forms you can create a dataset in Power BI to collect the feedback or information from form submissions. This can then be used in your reports and dashboards for your reporting needs. Using Power Automate, each time someone submits a response to your Form, the data will be stored a a … Continue reading Use Power Automate to add Microsoft Forms submissions to a Power BI dataset
