Logic Apps Aviators Newsletter – March 2024

Logic Apps Aviators Newsletter – March 2024

This article is contributed. See the original author and article here.

In this issue:






Aviators-Logo@0.75x.png


 


Ace Aviator of the Month


 


March’s Ace Aviator: Luís Rigueira


 

LuisHeadshot.jpg


What is your role and title? What are your responsibilities associated with your position?


I am an Integration Developer, and my key responsibilities consist of working with my team and alongside clients, making the transition and integration of their products and services smoother.


 


Can you provide some insights into your day-to-day activities and what a typical day in your role looks like?


Sure, merging a portion of my activities, what I could express as day-to-day would be: I start by checking for any issues in our clients’ production environments to ensure everything’s running smoothly, and then my main activities will be implementing cloud integration solutions with Azure Integration Services. Occasionally, I also help the team on on-premises projects using BizTalk Server.


 


Also, one of my big activities is going deep into Enterprise Integration features and crafting new ways to archive specific tasks. Do proof-of-concept in new features, explore existing or new services, test those solutions, and find alternatives, for example, creating Azure functions as an alternative to the Integration Account and testing inside Logic App flows to use those Azure functions.


 


I’m always on the hunt for new solutions to any problems we face, and in doing so, there’s a lot of documenting everything we do. This documentation is more than just busy work; it really helps by streamlining our processes and guides our team and community through troubleshooting. To ensure the importance of knowledge sharing, I actively produce informative content for our blog and YouTube Channel. This includes writing posts and creating videos that share our experiences, solutions, and insights with a broader audience.


 


I also contribute to enhancing our team’s productivity by creating tools tailored to address specific issues or streamline processes that are later shared with the community.


 


What motivates and inspires you to be an active member of the Aviators/Microsoft community?


What really drives me to engage with the Aviators/Microsoft community is my passion for tackling challenges and finding solutions. There’s something incredibly rewarding about cracking a tough problem and then being able to pass on that knowledge to others. I believe we’ve all had that moment of gratitude towards someone who’s taken the time to document and share a solution to the exact issue we were facing. That cycle of giving and receiving is what motivates me the most. It’s about contributing to a community that has been so important in my own learning and problem-solving journey, and I’m inspired to give back and assist others in the same way.


 


Looking back, what advice do you wish you would have been told earlier on that you would give to individuals looking to become involved in STEM/technology?


I could say something about always having a passion for new technologies and staying up to date with what you are pursuing. There would be nothing wrong with it, but those sound like already-at-hand phrases to be exchanged without considering each individual’s current state.


 


On a moment, and in a world where mental health is so important, let me share a simple tale that resonates with anyone at the crossroads of their career, whether they are new and confused about what to do, whether they’re just starting, or contemplating a shift in direction. It’s a gentle reminder that venturing into new territories can be daunting but immensely rewarding and that, at times, we may not even realize that our current paths could be detrimental to our well-being, professional growth, and personal relationships.


 


“There was once a man that went into the wilds of Africa, believing himself to be a hunter for many years. Despite his efforts, he found himself unable to catch any game. Overwhelmed by frustration and feeling lost, he sought the guidance of a Shaman from a nearby tribe.


Confessing to the Shaman, he said, “Hunting is what I live for, but I’m hitting a wall. There’s simply nothing out there for me to hunt, and I don’t know what to do.”


The Shaman, who had seen many seasons and had a kind of wisdom you don’t come across every day, simply put his arm on the hunter’s shoulder, looked him in the eyes and said, “Really? Nothing to hunt for? This land has fed us for generations. There is plenty of hunt out there and yet you cannot see it? Maybe the problem isn’t the land…allow me to ask you something very important, do you genuinely desire to be a hunter?”


 


This narrative goes much deeper than the act of hunting. It’s a reflection on our passions, how we confront our challenges, and the realization that our perspective might need a shift.


 


If our passions no longer ignite us, or if our efforts to chase them lead nowhere, it might be a sign to let go, not in defeat, but in liberation, because, in the end, I want everyone to be happy with the career path they have chosen, so that would be my advice, to read this simple tale, apply it to your current situation and ask yourself, “Do I really want to do keep doing what I am doing right now?” And if you find that your current path is not worth pursuing, if your mental health is not in shape, or if you are hitting a wall, then yes, it is time to take the step!


 


Imagine you had a magic wand that could create a feature in Logic Apps. What would this feature be and why?


In a world where AI is at such a fast pace, one feature that I would personally like to have on Logic Apps is prompted AI-generated Logic App flows. What that would mean is you give a prompt to the designer of what you pretend, and you would have a generated, most efficient flow for what you have described. Of course, you will still need to configure some things, but I think AI-generated flows could outline and cover many scenarios, making our processes faster and more efficient.


AI is here to stay, whether we like it or not; it just doesn’t go away, so we could take advantage of it to create better, faster, and more efficient products or stay behind while we see others do it.


 


What are some of the most important lessons you’ve learned throughout your career that surprised you?


One of the most surprising yet vital lessons from my career is the central role of relationships in keeping the ship sailing smoothly. Having positive communication and nurturing a positive work environment are crucial elements that empower a team to deliver top-notch results, remain driven, and maximize their daily potential. A car has four tires, and you need them all to get home safely.




Customer Corner:


Power transmission operator ELES gains agility with Microsoft Dynamics 365


 


ELES.jpg


 


Check out this customer success story on how Microsoft is helping to keep Slovenia’s lights on by improving and modernizing ELES’ operations. In 2012, ELES turned to Microsoft when they needed a new enterprise resource planning (ERP) solution. Today, ELES uses Azure Logic Apps to connect their ERP with other systems, improving collaboration between departments, streamline operations, and better manage their energy resources and infrastructure. 




News from our product group:


 





























feranto_4-1706920211996.png



Announcing the availability of TLS 1.3 in Azure API Management in Preview   


Read more about updates to TLS 1.3, the latest version of the internet’s most deployed security protocol. 


Pedro_M_Almeida_0-1708078171207.png



IBM MQ Built-in (In-App) connector and Queue Handles: The math behind Queue Handles   


For those using the IBM MQ Built-in (In-App) connector available in Logic Apps Standard, check out this article explain more on Handles and how to calculate the max value to set in your IBM MQ server. 


shahparth_0-1707165935171.png

Public Preview of Azure OpenAI and AI Search in-app connectors for Logic Apps (Standard)   


Check out this article on our two new built-in connectors (Azure OpenAI and Azure AI Search) that are now available for public preview. 


Saroja_L_Sattigeri_0-1707278985222.png



Common issues of Azure Automation connector in logic app(consumption) and logic app standard   


Learn about various issue scenarios related to the Azure Automation connector in both Logic App Consumption and Standard, along with its causes and resolutions. 


deprecated sql.png

Identify Logic Apps Consumption that are using deprecated V1 Actions and Triggers for SQL Connector   


V1 Actions/Triggers of the SQL Connector for Logic Apps will be deprecated by the end of March 2024. In this article, learn how to use a PowerShell Script to identify the Logic Apps still using the deprecated SQL Connectors so that you can change them to the V2 equivalent.




BlogPreview_default-blue.png



Integration Service Environment to Logic Apps Standard Migration    


ISE’s retirement date is August 31st, 2024, so make sure you migrate any Logic Apps running on ISE to Logic Apps Standard. Check out this guide video from our FastTrack team that walks you through the whole process!



 




News from our community:


From BizTalk to Logic Apps: A Real-World Integration Journey – February 2024 


Post by Houston Azure User Group 


 


Check out this recording from the February 2024 meetup for Houston Azure User Group where Azure customers dive into their journey from on-premises Biztalk to Azure Logic Apps hosted in an Integration Service Environment (ISE).


 


Deploying Multi-Line Values in ARM Templates   


Post by Harris Kristanto 


 


If you’re deploying an ARM template due to multi-line secrets stored in Azure Key Vault, then make sure to read this article from Harris!


 


Friday Fact: When a HTTP Request is Received trigger can accept more http methods other than POST   


Post by Luís Rigueira and Sandro Pereira


 


Check out this post and video from collaborators Luís and Sandro and learn about other HTTP methods you can use in your Logic Apps. 


 


Building an API to call Logic Apps Consumption   


Post by Mike Stephenson 


 


Want to make life a bit easier and learn how to build an APIM API that exposes Logic App Consumption with Terraform? Then check out Mike’s new video.


 


Using Managed Identity with Consumption and Standard Logic Apps with Azure Service Bus   


Post by Stephen W Thomas 


 


Read Stephen’s quick tips and tricks for using Azure Service Bus to grant access to specific consumption or standard edition Logic Apps.


 


Easy Auth | Standard Logic App with Azure API Management   


Post by Andrew Wilson 


 


Learn about using Easy Auth with Logic App Standard and restricting to API Management as a Backend.


 


Migrating from MuleSoft to Azure Integration Services (AIS): Why and How   


Post by Derek Marley and Tim Bieber 


 


Watch this recording from a webinar hosted by Derek and Tim as they talk about the benefits of Azure’s ecosystem and a step-by-step strategy for a smooth transition from MuleSoft to AIS.


 


Microsoft Fabric: Automating Fabric Capacity Scaling with Azure Logic Apps   


Post by Soheil Bakhshi 


 


Learn from Soheil about how to efficiently upscale and downscale your capacity based on specific workloads in this blog post.


 


What is Azure NAT Gateway | What is SNAT Port Exhaustion | Azure Standard Logic App Static Outbound IP Address   


Post by Sri Gunnala 


 


Learn about Azure NAT Gateway and how to use it with Azure Logic Apps to solve business problems from Sri.

MGDC for SharePoint FAQ: Is OneDrive included?

MGDC for SharePoint FAQ: Is OneDrive included?

This article is contributed. See the original author and article here.

1. SharePoint datasets and OneDrive


 


When I describe the SharePoint datasets in Microsoft Graph Data Connect to someone, I frequently get this question: do Sites and Sharing Permissions cover only SharePoint or do they include OneDrive? The short answer is that OneDrive is included, but there is much more to say here…


 


2. OneDrive is a type of SharePoint site


 


For most technical intents and purposes, a OneDrive in your Microsoft 365 tenant is a SharePoint site with a specific template and permissions. It is basically a SharePoint site collection for personal use that comes preconfigured with permissions for the owner and nobody else. After that, you can upload/create files and decide to keep them private or share with others from there.


 


This special type of site was initially called a “Personal Site”, later was referred to as a “My Site” or “MySite”, then a “OneDrive for Business” (commonly abbreviated to “ODfB” or simply “ODB”). These days, we usually just call it a OneDrive and you can figure out if we’re talking about the consumer or business variety based on context.


 


Along the way, the purpose has always been the same. To allow someone in a tenant to store information needed for your personal work, with the ability to share with others as necessary. As the name suggests, it’s your single drive in the cloud to store all your business-related personal files.


 


The personal sites for each user are typically created only when the user tries to access their OneDrive for the first time. SharePoint does offer administrators a mechanism to pre-provision accounts. You can read more about it at https://learn.microsoft.com/en-us/sharepoint/pre-provision-accounts.


 


But keep in mind that, when you use the Microsoft Graph Data Connect to pull the Sites dataset, you get all types of sites in the tenant and that does include OneDrives.


 


3. How can you tell them apart?


 


In the Sites dataset, you can tell a site is a OneDrive by looking at the RootWeb.WebTemplate (which is “SPSPERS” for OneDrive) or the RootWeb.WebTemplateId (which is 21 for OneDrive). Note that these are properties of the Root Web for the site (more on this later).


 


For the other Microsoft Graph Data Connect for SharePoint datasets, you can use the SiteId property to join with the Sites dataset and find the Template or Template Id. This is a reliable method and the recommended one.


 


Some of the datasets might also have a URL property which can be used to identify a OneDrive. For the Sharing Permissions dataset, for instance, an ItemURL that starts with “personal/” indicates a permission for a OneDrive. You can read more about OneDrive URLs at https://learn.microsoft.com/en-us/sharepoint/list-onedrive-urls.


 


Using the URL is probably OK for most tenants using OneDrive but might not work for other site types.


 


4. Root Web


 


It is good to clarify why the Template and TemplateId properties come from the RootWeb property and it’s not a property of the site itself.


 


For starters, it’s important to understand the main SharePoint entities:



  1. There are many tenants.

  2. Tenants have Sites, also known as Site Collections.

  3. Sites (Site Collections) have Webs, also known as Subsites.

  4. Webs (Subsites) have Lists, some of which are called libraries or document libraries.

  5. Lists have List Items (document libraries have folders and documents)


 


As you can see, there is a hierarchy.


 


HierarchyHierarchy


 


 



The relationship between Sites and Webs is particularly interesting. When you create a Site, you must tell SharePoint the type of Site you want. That is used to create the Site and the main Web inside, called the RootWeb.


 


Every Site Collection has at least one Web and most have only one (the Root Web). The Site’s name and type (template) ends up being stored in the Root Web. Most templates don’t even have an option to add more webs (subsites). I would recommend keeping things simple and having only one web per site.


 


Note: You will sometimes hear people refer to Webs as Sites, which is a term normally used for Site Collections. Since most Site Collections have only one Web, that is typically not a big issue. That can get a little confusing at times, so you might want to stick to using the unambiguous terms “Site Collections” and “Webs” to be extra clear.


 


5. Web Templates


 


When you create a Site Collection and its corresponding Root Web, you must choose a Web Template. Each Web Template comes with a few default lists and libraries.


 


Some of these Web Templates (like Team Sites and Communication Sites) help you get started with a new Site. Others are not meant to be created by end users but are used for specific scenarios (like the Compliance Policy Center, the Search Center or the Tenant Admin Site). As we mentioned before, one of these templates is the Personal Site or OneDrive.


 


Here’s a list of some common Web Templates used by SharePoint Online:


 







































































Web Template Id Web Template Description
1 STS Classic Team Site
16 TENANTADMIN Tenant Admin Site
18 APPCATALOG App Catalog Site
21 SPSPERS OneDrive (Personal Site)
54 SPSMSITEHOST My Site Host
56 ENTERWIKI Enterprise Wiki
64 GROUP Office 365 group-connected Team Site
68 SITEPAGEPUBLISHING Communication site
69 TEAMCHANNEL Team Channel
90 SRCHCENTERLITE Basic Search Center
301 REDIRECTSITE Redirect Site
3500 POLICYCTR Compliance Policy Center


 


Note: There are many more of these templates, not only the ones listed above. You can get a list of the templates available to you using the Get-SPOWebTemplate PowerShell cmdlet:


 


> Install-Module -Name Microsoft.Online.SharePoint.PowerShell
> Connect-SPOService -url https://archimedes-admin.sharepoint.com
> Get-SPOWebTemplate | Select Name,Title | Sort Name | Format-List

Name : BDR#0
Title : Document Center

Name : BICenterSite#0
Title : Business Intelligence Center

Name : BLANKINTERNETCONTAINER#0
Title : Publishing Portal

Name : COMMUNITY#0
Title : Community Site

Name : COMMUNITYPORTAL#0
Title : Community Portal

Name : DEV#0
Title : Developer Site

Name : EHS#1
Title : Team Site – SharePoint Online configuration

Name : ENTERWIKI#0
Title : Enterprise Wiki

Name : OFFILE#1
Title : Records Center

Name : PRODUCTCATALOG#0
Title : Product Catalog

Name : PROJECTSITE#0
Title : Project Site

Name : SITEPAGEPUBLISHING#0
Title : Communication site

Name : SRCHCEN#0
Title : Enterprise Search Center

Name : SRCHCENTERLITE#0
Title : Basic Search Center

Name : STS#0
Title : Team site (classic experience)

Name : STS#3
Title : Team site (no Microsoft 365 group)

Name : visprus#0
Title : Visio Process Repository


 


6. They are all in there…


 


So, I hope it’s clear that the Microsoft Graph Data Connect for SharePoint datasets (like Sites, Sharing Permissions and Groups) include information for all types of sites in the tenant, regardless of the Template they use. You can use the Sites dataset to understand Team Sites, OneDrives, and Communication Sites. The Sharing Permissions dataset includes permissions for all these different types of sites.


 


Note: For more information, visit the main blog at Links about SharePoint on MGDC.

Unlocking AI Skills: A Guide for Tech Students,  Microsoft UK AI Challenge

Unlocking AI Skills: A Guide for Tech Students, Microsoft UK AI Challenge

This article is contributed. See the original author and article here.

Artificial intelligence (AI) is transforming the world of work, creating new opportunities and challenges for businesses and workers alike. According to a recent report by Microsoft and PwC, AI could boost the UK economy by £232 billion by 2030, but it also requires a significant upskilling of the workforce to ensure that everyone can benefit from it.


If you are a technology student or a young professional who wants to develop AI skills and prepare for the future of work, here are some tips and resources that can help you: The Microsoft UK AI & Copilot Skills Challenge starts February 20, 2024 at 8:00 AM (8:00) GMT and ends on March 31, 2024 at 23:00 PM (11pm) GMT.

AISkills.jpeg



  • Learn the basics of AI and its applications. AI is a broad field that encompasses many subdomains, such as machine learning, computer vision, natural language processing, and more. To get started, you can take online courses, such as Microsoft Learn, edX, or Coursera, that cover the fundamentals of AI and how it can be used to solve real-world problems. You can also explore Learn AI Microsoft Resources learning paths and hands-on labs for various AI scenarios and communities.

  • Get hands-on experience with AI tools and platforms. To apply your AI knowledge and skills, you need to familiarize yourself with the tools and platforms that enable you to build, deploy, and manage AI solutions. For example, you can use Azure AI Studio, a cloud-based service that provides a comprehensive set of AI capabilities, such as cognitive services, machine learning, and conversational AI. You can also use Power Platform, a low-code/no-code platform that allows you to create AI-powered apps, workflows, and chatbots without writing code.

  • Join AI communities and events. One of the best ways to learn and grow your AI skills is to connect with other AI enthusiasts and experts, who can offer you guidance, feedback, and inspiration. You can join online or local AI communities, such as the Gobal AI Community, where you can network, share ideas, and collaborate on projects. You can also attend AI events, where you can hear from industry leaders, discover the latest trends, and showcase your work.

  • Keep up with the ethical and social implications of AI. As AI becomes more pervasive and powerful, it also raises important ethical and social questions, such as how to ensure fairness, accountability, transparency, and human dignity in AI systems. To be a responsible AI practitioner, you need to be aware of these issues and how to address them in your work. You can read books, articles, and reports, such as The Future Computed, AI Ethics, or Responsible AI, that explore the ethical and social dimensions of AI. You can also take courses, that teach you how to design and implement AI solutions that align with ethical principles and social values.


AI is a fast-growing and exciting field that offers many opportunities for technology students and professionals. By following these tips and resources, you can develop AI skills that will help you succeed in the future of work. Remember, AI is not only about technology, but also about people, society, and the world. So, be curious, be creative, and be ethical, and you will be ready to make a positive impact with AI. 



Learn and develop essential AI and Copilot skills with the UK AI Skills Challenge


Get ahead with immersive and curated AI, Generative AI and Copilot training content across Microsoft products and services with four engaging themed challenges. Once you complete a challenge, you will receive a Microsoft UK AI & Copilot Skills Challenge badge of completion. For more info refer to the official rules.


As you progress through the challenges, you’ll have the chance to explore additional experiences tailored to your learning preferences and goals. Join the vibrant technical community in your local region, attend live sessions, build a powerful network, and build in-demand AI skills for today’s job market.


 







Generative AI


This challenge focused on understanding Generative AI and Large Language Models. Discover the fundamentals of generative AI and get started with Azure OpenAI Service. You’ll learn more about prompt engineering, generating code with Azure OpenAI Services, large language models, and prompt flow to develop large language model apps.


Go to challenge



Copilot for Microsoft 365 – IT Pro Administration


This challenge is tailored for IT Pro Administrators seeking to leverage Copilot for Microsoft 365 effectively in their work environments. The series of modules covers a range of topics from basic introductions to advanced management techniques, ensuring a comprehensive learning experience.


Go to challenge





Copilot for Developers


This challenge is tailored for developers who want to learn how to build apps for Microsoft Teams and get to know Microsoft Copilot Studio. It includes a series of modules that will give you practical experience and valuable knowledge about creating, launching, and improving apps on these platforms.


Go to challenge



Machine Learning Challenge


Machine learning is at the core of artificial intelligence, and many modern services depend on predictive machine learning models. Learn how to use Azure Machine Learning to create and publish models without writing code. You’ll also explore the various developer tools you can use to interact with the workspace.


Go to challenge





Security review for Microsoft Edge version 122

This article is contributed. See the original author and article here.

We are pleased to announce the security review for Microsoft Edge, version 122!


 


We have reviewed the new settings in Microsoft Edge version 122 and determined that there are no additional security settings that require enforcement. The Microsoft Edge version 117 security baseline continues to be our recommended configuration which can be downloaded from the Microsoft Security Compliance Toolkit.


 


Microsoft Edge version 122 introduced 4 new computer settings and 4 new user settings. We have included a spreadsheet listing the new settings in the release to make it easier for you to find them.


 


As a friendly reminder, all available settings for Microsoft Edge are documented here, and all available settings for Microsoft Edge Update are documented here.


 


Please continue to give us feedback through the Security Baselines Discussion site or this post.

What’s New in Copilot for Microsoft 365

What’s New in Copilot for Microsoft 365

This article is contributed. See the original author and article here.

Small Hero Image.jpg


 


Welcome to the first edition of What’s new in Copilot for Microsoft 365. We are continuing to enhance Copilot to provide deeper experiences for users and tighter integration with your organization’s data to unlock even more capabilities. Whether you’re a Microsoft 365 admin for a large enterprise or smaller company or someone who uses Copilot for Microsoft 365 for their daily work, every month we’ll highlight updates to let you know about new and upcoming features and where you can find more information to help make your Copilot experience a great one. In addition to these monthly posts, we’ll continue to provide updates through our usual message center posts and on our public roadmap. 


 


Today, we are highlighting Copilot support in 17 additional languages, expanded resources and coming features in Copilot Lab, the updated Copilot experience in Teams, Copilot in the Microsoft 365 mobile app, and a new feature that provides a single entry point to help you create content from scratch. We’ll also take a look at updates to Copilot in OneDrive, Stream, and Forms plus a new feature that generates content summaries when you share files with coworkers. Finally, we’ll share a bit on what’s new in the Copilot for Microsoft 365 Usage report for admins. Let’s take a closer look at what’s new this month: 


 



  • Experience Copilot support for more languages 

  • Begin your Copilot journey and build new skills with Copilot Lab 

  • Copilot now available in the Microsoft 365 mobile app 

  • Introducing Copilot in Forms 

  • Extract information quickly from your files with Copilot in OneDrive 

  • Include quick summaries when sharing documents 

  • Get instant video summaries and insights with Copilot in Stream 

  • Try new ways of working with Help me create 

  • Draft emails quicker and get coaching tips for your messages with Copilot in classic Outlook for Windows 

  • Experience the new Copilot experience in Microsoft Teams

  • Check out the improved usage reports for Microsoft Copilot in the admin center   

  • Catch up on the Copilot for Microsoft 365 Tech Accelerator


 


Experience Copilot support for more languages  


We are adding support for an additional 17 languages, further expanding access to Copilot worldwide. We will start rolling out Arabic, Chinese Traditional, Czech, Danish, Dutch, Finnish, Hebrew, Hungarian, Korean, Norwegian, Polish, Portuguese (Portugal), Russian, Swedish, Thai, Turkish and Ukrainian over March and April. Copilot is already supported in the following languages: English (US, GB, AU, CA, IN), Spanish (ES, MX), Japanese, French (FR, CA), German, Portuguese (BR), Italian, and Chinese Simplified. Check the public roadmap and message center to track roll out status. 


 


Copilot in Excel (preview) is currently supported in English (US, GB, AU, CA, IN) and will be supported in Spanish (ES, MX), Japanese, French (FR, CA), German, Portuguese (BR), Italian, and Chinese Simplified starting in March. 


 


Begin your Copilot journey and build new skills with Copilot Lab 


Copilot Lab helps users get started with the art of prompting and helps organizations with onboarding and adoption by providing a single experience that meets Copilot users where they are in their journey. Today, we’re expanding Copilot Lab by transforming the current prompts library into a comprehensive learning resource that helps everyone begin their Copilot journey with confidence and to take greater advantage of Copilot in their daily work.  


 


Start your Copilot journey with ease. We’ve learned from our earliest Copilot adopters that working with generative AI requires new skills and habits. Copilot Lab already shows up in Copilot for Microsoft 365, Word, PowerPoint, Excel, and OneNote via the small notebook icon that suggests relevant prompts to inspire you. Now, we have consolidated our best resources, training videos, ready-made prompts, and inspiration to make Copilot Lab the single resource to help you get started. To do this, we’ve brought together our own internal best practices, insights from our earliest customers, findings from the Microsoft Research team, and thought leadership published on WorkLab. 


 



 


Achieve more together by sharing your favorite prompts. With Copilot Lab, we are making it even easier to create, save, and share your favorite prompts with colleagues inside your organization. Now you can share prompts with colleagues to prepare for a customer meeting or to generate ideas for a new product launch. And leaders across your organization can showcase how they’re using Copilot by sharing their favorite prompts to save time or tackle any task at hand, to help improve personal and team productivity and encourage community-centric learning and adoption. This feature is integrated into the Copilot Lab website and in-app experiences will begin rolling out by this summer.  


 


 


 


 


 


 


 



 


You can access Copilot Lab today at copilot.cloud.microsoft/prompts or directly in app by selecting the notebook icon next to the Copilot prompt window. 


 


Copilot now available in the Microsoft 365 mobile app 


We’re extending Copilot to the Microsoft 365 mobile app and to the Word and PowerPoint mobile apps. With the new Microsoft 365 app look and feel, you can easily find Copilot alongside your content, apps, and shortcuts. You can use it to: 


 



  • Bring your content into Copilot to complete tasks on the go. Summarize documents, translate, explain, or ask questions, and have your answer grounded in the content you select.  

  • Start generating content wherever you work based on your ideas and existing information, and hand over to Microsoft 365 mobile apps to continue working.  

  • Interact with Copilot in Word mobile and PowerPoint mobile to comprehend content better and skim through only the most important slides on the go (requires a Copilot license).  


 


The Microsoft 365 mobile app complements the Copilot mobile app rolled out earlier this month, and licensed users can continue to use the Copilot mobile app to have responses grounded in both web or work data. IT admins can easily deploy both the Microsoft 365 mobile app and the Copilot mobile app to corporate devices using Microsoft Intune or a third-party tool, or users can simply download the Microsoft 365 mobile app on any supported device and sign in. 


  


Copilot integration in the Microsoft 365 mobile app and the Word and PowerPoint mobile apps is rolling out now. You can learn more here 


 


The iOS layout of the Microsoft 365 mobile app, showing Copilot available on the taskbar.The iOS layout of the Microsoft 365 mobile app, showing Copilot available on the taskbar.


 


 


Create compelling surveys, polls, and forms with Copilot in Forms 


Use Copilot to simplify the process of creating surveys, polls, and forms, saving you time and effort. Go to forms.microsoft.com, select New, and tell Copilot your topic, length, and any additional context. Copilot will provide relevant questions and suggestions, and then you can refine the draft by adding extra details, editing text, or removing content. Once you’ve created a solid draft with Copilot, you can then customize the background with one of the many Forms style options. With Copilot in Forms, you’ll effortlessly create well-crafted forms that capture your audience’s attention, leading to better response rates.  


 


Copilot in Forms will be available in March. You can learn more here 


 


An image of a form draft with Copilot prompts displayedAn image of a form draft with Copilot prompts displayed


 


 


Extract information quickly from your files with Copilot in OneDrive 


Copilot in OneDrive gives you instant access to information contained deep within your files. Initially available from the OneDrive web experience, Copilot will provide you with smart and intuitive ways to interact with your documents, presentations, spreadsheets, and files. You can use Copilot in OneDrive to: 


 



  • Get information from your files: Ask questions about your content using natural language, and Copilot will fetch the information from your files, saving you the work and time of manually searching for what you need. 

  • Generate file summaries: Need a quick overview of a file? Copilot can summarize the contents of one or multiple files, offering you quick insights without having to even open the file.  

  • Find files using natural language: Find files in new ways by using Copilot prompts such as “Show me all the files shared with me in the past week” or “Show files that Kat Larson has commented in.” 


Copilot in OneDrive will be available in late April on OneDrive for Web. You can learn more here 


 


 


 


 



Alt text: Video showing Copilot in OneDrive with a prompt to extract information from a collection of resumes. 


 


Include quick summaries when sharing documents   


Add Copilot-generated summaries when you share documents with your colleagues. These summaries, included in the document sharing notification, give your recipients immediate context around a document and a quick overview of its content without needing to open the file. Sharing summaries helps users prioritize work, increases engagement, and reduces cognitive burden. 


 


Sharing summaries will be available in March 2024, starting when sharing a Word document from the web, with support in the desktop client and the mobile app later this year. Learn more here. 


 


  


GIF showing AI-generated sharing summary when sharing a Microsoft Word doc.GIF showing AI-generated sharing summary when sharing a Microsoft Word doc.


 


 


Get instant video summaries and insights with Copilot in Stream 


By using Copilot in Microsoft Stream, you can quickly get the information you need about videos in your organization, whether you’re viewing the latest Teams meeting recording, town hall, product demo, how-to, or onsite videos from frontline workers. Copilot helps you get what you need from your videos in seconds. You can use it to:  


 



  • Summarize any video and identify relevant points you need to watch 

  • Ask questions to get insights from long or detailed videos 

  • Locate when people, teams, or topics are discussed so you can jump to that point in the video 

  • Identify calls to action and where you can get involved to help 


Copilot in Stream will be available in late April. You can learn more here. 


 


Copilot in Stream can quickly summarize a video or answer your questions about the content in the video.  Alt text: Screen shot showing Copilot in Microsoft Stream.Copilot in Stream can quickly summarize a video or answer your questions about the content in the video.  Alt text: Screen shot showing Copilot in Microsoft Stream.


 


 


 


 


Try new ways of working with Help me create 


In March, we’re rolling out a new Copilot capability in the Microsoft 365 web app that helps you focus on the substance of your content while Copilot suggests the best format: a white paper, a presentation, a list, an icebreaker quiz, and so on. In the Microsoft 365 app at microsoft365.com, simply tell Help me create what you want to work on and it will suggest the best app for you and give you a boost with generative AI suggestions. Learn more here 


 


 


Help me create dialog box in the foreground, with the Microsoft 365 web app create screen in the background.Help me create dialog box in the foreground, with the Microsoft 365 web app create screen in the background.


 


 


 


Draft emails quicker and get coaching tips for your messages with Copilot in classic Outlook for Windows 


Customers of the new Outlook for Windows have been enjoying Copilot features like draft, coaching, and summary which we announced last year. Since November last year, summary by Copilot has also been available in classic Outlook for Windows. Soon, draft and coaching will be coming to classic Outlook too. 


 


Draft with Copilot helps you reduce time spent on email by drafting new emails or responses for you with just a short prompt that explains what you want to communicate. Because you are always in control with Copilot, you can choose to adjust the proposed draft in length and tone or ask Copilot to generate a new message – and you can always go back to the previous options if you prefer.  


 


Coaching by Copilot can help you get your point across in the best possible way, coaching you on tone (for example, too aggressive, too formal, and so on), reader sentiment (how a reader might perceive your message), and clarity. Copilot can provide coaching for drafts it created or drafts you wrote yourself. 


 


 Coaching will start rolling out in early March and draft by Copilot will start rolling out in late March 


  


An image of a message composed in the classic Outlook for Windows with the Copilot icon being clicked to reveal options for draft and coaching.An image of a message composed in the classic Outlook for Windows with the Copilot icon being clicked to reveal options for draft and coaching.


 


 


Experience the new Copilot in Microsoft Teams 


We have recently enabled a new Copilot experience in Microsoft Teams that offers better prompts, easier access, and more functionality than the previous version. Copilot in Teams will be automatically pinned above your chats, and you can use it to catch up, create, and ask anything related to Microsoft 365. Learn more about the new Copilot experience in Teams here. 


 


An image of the Copilot experience in Microsoft Teams, responding to a question based on the user's Graph dataAn image of the Copilot experience in Microsoft Teams, responding to a question based on the user’s Graph data


 


 


 


Check out the improved usage reports for Microsoft Copilot in the admin center 


The Microsoft 365 admin center Usage reports offer a growing set of usage insights across your Microsoft 365 cloud services. Among these reports, the Copilot for Microsoft 365 Usage report (Preview) is built to help Microsoft 365 admins plan for rollout, inform adoption strategy, and make license allocation decisions. 


 


The report now includes usage metrics for Microsoft Copilot with Graph-grounded chat. This allows you to see how Chat compares with usage of Copilot in other apps like Teams, Outlook, Word, PowerPoint, Excel, OneNote and Loop. You can review the enabled and active user time series chart to assess how usage is trending over time. The new metric has been added retroactively dating back to late November of 2023. To access the report, navigate to Reports > Usage and select the Copilot for Microsoft 365 product report. Learn more here. 


 


An image of the Copilot for Microsoft 365 Usage report highlighting the addition of a new metric for Microsoft Copilot with Graph-grounded chatAn image of the Copilot for Microsoft 365 Usage report highlighting the addition of a new metric for Microsoft Copilot with Graph-grounded chat


 


 


 


Learn more about the use of Copilot for Microsoft 365 in the Financial Services Industry  


Today we are releasing the new white paper for the financial services industry (FSI) with information about use cases and benefits for the FSI, information about risks and regulations, guidance for managing and governing a generative AI solution, and more information about how to prepare for Copilot. Read the paper here. 


 


Catch up on the Copilot for Microsoft 365 Tech Accelerator 


In case you missed it, you can catch up on all the sessions from the Copilot for Microsoft 365 Tech Accelerator via recordings on the event page. The event covered a range of topics including how Copilot works, how to prepare your organization for Copilot, strategies for deploying, driving adoption, and measuring impact, and deep dives on how to extend Copilot with Copilot Studio and Graph connectors. Chat Q&A is open through Friday, March 1, 12:00 P.M. PT, so watch the recordings and get any questions you might have answered. 


 


Did you know? The Microsoft 365 Roadmap is where you can get the latest updates on productivity apps and intelligent cloud services. Check out what features are in development or coming soon on the Microsoft 365 Roadmap. All future rollout dates assume the feature availability on the Current Channel. Customers should expect these features to be available on the Monthly Enterprise Channel the second Tuesday of the upcoming month.