Latest Power Automate Features to Boost Productivity

  1. Application Insights Integration for Monitoring Power Automate Flows
    The integration of Power Automate with Application Insights allows users to monitor and analyse the performance of their automated workflows. By connecting Power Automate with Application Insights, you can track flow execution, view real-time telemetry data, and gain insights into failures, performance bottlenecks, and usage patterns. This integration helps improve workflow reliability, optimize performance, and enhance troubleshooting, making it easier to maintain and troubleshoot automation processes.
Latest Power Automate Features
The above image refers to the Overview panel in Application Insights, providing key metrics and data to monitor and troubleshoot workflows.
Failures panel in Application Insights, displaying information on workflow errors and issues for troubleshooting.

Availability: This feature is generally available from Aug 2024.
Reference: Overview of integration with Application Insights – Power Platform | Microsoft Learn
Video: Power Automate Telemetry Integration with Application Insights | TechTalk

  1. Simplify Flow Creation with Copilot in Power Automate
    Copilot Assistance for Streamlining Automation in Power Automate helps accelerate automation by using natural language instructions to suggest solutions. It guides you throughout the entire process, from creation to completion, making it easier to adopt automation and transform your workflows.

    Note: Copilot Assistance for Streamlining Automation in Power Automate is enabled by default in the UK, Australia, US, and India, and can be disabled at the tenant level via PowerShell.
Copilot Assistance for Streamlining Automation

Availability: This feature is generally available from September 2024.

Reference: Copilot in Power Automate – Power Automate | Microsoft Learn

Video: Building Flows with Copilot

  1. Effortless Expression Creation and Editing Using Copilot’s Natural Language Support
    With this feature, makers can easily create or edit complex expressions in Power Automate using natural language prompts. No need for complex coding—just submit your request to Copilot. To use this, Copilot must be enabled in your tenant.

type a natural language prompt

Availability: This feature is generally available from Mar 2025.

Reference: Create and edit expressions with Copilot | Microsoft Learn

4. Task Mining and Process Mining in Power Automate for Automation Opportunities

Task Mining and Process Mining in Power Automate help find tasks and processes that can be automated. Task Mining looks at repetitive tasks done by users, like clicks and typing, and suggests ways to automate them. Process Mining looks at entire workflows to find delays and problems. Together, they help businesses work faster and more efficiently.

Task Mining vs. Process Mining

Both tools aim to uncover automation opportunities, but they operate at different levels:

Task Mining and Process Mining

Availability: This feature is generally available from August 2023.

Reference:  Microsoft launches Power Automate Process Mining and next-generation AI – Microsoft Power Platform Blog

Video: Improve Efficiency with Power Automate Process Mining and RPA | BRK213H

  1. Integrate Visuals in Power BI with Power Automate for Interactive Dashboards
    Integrating Power Automate with Power BI allows you to automate workflows and visualize data seamlessly. By creating a flow in Power Automate, you can process and send data to Power BI for real-time reporting. In Power BI, build a report based on this data and embed a Power Automate button to trigger workflows directly from the dashboard. This integration streamlines tasks, improves efficiency, and offers a more interactive experience for users.

Settings:

  1. Select the Power Automate icon from the Visualizations pane.

2. In Power BI Desktop, you can also add the visual from the ribbon. On the Insert tab, select Power Automate in the Power Platform section.

3. Scroll, resize the visual, or select the Focus mode icon to see all the instructions.

Availability: This feature is generally available from November 2024.

Reference: Create a Power Automate visual for Power BI – Power BI | Microsoft Learn

  1. Cancel Active Flow Runs for Specific Flow Versions in Power Automate
    In Power Automate, you can cancel all active flow runs for a specific version of a flow. This is useful when you need to stop unnecessary or problematic runs without impacting the entire flow. By targeting a specific version, you maintain control while ensuring your flow processes run smoothly. This feature helps clean up unwanted executions and avoids conflicts or errors, making flow management more efficient and reliable.
The image above indicates that the flow is in the process of being cancelled.
The image above indicates that the flow is in the process of being cancelled.

Availability: This feature is generally available from Apr 2024.
Reference: Cancel all flow runs for a version of a flow | Microsoft Learn

  1. Cloud-Based Automation and Task Management with Hosted RPA and Work Queues in Power Automate

Hosted RPA in Power Automate allows automation to run on cloud-based virtual machines without human intervention, making it scalable and efficient. Work Queues manage tasks by placing them in an organized queue for automation, ensuring smooth and timely processing. Together, these features streamline workflows, improve productivity, and reduce manual effort, helping businesses automate complex processes more effectively.

Availability: This feature is generally available from November 2024.

Reference: Introduction to the Power Automate Hosted RPA – Power Automate | Microsoft Learn

Video:  Power Automate Hosted RPA – Efficiently scale RPA operations

  1. View and Compare Multiple Action Properties Panes Simultaneously in Power Automate
    This feature lets you pin an action properties pane and open another one side-by-side. It allows for easy comparison of properties, copying values between panes, and taking screenshots, improving workflow efficiency.

Availability: This feature is generally available from Aug 2024.
Reference: View two action properties panes simultaneously | Microsoft Learn

  1. Mark Input Parameters as Optional in Manual Triggers for On-Demand Flows

This feature allows you to mark input parameters in manual or Power Apps triggers as optional in Power Automate’s modern designer, a capability previously available only in the classic designer. This makes it easier to run flows on demand without requiring all input parameters.

The image shows that you can now mark any input parameter in a manual trigger as optional in the modern designer.

Availability: This feature is generally available from Mar 2024.
Reference: Mark input parameters in triggers as optional | Microsoft Learn

10. Enhanced Creation and Testing of Seamless Approval Workflows in Power Automate

Streamline approvals with Power Automate. Easily create and test workflows to manage document and process approvals across platforms like SharePoint, Dynamics 365, and Salesforce.

Example:

  • Trigger: The workflow starts when someone creates a vacation request in a SharePoint Online list.
  • Add to Approval Center: The request is added to the approval center and emailed to the approver.
  • Notify Requester: An email with the approver’s decision is sent to the person who requested the vacation.
  • Update List: The SharePoint Online list is updated with the approver’s decision and comments.

Availability: This feature is generally available from October 2024.

Reference: Create and test an approval workflow with Power Automate – Power Automate | Microsoft Learn

Power Apps Features for Developers: Top 10 Highlights

Power Apps is constantly evolving to provide developers with powerful tools to enhance productivity and improve app performance. In this blog, we’ll explore the top 10 features introduced in 2024 that every Power Apps developer should know about. From simplifying formula creation to enabling seamless collaboration, these updates are designed to streamline your development process.

1. Comment-Generated Formulas

This feature simplifies PowerFx formula creation by allowing developers to input natural language prompts. Whether you’re a beginner or an experienced developer, this feature reduces complexity and boosts productivity.

For example, you can input: ‘Filter the gallery to show items where the status is Active.’ Power Apps will automatically generate the corresponding formula: ‘Filter(GalleryItems, Status = “Active”)‘.

Availability: December 2024 (2024 Release Wave 2)

Reference: What’s new in Power Apps: October 2024 Feature Update – Microsoft Power Platform Blog

Power Apps Features for Developers

2. Real-Time Co-Authoring

Collaborating on canvas apps has never been easier! With real-time co-authoring, multiple makers can now edit an app simultaneously, just like in Microsoft Word or PowerPoint. This feature significantly speeds up development and fosters better teamwork.

Example: If you and a colleague are working on a canvas app, you’ll both be able to see each other’s changes in real-time, making collaboration seamless and efficient.

Availability: June 2024 (2024 Release Wave 1)

Reference: Work together in real time to create canvas apps | Microsoft Learn

3. Customizable Offline Profiles

Optimize your offline-enabled apps by selecting specific columns for each table. This reduces unnecessary data load, ensuring a smoother and more efficient experience for users, even when they’re offline.

Example: A field agent app that only needs a subset of columns can be customized to download only the essential data, reducing load time and improving offline performance.

Availability: December 2024 (2024 Release Wave 2)

Reference: Select columns downloaded on mobile devices | Microsoft Learn

4. Code View for Canvas App Functionality

Power Apps introduces a Code View that allows developers to inspect, share, and copy control code easily using a YAML-based format. This feature is invaluable for understanding app functionality at a granular level.

Example: To view the code for a specific control, right-click on it in the tree view and select ‘View Code (Preview)’. This makes it easy to share and modify control code.

Availability: October 2024 (2024 Release Wave 2)

Reference: Use code view for canvas app controls (preview) – Power Apps | Microsoft Learn

Visuals:

  • To view the code for a control, right-click the control in the tree view or directly on the screen, and then select View Code (Preview).

To add a new control from the copied code, right-click on the screen where you want to place the new control, and then select Paste Code (Preview).

5. WYSIWYG Data Modeling with Copilot

Create tables and relationships visually with Copilot’s WYSIWYG (What You See Is What You Get) data modeling feature. Copilot generates Entity Relationship Diagrams (ERDs), making complex data modeling easier and more intuitive.

Settings:

  1. Open Power Apps
  2. Invoke Copilot
  3. Create a Table
    1. Prompt
    1. Define Relationship
  4. Visualize Relationships
  5. Refine and Update

Example: With a few clicks, you can generate an ERD that visually represents your data tables and their relationships, making the process of creating and managing data models faster and simpler.

Availability: June 2024 (2024 Release Wave 1)

Reference: Visualize and work with complex data using copilot | Microsoft Learn

Visuals:

Describe the solution requirements.

The copilot will generate the ERD (Entity Relationship Diagram) based on the requirements

An AI-generated table containing sample data.

Drag and drop the entities to establish a relationship.

6. Seamless Pipeline Setup

Setting up deployment pipelines is now faster than ever. In less than 60 seconds, you can automate solution transitions between development, testing, and production environments, ensuring smoother releases and better version control.

Example: Set up a pipeline to automate your app’s deployment from development to production, reducing the risk of human error and ensuring smoother transitions.

Availability: June 2024 (2024 Release Wave 1)

Reference: Set up pipelines in Power Platform – Power Platform | Microsoft Learn

7. Canvas App Insights with Monitor

Monitor your app’s performance and get actionable insights to improve its functionality with the new Monitor tool. This feature helps identify issues and recommends improvements, ensuring a better user experience.

Example: After deploying an app, use the Monitor tool to check performance metrics and receive recommendations to optimize the app’s responsiveness.

Availability: December 2024 (2024 Release Wave 2)

Reference: Get valuable insights and recommendations for your canvas app using Monitor | Microsoft Learn

8. GitHub ALM Integration

With GitHub integration, Power Apps now supports Application Lifecycle Management (ALM), enabling developers to implement version control, continuous integration (CI), and continuous deployment (CD) workflows.

Example: By linking your Power Apps project to a GitHub repository, you can manage source code, automate deployments, and monitor testing processes in one unified platform.

Setting Up ALM in Power Apps with GitHub

  1. Create a GitHub Repository
  2. Install Power Platform Build Tools
  3. Export Solutions from Power Apps
  4. Set Up a CI/CD Pipeline
  5. Configure GitHub Actions
  6. Automate Testing
  7. Monitor and Maintain

Availability: September 2024 (2024 Release Wave 1)

Reference: Available GitHub Actions for Microsoft Power Platform development – Power Platform | Microsoft Learn

9. Smart Paste in Model-Driven Apps

Streamline data entry in model-driven apps with the new Smart Paste feature. This feature automatically suggests inputs based on the content copied to your clipboard, saving time and reducing manual entry errors.

Example: If you copy a list of addresses into your clipboard, Smart Paste will automatically fill out the corresponding fields in your model-driven app, making data entry faster and more accurate.

Availability: September 2024 (2024 Release Wave 1)

Reference: Use Copilot’s form fill assistance feature in model-driven apps – Power Apps | Microsoft Learn

Visuals:

The Smart Paste feature suggests inputs for the fields in the form by analyzing the copied text and the form structure.

To accept all suggestions on the open tab of the form, on the notification bar, select Accept all suggestions.

10. SQL Server Procedure Integration

You can now call SQL Server stored procedures directly in PowerFx without relying on Power Automate, simplifying the app development process and improving performance.

Example: The following PowerFx formula demonstrates how to call a stored procedure: ClearCollect(ResultCollection, SQLConnection.spMyStoredProcedure(param1: TextInput1.Text).ResultSets.Table1).

Availability: September 2024 (2024 Release Wave 1)

Reference: Call SQL Server stored procedures directly in Power Fx (Preview) – Microsoft Power Platform Blog

Example:

ClearCollect(
    ResultCollection,
    SQLConnection.spMyStoredProcedure(
        param1: TextInput1.Text
    ).ResultSets.Table1
)

Select the stored procedure, as shown in the image below.

Below is an example of reference code that you can use in the Power Fx formula bar

Conclusion

The 2024 Power Apps features offer developers powerful tools to improve efficiency, collaboration, and app performance. These updates, including real-time co-authoring, enhanced offline capabilities, and better integration with GitHub and SQL Server, will significantly streamline your development process and improve your app’s functionality.

Stay ahead of the curve by exploring these features today. For detailed guides and video tutorials, visit Microsoft Learn or watch the latest demo videos on Sysfore’s YouTube channel.

How does Copilot Studio improve business productivity? Everything You Need to Know

How does Copilot Studio improve business productivity? Everything You Need to Know

Microsoft Copilot Studio FAQs

Microsoft Copilot Studio empowers businesses to integrate AI into workflows, enabling the creation of intelligent copilots that assist with tasks, generate insights, and answer queries based on integrated data sources. Below are some frequently asked questions to give you a clearer understanding of Copilot Studio FAQs and its capabilities.

 1. What is Microsoft Copilot Studio?

Microsoft Copilot Studio is a platform that allows organizations to develop customized AI copilots to assist with tasks, automate workflows, and provide data-driven insights. These copilots can be tailored to meet the specific needs of different departments and business processes.

 2. What features does Copilot Studio provide?

Key features include:

  • Generative AI Responses: Copilots/Chatbots can generate intelligent, real-time responses to user queries using data from integrated sources.
  • Knowledge Source Integration: Businesses can connect internal documents, databases, and websites to enhance the copilot’s ability to provide accurate information.
  • Customizable Behavior: Copilots/Chatbots can be instructed to behave in a certain way, set a specific tone, and respond in a customized manner based on context.

 3. How does Copilot Studio allow customization in its responses?

You can extensively customize the way your copilot responds:

  • Tone and Style: You can define how your copilot/chatbot responds—whether in a friendly, professional, or casual tone—depending on the target audience.
  • Behavioral Instructions: Set specific rules for how your copilot/chatbot should respond to various types of queries. For instance, you can direct it to prioritize resolving customer complaints with empathy or respond in a concise, fact-driven manner for technical inquiries.

4. What is content moderation in Copilot Studio, and why is it important?

Content moderation in Copilot Studio is a feature that ensures the information generated or shared by copilots aligns with responsible and safe usage standards. It helps filter out inappropriate or harmful content, promoting a secure environment for users. This is particularly important for businesses to maintain brand integrity, adhere to compliance policies, and create a trustworthy user experience. Copilot Studio allows users to set the level of content moderation in 3 levels.

  • Low – More Creative: Copilot/Chatbot generates the most answers but might be inaccurate.
  • Medium – More Balance: Copilot/Chatbot generates more answers but might be irrelevant or undesirable.
  • High – More Precise: Copilot’s answers are more relevant. (default setting)
Microsoft Copilot Studio FAQs

5. What are generative answers in Copilot Studio?

Generative answers in Copilot Studio allow your copilot/chatbot to find and present information from multiple sources, internal or external, without created topics. Generative answers can be used as primary information sources or as a fallback source when authored topics can’t answer a user’s query. As a result, you can quickly create and deploy a functional copilot. You don’t need to manually author multiple topics that might not address all customer questions.

6. What happens when the copilot/chatbot is not able to understand the user’s query?

Traditionally, when a copilot/chatbot can’t determine a user’s intent, it asks the user to rephrase their question. If after 2 prompts (number can be increased), the copilot still can’t determine the user’s intent, the copilot can be configured to escalate the unresolved query to a live agent in Dynamics 365 Customer Service, using the Escalate system topic.

7. What are knowledge sources in Copilot Studio?

In Copilot Studio, knowledge sources are data repositories or information resources that a copilot/chatbot references to generate accurate responses to user queries. These sources can include structured databases, documents, websites, and other digital content that contain relevant information. By connecting to these knowledge sources, Copilot Studio enables copilots to access up-to-date content and answer queries with context and accuracy.

Examples of knowledge sources in Copilot Studio:

  1. Dataverse Tables: Structured data from Microsoft Dataverse, often used for customer, sales, or product data.
  2. Document: Unstructured text-based data in Copilot Studio can include various file types, such as Word documents (doc, docx), Excel spreadsheets (xls, xlsx), PowerPoint presentations (ppt, pptx), PDFs (pdf), Text files (.txt, .md, .log), HTML files (html, htm), CSV files (csv), XML files (xml), OpenDocument files (odt, ods, odp), EPUB files (epub), Rich Text Format (rtf), Apple iWork documents (pages, key, numbers), JSON files (json), YAML files (yml, yaml), and LaTeX files (tex).
  3. Website Content: External websites or internal knowledge bases, useful for pulling publicly available or intranet data.
  4. Custom APIs: Connections to custom data endpoints, enabling Copilot Studio to access specialized, real-time information.

8. What are the known limitations of supported knowledge sources?

  • Public Website
    • Searches query input on Bing and returns results only from specified websites.
    • Limit: Up to 4 public URLs upto 2 levels deep (e.g., microsoft.com/copilotstudio/faq, sysfore.com).
    • Authentication: None
  • Documents
    • Searches documents uploaded to Dataverse and retrieves content from document files.
    • Limit: Maximum document size should be 512MB, Number of uploaded documents is constrained by Dataverse’s file storage allocation.
    • Authentication: None
  • SharePoint
    • Connects to a SharePoint URL and retrieves results using Graph Search.
    • Limit: Up to 4 URLs per generative answer topic node, only the SharePoint files having size less than 3MB will be leveraged for Generative AI.
    • Authentication: Requires Microsoft Entra ID authentication for the copilot user.
  • Dataverse
    • Connects to Dataverse environment, using retrieval-augmented generation to retrieve information.
    • Limit: 2 Dataverse knowledge sources, with up to 15 tables per knowledge source.
    • Authentication: Requires Microsoft Entra ID authentication for the copilot user.
  • Enterprise Data via Microsoft Graph Connectors
    • Connects to Microsoft Graph connectors for indexed organization data via Microsoft Search.
    • Limit: Up to 2 sources per custom copilot/chatbot.
    • Authentication: Requires Microsoft Entra ID authentication for the copilot user.
Microsoft Copilot Studio FAQs

9. What are the specific limitations when using uploaded documents as knowledge sources in Copilot Studio?

  • Annotated PDFs: Annotations in PDF files are only supported in newly uploaded files. Previously uploaded annotated PDFs need to be deleted and re-uploaded for proper recognition.
  • File Types: Image, video, executable, and audio files cannot be used as knowledge sources.
  • Image Support: Only images embedded in PDF files are supported. Other image formats outside PDFs are not processed.
  • Geographic Restriction: Embedded images in PDF files are only supported when hosted in Switzerland and the United States.
  • Icons: Icons within files are not supported.
  • File Size Limit: Files larger than 512 MB are not supported for upload.
  • Content Restrictions: Files that are encrypted, password-protected, or labeled with confidential tags cannot be uploaded.
  • File Count Limit: A maximum of 500 files can be uploaded as knowledge sources for each copilot.

10. Why are Glossary and Synonyms Important When Configuring Dataverse Tables as Knowledge Sources in Copilot Studio?

Glossary and Synonyms settings are crucial when configuring Dataverse tables as knowledge sources because they enhance the Copilot’s ability to understand user queries more naturally and accurately. Here’s why they are important:

  1. Improved Query Matching: By setting synonyms for commonly used terms, you ensure that Copilot recognizes different ways users might phrase their questions. For instance, if “revenue” is commonly referred to as “income” in your organization, adding “income” as a synonym helps Copilot retrieve relevant results even when users don’t use the exact term.
  2. Enhanced Contextual Understanding: The glossary allows you to define specific terms and jargon unique to your organization or industry, making responses more precise and aligned with user expectations. This is particularly useful for specialized terms that might have different meanings outside the organizational context.
  3. Consistency Across Responses: Using a well-defined glossary ensures that Copilot consistently uses standardized terminology in its responses, reinforcing internal knowledge standards and reducing misunderstandings across various teams.
  4. Higher Relevance of Results: Synonyms and glossary terms help Copilot filter results more effectively from large datasets, especially when working with complex or layered Dataverse tables. This enables users to receive answers that are more relevant to their specific queries.

By configuring synonyms and glossary terms, you make the Copilot/Chatbot more adaptive and capable of delivering answers that are both accurate and aligned with the language familiar to users in your organization.

11. How Can I Acquire Copilot Studio Licenses and Assign Them to Users?

To create and manage copilots in Copilot Studio, both user-specific and organizational licenses are required:

  1. Per-User License (Copilot Studio User License): Each individual responsible for creating and managing copilots needs this per-user license, which can be assigned via the Microsoft 365 admin center.
  2. Tenant License (Copilot Studio License): The tenant administrator must acquire this license to enable Copilot Studio across the organization. It is assigned at the tenant level and cannot be allocated to individual users.

Additional Information:

  • Users who interact with the published copilot do not need a Copilot Studio license. Once published, the copilot is accessible to anyone within the organization who has permission.
  • Guest users in the tenant are not allowed access to Copilot Studio or to interact with copilots created within it.

12. Can I Create and Manage Multiple Copilots Across Different Environments in Copilot Studio?

Yes, with Copilot Studio, you can create copilots in different Power Platform environments and easily switch between them. Each environment serves as a dedicated space to store, manage, and share business data, copilots, apps, and flows.

Environments allow for flexibility in management:

  • You can set up specific environments for different teams or departments, each containing the relevant copilots and data.
  • Create separate environments for various global locations or branches to localize data and Copilot functionality.
  • Use multiple environments to meet data residency and security requirements as needed.

Alternatively, if you prefer simplicity, all copilots can be built within a single environment, provided that it meets your organizational needs.

 13. What are the different channels I can publish my copilot on?

You can publish your copilot developed in Copilot Studio on various channels depending on the authentication settings. Supported channels include:

  • Microsoft Teams
  • Mobile App
  • Custom Websites
  • Facebook
  • Slack
  • Line
  • Telegram
  • Skype
  • Twilio
  • And many more

This flexibility allows your copilot to reach users through the platforms most relevant to your business.

 14. How secure is Microsoft Copilot Studio?

Copilot Studio follows Microsoft’s stringent enterprise security standards, ensuring data encryption and strict access controls. It uses Azure Active Directory to manage authentication and permissions, ensuring that only authorized personnel have access to sensitive data.

Microsoft Copilot Studio FAQs

15. How does Copilot Studio improve business productivity?

Copilot Studio enables businesses to automate repetitive tasks, provide instant insights, and free up employees to focus on high-value work. Teams across HR, customer service, sales, and other departments can benefit from quick access to important data and automated workflows.

 16. What industries can benefit from Copilot Studio?

Copilot Studio can be implemented across various industries:

  • Customer Support: Automate responses to customer queries and support tickets.
  • Sales: Provide sales teams with real-time sales data, forecasts, and lead insights.
  • Healthcare: Offer doctors and nurses quick access to patient data, appointment details, and medical guidelines.
  • Finance: Help teams manage financial reports, track invoices, and analyze business trends in real-time.

 17. What Authentication Options Are Available for Copilots Created in Copilot Studio?

Copilot Studio offers three main authentication options for copilots, depending on the level of access and security needed:

  1. No Authentication:
    1. Users are not required to sign in to interact with the copilot.
    1. Copilot can only access public information and resources.
    1. This option allows anyone with the link to interact with the copilot, similar to classic chatbots, which are unauthenticated by default.
  2. Authenticate with Microsoft:
    1. This option sets up Microsoft Entra ID (formerly Azure Active Directory) authentication automatically for Microsoft Teams.
    1. Users aren’t prompted to sign in while using Teams, as the platform itself provides user identification.
    1. Only the Teams channel is supported for this authentication type.
  3. Manual Authentication Setup:
    1. Copilot Studio supports various authentication providers, allowing more control over access:
      1. Azure Active Directory (AAD)
      1. Azure Active Directory v2
      1. Azure Active Directory v2 with Certificates
      1. Generic OAuth 2 (any identity provider that supports the OAuth2 standard)

 Conclusion

Microsoft Copilot Studio is an essential tool for businesses looking to integrate AI into their operations. With the ability to publish across various platforms, customize responses, and access data in real-time, Copilot Studio offers a versatile and scalable solution for improving productivity across multiple industries.

Explore the possibilities and see how Copilot Studio can enhance your business workflows!