If you are building a Power App you might want to automate some tasks or processes within your app- such as sending an email notification, creating a document or even updating a database record based on an input from the app. How can you do that without leaving your app and switching to another tool? The answer is Power Automate within the App Studio. You can build and manage your flows right from your canvas app, without navigating away.
New Power Platform features: Wave 1 2023 release wave
Features across Power Platform and Dynamics 365 have been announced as part of Microsoft's Wave 1 2023 release. These are features expected to be released from April 2023 to September 2023. This post picks out some of my highlights from the Power Platform release plan for a quick look at what we can expect over the next few months.
Power Automate connectors, triggers & actions: What are they?
Connectors, triggers and actions are the key components that make up Power Automate flows. This post will explain what each of these are.
Find an employees user details from their email address with Power Automate
The Office 365 Users connector in Power Automate allows you to find details about your colleagues from their email address/UPN. This is especially useful for finding information such as their name, manager, department, job title, office location or phone number. This information can then be used in the flow, such as escalating an approval request to someone's manager.
Save email attachments to SharePoint with Power Automate
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