Hi Team, 

I am getting this error while opening my account

​Hi Team,  I am getting this error while opening my account  Read More

​

TLDR – Azure Virtual Desktop Black Screens.  Could be 2 Min long, could be much longer.  Tried removing stuck profiles, spun up all new VMs to see if that would fix it, finally disabled an application service that was polluting the Event logs constantly with appcrashes.  Hoping that maybe the event logs weren’t able to keep up so we had a black screen while events caught up.  Grasping at straws.

We started getting reports of black screens when users login to one of our AVD Host Pools.  Our users are using FSLogix for profiles, but we’ve also seen the issue when logging via RDP with a local admin account.  We tested and saw similar results where you login, FSLogix Prompt goes by, then to Preparing Windows, then black screen. 

In a normal login, this black screen will last 10-20 seconds before desktop comes available and user can begin their session.With this issue, we were seeing black screens that just stayed there until you forced a logout of your account.

We saw some profile issues with the VMs in the pool appearing to be stuck on a VM when it should be removed upon logoff with FSLogix and we saw some stuck local_username FSLogix profiles still in the users folder.  Instead of finding the needle in a haystack, we spun up a new group of VMs and put the others in drain mode / excluded.   

With the new VMs, logins from RD Client were working fine yesterday afternoon, evening and this AM.  But later in the morning, we saw some issues with users getting a black screen lasting 90 sec – 2 min before desktop loaded in.  I had it happen to me when logging in, but it seemed to go away once I tried a couple more times.  I even directly RDPd into the host that I had the 2 min black screen for me and was able to get in quickly.   So issue appears to still be showing, but not as bad.

We looked in event logs and saw that one particular application – the Aspen Multicase Web service was polluting the service event logs with appcrash errors every few seconds.  So we’ve disabled that application service on all the VMs in the pool and logins have been normal since.  We read event logs that were event 4625 (failed login) but the event said event logs couldn’t keep up and needed to stop duplicate events…so we were thinking that this service was constantly writing to event logs, could the slow logins happen when the service is trying to run, failing and writing to event logs.  the logs wouldn’t be able to write the login info.

But every other change we made things seem fine afterward for a while, but then the black screen will come back for at least 90sec – 2 min.

Any suggestions on things we can try / look at that could be causing this?

​TLDR – Azure Virtual Desktop Black Screens.  Could be 2 Min long, could be much longer.  Tried removing stuck profiles, spun up all new VMs to see if that would fix it, finally disabled an application service that was polluting the Event logs constantly with appcrashes.  Hoping that maybe the event logs weren’t able to keep up so we had a black screen while events caught up.  Grasping at straws. We started getting reports of black screens when users login to one of our AVD Host Pools.  Our users are using FSLogix for profiles, but we’ve also seen the issue when logging via RDP with a local admin account.  We tested and saw similar results where you login, FSLogix Prompt goes by, then to Preparing Windows, then black screen. In a normal login, this black screen will last 10-20 seconds before desktop comes available and user can begin their session.With this issue, we were seeing black screens that just stayed there until you forced a logout of your account.We saw some profile issues with the VMs in the pool appearing to be stuck on a VM when it should be removed upon logoff with FSLogix and we saw some stuck local_username FSLogix profiles still in the users folder.  Instead of finding the needle in a haystack, we spun up a new group of VMs and put the others in drain mode / excluded.    With the new VMs, logins from RD Client were working fine yesterday afternoon, evening and this AM.  But later in the morning, we saw some issues with users getting a black screen lasting 90 sec – 2 min before desktop loaded in.  I had it happen to me when logging in, but it seemed to go away once I tried a couple more times.  I even directly RDPd into the host that I had the 2 min black screen for me and was able to get in quickly.   So issue appears to still be showing, but not as bad. We looked in event logs and saw that one particular application – the Aspen Multicase Web service was polluting the service event logs with appcrash errors every few seconds.  So we’ve disabled that application service on all the VMs in the pool and logins have been normal since.  We read event logs that were event 4625 (failed login) but the event said event logs couldn’t keep up and needed to stop duplicate events…so we were thinking that this service was constantly writing to event logs, could the slow logins happen when the service is trying to run, failing and writing to event logs.  the logs wouldn’t be able to write the login info. But every other change we made things seem fine afterward for a while, but then the black screen will come back for at least 90sec – 2 min. Any suggestions on things we can try / look at that could be causing this?  Read More

​

Today, customers can create Diagnostic Settings in their resources to export metric data for their resources to a set of destinations. Currently, export of metrics supported via Diagnostic Settings is limited. Customers cannot export metrics with dimensions, not all metrics are supported, and it incur a few minutes of latency.

We are excited to announce a platform metrics from Azure Monitor. This powerful addition allows customers to export metrics for their Azure resources on a large scale with full fidelity and low latency, along with the new added ability to filter particular metrics while configuring exports.

Azure Monitor Metrics Export is configurable through Data Collection Rules (DCR), which provides the capability to route Azure resource metrics data to Azure Storage Accounts, Azure Event Hubs and Azure Log Analytics Workspace for 18 resource types and 10 Azure public regions.

Here are some key features and benefits of Azure Monitor Metrics Export –

Easily scalable: DCR is the de facto collection configuration mechanism in Azure Monitor; it allows setting a collection config once and applying it at scale to many resources. DCR now provides an easier solution to span across subscriptions to export resources metrics at scale and provides flexibility if more resources need to be added in an existing DCR configuration.
Flexibility on what to collect: Customers can filter collection with a few select metrics or all metrics for a given set of resources, allowing for volume and cost control. With the new enhanced experience, customers can easily access the metrics they deem most important.
Export with full fidelity and low latency: Resource metric data is exported with dimensional information which provides ease of correlation. This feature significantly improves the metrics export latency.

By using Azure Monitor Metrics export, organizations can streamline their monitoring processes and improve their infrastructure’s overall performance. We look forward to seeing the innovative solutions and exciting use cases that developers and organizations will create using this feature.

Azure Monitor Metrics Export is being used by several customers in Private Preview. Here is what some of them have to say about their experience: 

Customer Quote

“Previously, running out of disk space caused support teams to halt their work to clear space, but the feature now enables them to be warned beforehand, reducing manual intervention and outages doublefold (2X).​– Franscois Piennaar (Cloud/Database Engineer; Tata Steel NL)

The new Azure Monitor Metrics Export will be charged at a rate of $0.003/1000 metrics samples (Refer to pricing details here). Please note current users of the Diagnostic Settings will see no change in pricing.

Learn more about Azure Monitor Metrics Export – https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/data-collection-metrics

​Microsoft Tech Community – Latest Blogs –Read More 

i have a 1 to 2 second keyboard input lag sometimes, regardless if im playing games or not. i do not have asus programs on my pc, i have updated all drivers, plugged the keyboard in a different port, i dont have an anti virus, the only common factor between me and the only other person who has this problem is that they are on windows 11, and use msi motherboard, i dont think its the motherboard since they’re on AM5 while i am on intel. thanks for your time.

​i have a 1 to 2 second keyboard input lag sometimes, regardless if im playing games or not. i do not have asus programs on my pc, i have updated all drivers, plugged the keyboard in a different port, i dont have an anti virus, the only common factor between me and the only other person who has this problem is that they are on windows 11, and use msi motherboard, i dont think its the motherboard since they’re on AM5 while i am on intel. thanks for your time.  Read More

​

I created a simple DLP in Purview as a test just to find a particular word and to block access to the document.  Just as a test in sim mode for now.

I can access the document from SharePoint and get a pop up notification which I set that tells me its contain this word.  I can also access it from OneDrive online and get the popup.  

But if I use the OneDrive shorcut to SharePoint which opens the document In Word desktop I do not get any popup.

The DLP policy is set for SharePoint and OneDrive.

Will this not work for shorcuts.

Thanks

​I created a simple DLP in Purview as a test just to find a particular word and to block access to the document.  Just as a test in sim mode for now. I can access the document from SharePoint and get a pop up notification which I set that tells me its contain this word.  I can also access it from OneDrive online and get the popup.   But if I use the OneDrive shorcut to SharePoint which opens the document In Word desktop I do not get any popup. The DLP policy is set for SharePoint and OneDrive. Will this not work for shorcuts. Thanks   Read More

​

Hi,

I’ve been trying to understand how you can insert a table in the Planner task description through Power Automate.

I can see that you can create a table in Microsoft Word then paste this into the Planner task description as shown below but I’m getting no luck in trying to re-create this through Power Automate (update task details).

I’ve tried to use the get task details for this task and it shows a string of 

​Hi, I’ve been trying to understand how you can insert a table in the Planner task description through Power Automate. I can see that you can create a table in Microsoft Word then paste this into the Planner task description as shown below but I’m getting no luck in trying to re-create this through Power Automate (update task details).I’ve tried to use the get task details for this task and it shows a string of “| Location |  |rn| — | — |rn| Name |  |rn| Contact Number |  |rn| Email |  |rn| Reason for request |  |rn| Actions required |  |rn| Initially Assignees |  |” then when I try to use this as a template for the action Update task details, it produces this as a string rather than a table. I’ve also used the Graph API to get the task details but it shows exactly the same as the string already mentioned.  I’d be really grateful if anyone could help!  Read More

​

We’re excited to announce that, starting today, Windows App is generally available for Windows, macOS, iOS, iPadOS, and web browsers—and in public preview for Android. This unified app serves as your secure gateway to connect to Windows across Windows 365, Azure Virtual Desktop, Remote Desktop, Remote Desktop Services, Microsoft Dev Box, and more.

With Windows App, you can enjoy a unified experience that makes it simple for people to connect to the Windows experience they know and love from any device. Enhance productivity with features such as customizable home screens, multi-monitor support, and USB redirection. Windows App also offers advanced security features, including multifactor authentication, to ensure a seamless and robust connection and enable efficient work from any location, at any time.

Windows App: a unified gateway to Windows

Windows App provides a consistent, reliable experience for all devices, enabling secure access from any location. Whether you need to connect to Windows 365, Azure Virtual Desktop, Remote Desktop, Remote Desktop Services, or Microsoft Dev Box, Windows App simplifies the process, allowing you to manage and utilize these resources from a single, intuitive app. Whether you are an IT administrator or an end user, Windows App provides immense value. IT admins benefit from enhanced security and streamlined management, while end users can tailor their experience to fit their personal workflows. Other benefits of Windows App include:

Unified access: Manage and access multiple Windows services, including cloud PCs, virtual desktops, and local PCs, from a single, streamlined interface.
Customizable experience: Personalize your interface with customizable home screens, multimonitor support, and dynamic display resolutions.
Enhanced experience: Enjoy features such as device redirection, Microsoft Teams optimizations, and easy account switching for an efficient remote working experience.

“We’ve been using Windows App through the private and public previews, and we were given the opportunity to submit recommendations for feature enhancements to ensure it has the functionality we need. During our recent go live, we received great feedback: it provides seamless access from any device and massively improves our end-user experience.” — Lee O’Connor, EUC Architect, Yorkshire Water Services Ltd.

Ready for a closer look at Windows App? Watch this short video:

What’s new with Windows App?

With the general availability of Windows App, you’ll see enhancements designed to make accessing and managing Windows resources even more seamless. These updates bring new features and improvements to your experience across all major platforms:

Device and app actions: Simplify device management with a variety of integrated actions unique to supported solutions.
Support for Windows 365 Frontline Cloud PCs: Enjoy extended compatibility for specialized use cases.
In-app feedback: Windows 365 and Azure Virtual Desktop users can easily provide feedback within the app.
Account switcher for Microsoft Entra ID: iOS and macOS users can take advantage of easy account switching when using a Microsoft Entra account.
Relayed Remote Desktop Protocol (RDP) Shortpath: Experience improved connectivity and performance for remote sessions. For more information, see Relayed RDP Shortpath for public networks now available.

These updates make Windows App a better tool for managing your Windows environment. Whether you work from a desktop or a mobile device, these capabilities will make an impact.

Windows App helps you manage your connected cloud PCs, virtual desktops, and local PCs from a single, streamlined interface.

“The new Windows App significantly saves onboarding time for new employees and reduces administration efforts of IT pros. All virtualized workplaces and apps can now be found at one centralized, familiar place.” — Roman Kleyn, Head of Workplace Design, KRONES AG

“The cross-platform availability of the new Windows App unifies the end-user experience for all our employees and enables them to have the virtualized environment they need at their fingertips in the office, at home, and while traveling,” adds Kleyn.

Kleyn concludes, “Krones immediately started to evaluate and onboard first test users to the new Windows app at availability day one. Rolling it out widely for the enterprise was a no-brainer for us. From the beginning, we were fully convinced that the new unified experience will set a new standard for end-user experience in virtualized environments.”

Plan for change: transition to the new Windows App

With this general availability launch, users of Remote Desktop clients for Windows, macOS, iOS, iPadOS, and web will transition to Windows App.

Windows App is now available through the appropriate store for each client platform, ensuring a smooth update process. To prepare for the transition to Windows App, we recommend that if you’re an IT admin you use the Windows App get started documentation to update internal processes and create guidance for your users and helpdesk teams. If migrating users to Windows App is preferred, you can refer to the migration documentation.

For more information, please visit What is Windows App?

Where to download Windows App

If you have a Windows device, you can easily download Windows App from the Microsoft Store. Or, if you prefer, you can access Windows App directly through your web browser, offering seamless connectivity without the need to install software.

You can also download Windows App from the Apple App Store (for macOS and iOS) or from Google Play (for Android). For specifics on supportability for each platform, see Compare Windows App features across platforms and devices.

Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.

​Microsoft Tech Community – Latest Blogs –Read More 

Discover how you can revolutionize your API compliance process using Azure API Center, Logic Apps, GitHub, and cutting-edge AI technology. Learn how our innovative approach analyzes your API design governance, generates insightful compliance reports, and seamlessly notifies developers with actionable feedback. Stay ahead of the curve and ensure your APIs meet the highest standards with our automated, AI-driven solution.

Introduction

API compliance is crucial for organizations to make sure that APIs designed and built follow the established rules, standards, and guidelines defined by the organization as well as industry best practices, which developers must adhere to while developing APIs. Further, it becomes time consuming to review APIs and identify design guidelines gaps manually, and integrating compliance with existing eco-system, which impacts developer productivity.

This article shows how you can revolutionize and enhance your API compliance process using Azure API Center’s Analysis capabilities and Integration Services, and generate insightful compliance reports using Azure OpenAI, notifying developers with actionable feedback to ensure APIs adhere to organization’s API guidelines and industry best practices.

The solution will achieve following objectives.

Improved Developer Productivity: The use of AI-driven insights reduces the time developers spend manually reviewing APIs, allowing them to focus on critical tasks with real-time, actionable feedback on API design gaps.
Automate API Compliance: By integrating Azure API Center with Azure OpenAI, the solution ensures that APIs comply with organizational design standards and best practices through automated analysis.
Seamless Integration: The solution automates the workflow by integrating with GitHub and Azure services, streamlining the compliance review process and creating an efficient feedback loop for developers.

Intelligent API Compliance Solution using Azure API Center and Azure OpenAI

Azure API Center provides robust API analysis to ensure APIs adhere to design standards through API Analysis, which analyzes API definitions and provides reports on compliance. Analysis reports are in JSON format and can be pulled via API center data place endpoint.

Utilizing Azure OpenAI alongside API Center’s analysis will improve compliance by providing developers with practical feedback and explanations. Azure OpenAI can transform JSON analysis reports into easily understandable outputs, including summaries, the count of errors/warnings, and steps for remediation using prompt engineering technique. In our solution we will provide “system message” as shown below to AOAI model followed by analysis report to get “summary of findings” and “high level remediation guide” which can then be used in issue, tasks, or any reporting platform. We can customize system message as per our needs and what information we are looking for. In our solution we have used GPT4 model, and the output might be different based on model used and system message.

System Message:
User will provide spectral json results and you will provide users with two headings named “Summary of findings” and “High Level Remediation Guidance”. “Summary of findings” will have a table with columns Rule, Severity and Total Count which will have unique analyzerRuleName and severity and total count, and another section which show over all total number of errors and warnings. “High Level Remediation Guidance” will have high level remediation guidance in bullet numbers. Please output all information in proper html email friendly format and avoid using heading tags.

Additionally, combining this with Azure Integration Service (Logic Apps Standard and Event Grid) allows automation and integration into existing source control and feedback systems for example GitHub.

Important: Ensure that your AI solutions follow Responsible AI principles to promote fairness, transparency, and accountability, safeguarding users and building trust in your technology. For more information see Responsible AI Practices for Azure OpenAI Model.

How components will work together

The solution diagram below shows how all Azure services work together to enhance and transform API compliance, and generate intelligent insights.

API Submission & API Center Analysis: When a new API definition is registered/updated, it is submitted to Azure API Center, which runs the analysis. In this solution we will be using Microsoft Managed API Analysis.
Azure API Center acts as the central hub for managing and analyzing API definitions. It ensures consistency and compliance by running API linting rules against the defined standards of the organization. API Center performs analysis of APIs and generates detailed reports that identify compliance or design gaps.

Event Triggering: Event Grid captures the analysis event “Microsoft.ApiCenter.AnalysisResultsUpdated” and triggers Logic Apps workflow. Event Grid is responsible for detecting and responding to changes in the API definitions stored in Azure API Center. It triggers an event whenever a new API analysis report is generated. This event is then captured by Logic Apps to initiate automated workflow.

Orchestration using Logic Apps Standard: Logic Apps retrieves the analysis report from API Center and sends it to Azure OpenAI for intelligent insights using built in Azure OpenAI connector. Logic Apps orchestrate the entire workflow by retrieving the API analysis report from API Center when triggered by Event Grid, sending it to Azure OpenAI for intelligent processing, and creating GitHub issues with insights and recommendations.

AI-Powered Insights using Azure OpenAI: Azure OpenAI Service plays a critical role in transforming the analysis data in JSON format into meaningful insights. It takes the API analysis report from Logic Apps and uses advanced language models to generate returns easily understandable outputs, including summaries, the count of errors/warnings, and remediation guidance for developers.

GitHub Issue Creation: Once the compliance report is generated, Logic Apps creates an issue in the GitHub repository. This issue includes transformed analysis results from Azure OpenAI which includes high-level remediation suggestions, and any necessary guidance for developers, as shown below. By integrating with GitHub, teams can collaborate on resolving compliance issues directly in their existing development workflow.

Pre-requisites

API Center in your Azure subscription with Microsoft managed API analysis enabled. If you haven’t created one already, see QuickStart: Create your API Center.
Event Grid resource provider registered in your subscription. If you need to register the Event Grid resource provider, see Subscribe to events published by a partner with Azure Event Grid.
Logic Apps Standard
Azure OpenAI Service with GPT-3.5-Turbo or GPT-4 (recommended) model deployed. See resource deployment guide for more information.
GitHub account with repository

Deployment Architecture

The intelligent API compliance solution’s architecture incorporates Azure API Center, Azure Integration Services, Azure OpenAI features, and GitHub for collaboration and reporting. The diagram below illustrates the components of this architecture which need to be deployed in your subscription.

Key Points:

Azure API Center:  Azure API Center with Microsoft managed API analysis enabled. See Enable API analysis in your API center – Microsoft managed on how to enabled Microsoft Managed Analysis.
Logic Apps Standard: Logic Apps Standard should have managed identity enabled and access to API Center.

To enable managed identity on logic apps standard see “Enable system-assigned identity in the Azure portal”.
To provide Logic Apps Standard access to API Center, follow steps outlined in Enable API analysis in your API center – self-managed under “Step 2. Configure managed identity in your function app”

Workflow

Follow steps below to create workflow. After completing your workflow, it should look like below. To test workflow, register API by following “Tutorial: Register APIs in your API inventory”.

Steps to Create Workflow

Create Workflow: In you logic apps standard, create a new stateful workflow.

Add Event Grid Trigger: In designer add “When a resource event occurs – Azure Event Grid” and set following parameters

Parameter

Value

Resource Type

Microsoft.ApiCenter.Services

Subscription

select your subscription

Resource Name

select your api center resource

Event Type

Microsoft.ApiCenter.AnalysisResultsUpdated

Add action “Initialize variable” and set below parameters

Parameter

Value

Name

varApiDefRes

Type

Array

Value (expression)

split(triggerBody()?[‘subject’],’/’)

Add action “Compose” and set “Inputs” expression parameter as follows
concat(‘https://management.azure.com/subscriptions/’,variables(‘varApiDefRes’)[2],’/resourceGroups/’,variables(‘varApiDefRes’)[4],’/providers/Microsoft.ApiCenter/services/’,variables(‘varApiDefRes’)[8],’/workspaces/default/apis/’,variables(‘varApiDefRes’)[12],’/versions/’,variables(‘varApiDefRes’)[14],’/definitions/’,variables(‘varApiDefRes’)[16],’/analysisResults?api-version=2024-03-01′)

HTTP action: Add HTTP action to call endpoint api center to get analysis report. Set following parameters

Parameter

Value

URI

output of compose action from previous step

Method

GET

Authentication Type

Managed Identity

Managed Identity

System-assigned managed identity

Audience

https://management.azure.com/

Azure OpenAI action: we will break this into two parts for better clarity. We will first add Azure OpenAI action an set basic parameters and than set “Messages”

Add “Azure OpenAI – Get chat completions” action and provide information to create connection to Azure OpenAI, and set following parameters. Feel free to change advanced parameters according to your needs as this will generate different output.

Parameter

Value

Deployment Identifier

Your AOAI model deployment name

Sampling Temperature

0.5

Presence Penalty

0

Now in same action we will setup two messages, one for system to provide instruction and one for user input, which in our case will be analysis report output from previous http action. Add below parameters in order.
Chat Role – 1

Parameter

Value

Chat Role – 1

System

Chat Message – 1

User will provide spectral json results and you will provide users with two headings named “Summary of findings” and “High Level Remediation Guidance”. “Summary of findings” will have a table with columns Rule, Severity and Total Count which will have unique analyzerRuleName and severity and total count, and another section which show over all total number of errors and warnings. “High Level Remediation Guidance” will have high level remediation guidance in bullet numbers. Please output all information in proper html email friendly format and avoid using heading tags.

Chat Role – 2

Chat Role – 2

User

Chat Message – 2 (type expression)

string(body(‘HTTP’))

GitHub Action: Finally add GitHub action “Create an issue”, and provide information to create connection. Set required parameters and for parameter Body (under advanced) select “Chat completion response” from previous “Azure OpenAI” action.

Conclusion

The combination of Azure API Center, Logic Apps, GitHub, and Azure OpenAI presents a powerful framework for creating thorough compliance reports and automating processes. By harnessing AI-driven insights, this strategy not only boosts developer efficiency but also ensures that APIs conform to both organizational standards and industry best practices. The smooth integration of these technologies simplifies the compliance review process by offering real-time, actionable feedback to developers. This cutting-edge solution marks a significant advance in API management, allowing organizations to uphold high standards of quality and compliance within their API ecosystems.

​Microsoft Tech Community – Latest Blogs –Read More 

Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today we have an itinerary for a sailing trip in the Caribbean. I’d like to be able to filter on which days have snorkeling.

Sailing itinerary table with columns for Day, Destination, Sail Distance and Highlights. Highlights include different activities for each destination.

I ask Copilot to:

Add a column with Aye/Nay for which ports will include snorkeling

Copilot in Excel pane with the above prompt

Looking at B2:E12, here’s 1 formula column to review and insert in Column F:

Identifies whether snorkeling is mentioned in the highlights for each day by checking for the presence of the word “snorkel” and marking it as “Aye” if found or “Nay” if not.

=IF(ISNUMBER(SEARCH(“snorkel”,[@Highlights])),”Aye”,”Nay”)

Hovering over the Insert Column button, I see the proposed column.

Sailing itinerary table with columns for Day, Destination, Sail Distance, Highlights, and a preview of new snorkeling calculated column.

After clicking on Insert column, I see the new column added.

Sailing itinerary table with columns for Day, Destination, Sail Distance, Highlights, and new Snorkeling column.

Today we were just having a bit of fun with talk like a pirate day in showing what Copilot can do in Excel. Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today we have an itinerary for a sailing trip in the Caribbean. I’d like to be able to filter on which days have snorkeling.
 
Sailing itinerary table with columns for Day, Destination, Sail Distance and Highlights. Highlights include different activities for each destination.
 
I ask Copilot to:
 
Add a column with Aye/Nay for which ports will include snorkeling
 
Copilot in Excel pane with the above prompt
 
Looking at B2:E12, here’s 1 formula column to review and insert in Column F:
Identifies whether snorkeling is mentioned in the highlights for each day by checking for the presence of the word “snorkel” and marking it as “Aye” if found or “Nay” if not.
=IF(ISNUMBER(SEARCH(“snorkel”,[@Highlights])),”Aye”,”Nay”)
 
Hovering over the Insert Column button, I see the proposed column.
Sailing itinerary table with columns for Day, Destination, Sail Distance, Highlights, and a preview of new snorkeling calculated column.
 
After clicking on Insert column, I see the new column added.
 
Sailing itinerary table with columns for Day, Destination, Sail Distance, Highlights, and new Snorkeling column.
 
 
Today we were just having a bit of fun with talk like a pirate day in showing what Copilot can do in Excel. Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​

Hi,

When are Recurring Tasks going to be supported in Project for the Web?

Regards,

Ramón

​Hi,When are Recurring Tasks going to be supported in Project for the Web?Regards,Ramón  Read More

​