The Power Automate visual is a game-changer for end-users, as it allows them to seamlessly run automated flows directly within their Power BI reports. With the Power Automate visual, users can trigger flows by simply clicking a button right within their report, without the need to switch between tools. What’s more, the executed flow can be contextual, adapting dynamically based on the filters set by the end-user. This makes it a powerful tool for context-aware automation, allowing users to customize the flow to respond to specific data conditions.

This has been a popular feature and we have made some improvements based on your feedback, including the ability to easily change environments while building flows and new templates to kickstart your workflow creation journey directly from Power BI.

Get Started

To get started with the Power Automate visual, simply select the Power Automate icon from the Visualizations pane or add the visual from the ribbon. Once added, the visual appears on your current report page, you can easily change your environment from the visual.

To configure the button, select More options (…) > Edit. From edit mode, you can create a flow from scratch or a template, and easily manage your flows. Once you create the flow, you can add it to your dashboard and run it directly from there.

Explore more about the Power Automate visual, including its limitations and known issues, by clicking here. Additionally, begin your journey to create a Power BI visual by watching an instructive video from our documentation that covers the basics.

Availability:

This feature is now available in both Power BI Desktop and the Power BI Service. However, it is currently not available in the sovereign cloud, but it will be coming soon.

Feedback:

We’d love to hear your thoughts about this feature. Click here to share you feedback with us.

The post Embed workflows in your Power BI Reports with Power Automate Visual, now Generally Available appeared first on Microsoft Power Platform Blog.

For example, you can easily manage your team’s projects with the Power Automate. You can simply create a rule to send an email to your team when a new task is added to a certain project table in Loop.

Getting started is easy. Every rule comprises three building blocks:

• Trigger (“When this column…”)
• Condition (“…has this value / changes in this way…”)
• Action (“…then do this.”)

How it works

1. Go to loop.microsoft.com.
2. Select a table-based component in an existing Loop page or create one.
3. Select the ellipses menu, and then select Table rules.
   
4. Set your desired trigger, condition, and action, and then select Continue.
   
5. Review the apps that your rule uses and select Next.
   
6. Add the recipients and select Create flow.
   

NOTE: Each automation rule in Loop corresponds to a flow in Power Automate. Limits on rule creation and execution will be determined by your Power Automate license.

Scenarios to try

• • Create an automation rule in Loop, and then update the trigger or condition.
  • Disable an existing rule, and then re-enable it.

Availability

• All Microsoft 365 subscribers can use this feature.
• Your organization’s DLP policy allows loop connectors.

Feedback

We’d love to hear your thoughts about this feature set. Send your feedback by selecting Help > Give feedback in the lower right area of your Loop app screen.

The post Simplify your work with Table rules in Microsoft Loop appeared first on Microsoft Power Platform Blog.

The new “Automate work” button in Excel Online, powered by Power Automate, has made it easier than ever to automate tasks and run processes efficiently from anywhere. This feature extends the capabilities of Power Automate by providing access to pre-built templates and allowing users to build workflows quickly and easily within Excel Online. This button replaces the “Automate a Task” button in Excel Online. Previously, the “Automate a Task” button allowed users to select templates for Office Scripts, and then take them to the Power Automate portal to build a flow. Now, with just a few clicks, you can automate repetitive tasks, reduce errors, and boost productivity, all without ever leaving Excel!

Getting started is easy! For instance, you can automatically capture customer feedback from emails and store it in an Excel Online worksheet using the “Monitor incoming emails to an alias in an Excel worksheet” template. With this template, businesses can keep track of customer feedback in one centralized location, making it easy to respond to customer needs and improve customer satisfaction. Experience the power of Excel and automation like never before!

The new “Automate work” button is only available in Excel Online and is coming soon to Desktop and Mac. The “Automate a Task” button is still available in Desktop and Mac.

Note: The “Automated Task” button is built into Excel, and is different from the Flow add-in. We look forward to expanding this experience based on your feedback!

Learn more:
Want to get started with streamlining repetitive tasks? Check out our documentation below:
• Get started building your first flow in Excel
• Learn how to call scripts from a manual Power Automate flow
• Explore how to get started with Power Automate
Share your feedback:  
We’d love to hear your feedback as you try out this feature! Give us feedback through the Feedback button located in the Help tab and including the phrase “Office Scripts” or “Power Automate”.

Happy Automating!

The post Maximize your productivity in Excel with Power Automate appeared first on Microsoft Power Platform Blog.

Excel’s new Automate tab allows you to tackle your automation needs quickly using Power Automate. Within this tab, you can now build Office Scripts and enhance their capabilities using Power Automate.

Office Scripts in Excel allows you to automate your Excel tasks by recording and replaying your actions on different workbooks and worksheets. Use Office Scripts to combine multiple workbooks into a single workbook, control when calculations happen within your workbook, and so much more! For example, you can connect your Office Script with one of Power Automate’s 900+ connectors like Outlook to send daily emails summarizing changes made to your workbook. The automation possibilities are endless, and the experience even includes common templates to get you started quickly! Get started by using a sample script or start from scratch from inside of the Automate tab.

Once you have built your Office Script, navigate to the “Automate a Task” button under the Automate tab and select from one of our many Power Automate x Office Script pre-built templates like Schedule an Office Script to run in Excel.

The Automate tab is now available for Office 365 E3 and Office 365 E5 licensed users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.

Note: The “Automate a Task” button is built in to Excel, and is different from the Flow add-in. We look forward to expanding this experience based on your feedback!

Learn more:
Want to get started with streamlining repetitive tasks? Check out our documentation below:
• Get started building your first Office Script
• Learn how to call scripts from a manual Power Automate flow
• Explore how to get started with Power Automate
Share your feedback  
We’d love to hear your feedback as you try out this feature! Give us feedback through the Feedback button located in the Help tab and including the phrase “Office Scripts” or “Power Automate”.

Happy Automating!

The post Get more done with Excel and Power Automate! appeared first on Microsoft Power Platform Blog.

Power Apps makers have been enhancing their app functionalities by adding flows that trigger notifications, managing approvals and files, and more! To learn more about how makers have used Power Apps and Power Automate to build a richer low code solution, check out the story on G&J Pepsi-Cola Bottlers.

Getting started is easy!  

Go to the left nav and select the Power Automate icon in your Canvas app. You can either add an already built flow or create a new flow from our pre-built templates or inside the Power Automate designer.

Quickly manage your flows from your app! 

Once you create your flow, you can easily manage your flow within your canvas app. You can edit, delete, or refresh your flows within the Power Automate pane.

Want to learn more about the Power Automate pane?  Check out our step-by-step guide here.

The post Introducing the new Power Automate pane in Power Apps appeared first on Microsoft Power Platform Blog.

Check out the original idea from the Power Automate ideas board in the community:

Resubmitting or canceling your flows is easy!

Now you can go to the Run history page, select the runs you would like to resubmit or cancel in the ribbon, and resubmit or cancel the runs. That’s it! Once you have resubmitted or canceled the flow run, you will be able to see your canceled and successful resubmitted flow runs.

Want to learn more about resubmitting or canceling cloud flow runs in bulk? Check out our step-by-step guide here.
Got ideas for Power Automate? Let us know! 

Join the Power automate community and submit ideas, get help, and report issues.

The post Introducing bulk resubmit and cancel for cloud flows appeared first on Microsoft Power Platform Blog.