Category: Microsoft
Category Archives: Microsoft
Excel File type
Every file I create in Excel is saving with an excel file extension but the file icon is PDF so I cannot sent the file to anyone else to use.
Every file I create in Excel is saving with an excel file extension but the file icon is PDF so I cannot sent the file to anyone else to use. Read More
Inputting conditional coding into alternating rows in Lists
Hello,
I am attempting to use both alternating rows and conditional formatting in Microsoft Lists.
The short of it is this;
If [$field_4] is == [$field_6] I want it to code the whole line gray and text red.
Otherwise, I just want it to use alternating rows to make the separated items easily identifiable.
I am not super familiar with coding; so I basically just tried to use a modified version of the code from the conditional JSON, and plug it into the code for alternating rows.
I am not sure what I would need to enter in order to use alternating rows AND the conditional together.
Basically wanting an IF, Then, Else… But I know that those aren’t immediately usable in JSON without writing the logic for it.
Help please? Thanks in advance.
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json”,
“additionalRowClass”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$field_4]”,
“[$field_6]”
]
},
“sp-css-backgroundColor-BgLightGray sp-field-fontSizeMedium sp-field-bold sp-css-color-DarkRedText sp-field-borderTopBottomSemibold sp-field-borderTopBottomSolid sp-css-borderTopColor-DarkRedText sp-css-borderBottomColor-DarkRedText”,
“”,
{
“operator”: “==”,
“operands”: [
{
“operator”: “%”,
“operands”: [
“@rowIndex”,
2
]
},
0
]
},
“sp-css-backgroundColor-BgCornflowerBlue40”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
{
“operator”: “%”,
“operands”: [
“@rowIndex”,
2
]
},
1
]
},
“sp-css-backgroundColor-noFill”,
“”
]
}
]
}
}
Hello,I am attempting to use both alternating rows and conditional formatting in Microsoft Lists.The short of it is this;If [$field_4] is == [$field_6] I want it to code the whole line gray and text red.Otherwise, I just want it to use alternating rows to make the separated items easily identifiable.I am not super familiar with coding; so I basically just tried to use a modified version of the code from the conditional JSON, and plug it into the code for alternating rows.I am not sure what I would need to enter in order to use alternating rows AND the conditional together.Basically wanting an IF, Then, Else… But I know that those aren’t immediately usable in JSON without writing the logic for it.Help please? Thanks in advance. {
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json”,
“additionalRowClass”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“[$field_4]”,
“[$field_6]”
]
},
“sp-css-backgroundColor-BgLightGray sp-field-fontSizeMedium sp-field-bold sp-css-color-DarkRedText sp-field-borderTopBottomSemibold sp-field-borderTopBottomSolid sp-css-borderTopColor-DarkRedText sp-css-borderBottomColor-DarkRedText”,
“”,
{
“operator”: “==”,
“operands”: [
{
“operator”: “%”,
“operands”: [
“@rowIndex”,
2
]
},
0
]
},
“sp-css-backgroundColor-BgCornflowerBlue40”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
{
“operator”: “%”,
“operands”: [
“@rowIndex”,
2
]
},
1
]
},
“sp-css-backgroundColor-noFill”,
“”
]
}
]
}
} Read More
Top Stories: June 18, 2024
Find out more!
English Top Stories: June 18, 2024 | Microsoft
Français À la une : 18 juin 2024 | Microsoft
Español Novedades más relevantes: 18 de junio de 2024 | Microsoft
Português Notícias principais: 18 de junho de 2024 | Microsoft
Find out more!
English Top Stories: June 18, 2024 | Microsoft
Français À la une : 18 juin 2024 | Microsoft
Español Novedades más relevantes: 18 de junio de 2024 | Microsoft
Português Notícias principais: 18 de junho de 2024 | Microsoft Read More
Transform photos with Restyle Image in Microsoft Designer
Hello, Microsoft 365 Insiders,
Unleash your creativity with the new Restyle Image feature in Microsoft Designer! Using this new feature, transform your photos into stunning, stylized images with just a few clicks.
Explore this new feature and share your thoughts with us in our latest blog:
Transform photos with Restyle Image in Microsoft Designer
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hello, Microsoft 365 Insiders,
Unleash your creativity with the new Restyle Image feature in Microsoft Designer! Using this new feature, transform your photos into stunning, stylized images with just a few clicks.
Explore this new feature and share your thoughts with us in our latest blog:
Transform photos with Restyle Image in Microsoft Designer
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Webinar June 19, 2024 | Introduction to Copilot Partner Led Immersion Experience
Join us for a 45-minute session on June 19, 2024 on how to use the recently launched Partner-led Copilot Immersion Experience, providing partners the ability to demo and help customers with hands-on experiences.
In this session, we will walk you through each of the assets to drive adoption of Copilot for Microsoft 365 by role/persona and provide you guidance on the best way to utilize and demo with your customers–showcasing how Copilot can help businesses solve common problems and achieve more.
What is included?
Simulated click-thru demos for Sales, Marketing, HR, and Exec personas for each of the M365 apps. Finance, Legal, and Consulting personas are coming soon.
Facilitator Guide to help partners deliver a great experience
Participant Guide for end-users to follow along
How does it work?
Our guidance is to invite an entire department to a training session where you can spend 15 minutes showing what’s possible with Copilot using click-thru demos, 15 minutes for customers to try hands-on themselves with dummy content, and lastly 15 minutes for customers to progress their own projects by bringing their own files.
Register today to get started!
Microsoft Tech Community – Latest Blogs –Read More
What’s new in Azure AI Translator: document translation?
Seattle—June 18, 2024—Today, we are happy to announce new releases and enhancements to Azure AI Translator Service. We are introducing a new endpoint which unifies document translation async batch and sync operation and the SDKs are updated. Now, you can use and deploy document translation features in your organization to translate documents through Azure AI Studio and SharePoint without writing any code. Azure AI Translator container is now enhanced to translate both text and documents.
Overview
Document translation offers two operations: asynchronous batch and synchronous. Depending on the scenario, customers may use either operations or a combination of both. Today, we are delighted to announce that both operations have been unified and will share the same endpoint.
Asynchronous batch operation:
Asynchronous batch translation supports the processing of multiple documents and large files. The batch translation processes source documents from an Azure Blob storage and uploads translated documents back into it.
The endpoint for the asynchronous batch operation is getting updated to:
{your-document translation-endpoint}/translator/document/batches?api-version=[Date]
The service will continue to support backward compatibility for the deprecated endpoint. We recommend new customers adapt the latest endpoint as new functions in the future will be added to the same.
Synchronous operation:
Synchronous operation supports the processing of single document translation. It accepts source document as part of the request body, processes the document in memory and return translated document as part of the response body.
{your-document translation-endpoint}/translator/document:translate?api-version=[Date]
This unification is aimed to provide customers with consistency and simplicity while using either of the document translation operations.
Updated SDK
The updated document translation SDK supports both asynchronous batch operation and synchronous operation. Here’s how you can leverage it:
To run a translation operation for a document, you need a Translator endpoint and credentials. You can use the DefaultAzureCredential to try a number of common authentication methods optimized for both running as a service and development. The samples below uses a Translator API key credential by creating an AzureKeyCredential object. You can set endpoint and apiKey based on an environment variable, a configuration setting, or any way that works for your application.
Asynchronous batch method:
Creating a DocumentTranslationClient
string endpoint = “<Document Translator Resource Endpoint>”;
string apiKey = “<Document Translator Resource API Key>”;
SingleDocumentTranslationClient client = new SingleDocumentTranslationClient(new Uri(endpoint), new AzureKeyCredential(apiKey));
To Start a translation operation for documents in a blob container, call StartTranslationAsync. The result is a Long Running operation of type DocumentTranslationOperation which polls for the status of the translation operation from the API. To call StartTranslationAsync you need to initialize an object of type DocumentTranslationInput which contains the information needed to translate the documents.
Uri sourceUri = new Uri(“<source SAS URI>”);
Uri targetUri = new Uri(“<target SAS URI>”);
var input = new DocumentTranslationInput(sourceUri, targetUri, “es”);
DocumentTranslationOperation operation = await client.StartTranslationAsync(input);
await operation.WaitForCompletionAsync();
Console.WriteLine($” Status: {operation.Status}”);
Console.WriteLine($” Created on: {operation.CreatedOn}”);
Console.WriteLine($” Last modified: {operation.LastModified}”);
Console.WriteLine($” Total documents: {operation.DocumentsTotal}”);
Console.WriteLine($” Succeeded: {operation.DocumentsSucceeded}”);
Console.WriteLine($” Failed: {operation.DocumentsFailed}”);
Console.WriteLine($” In Progress: {operation.DocumentsInProgress}”);
Console.WriteLine($” Not started: {operation.DocumentsNotStarted}”);
await foreach (DocumentStatusResult document in operation.Value)
{
Console.WriteLine($”Document with Id: {document.Id}”);
Console.WriteLine($” Status:{document.Status}”);
if (document.Status == DocumentTranslationStatus.Succeeded)
{
Console.WriteLine($” Translated Document Uri: {document.TranslatedDocumentUri}”);
Console.WriteLine($” Translated to language code: {document.TranslatedToLanguageCode}.”);
Console.WriteLine($” Document source Uri: {document.SourceDocumentUri}”);
}
else
{
Console.WriteLine($” Error Code: {document.Error.Code}”);
Console.WriteLine($” Message: {document.Error.Message}”);
}
}
Synchronous method:
Creating a SingleDocumentTranslationClient
string endpoint = “<Document Translator Resource Endpoint>”;
string apiKey = “<Document Translator Resource API Key>”;
SingleDocumentTranslationClient client = new SingleDocumentTranslationClient(new Uri(endpoint), new AzureKeyCredential(apiKey));
To start a synchronous translation operation for a single document, call DocumentTranslate. To call DocumentTranslate you need to initialize an object of type MultipartFormFileData which contains the information needed to translate the documents. You would need to specify the target language to which the document must be translated to.
try
{
string filePath = Path.Combine(“TestData”, “test-input.txt”);
using Stream fileStream = File.OpenRead(filePath);
var sourceDocument = new MultipartFormFileData(Path.GetFileName(filePath), fileStream, “text/html”);
DocumentTranslateContent content = new DocumentTranslateContent(sourceDocument);
var response = client.DocumentTranslate(“hi”, content);
var requestString = File.ReadAllText(filePath);
var responseString = Encoding.UTF8.GetString(response.Value.ToArray());
Console.WriteLine($”Request string for translation: {requestString}”);
Console.WriteLine($”Response string after translation: {responseString}”);
}
catch (RequestFailedException exception)
{
Console.WriteLine($”Error Code: {exception.ErrorCode}”);
Console.WriteLine($”Message: {exception.Message}”);
}
Ready to use solution in Azure AI Studio
Customers can easily build apps for their document translation needs using the SDK. One such example is the document translation tool in the Azure AI Studio, which was announced to be generally available at //build 2024. Here is a glimpse of how you may translate documents in this user interface:
SharePoint document translation
The document translation integration in SharePoint lets you easily translate a selected file or a set of files into a SharePoint document library. This feature lets you translate files of different types either manually or automatically by creating a rule.
Learn more about the SharePoint integration here.
You can also use the translation feature for translating video transcripts and closed captioning files. More information here.
Document translation in container is generally available
In addition to the above updates, earlier this year, we announced the release of document translation and transliteration features for Azure AI Translator containers as preview. Today, both capabilities are generally available. All Translator container customers will get these new features automatically as part of the update.
Translator containers provide users with the capability to host the Azure AI Translator API on their own infrastructure and include all libraries, tools, and dependencies needed to run the service in any private, public, or personal computing environment. They are isolated, lightweight, portable, and are great for implementing specific security or data governance requirements.
With that update, the following are the operations that are now supported in Azure AI Translator containers:
Text translation: Translate the text phrases between supported source and target language(s) in real-time.
Text transliteration: Converts text in a language from one script to another script in real-time.
Document translation: Translate a document between supported source and target language while preserving the original document’s content structure and format.
References
User documentation
Document translation overview
Document translation API guide
Document translation SDK
Translate documents in Azure AI studio
SharePoint integration
Stream integration
Translator container
Microsoft Tech Community – Latest Blogs –Read More
Prompt engineering 101: Reimagine your workflow with Copilot for Microsoft 365
In the world of AI-powered collaboration, Copilot has emerged as a valuable tool for achieving desired outcomes. Whether you’re a seasoned user or just getting started, understanding the key ingredients for a successful interaction with Copilot is essential.
In the first two blogs in this series on prompt engineering, Prompt engineering 101: Create content in 3 simple steps with ASK AI and Prompt engineering 101 for images: Crafting detailed visual descriptions, we shared some quick tips to get started with effective prompting to get the best results from Copilot. Now we’ll share how to use Copilot prompts within Microsoft 365 to seamlessly pull content and insights from any source into the format and application you need.
Let’s dive into these four crucial elements:
Purpose and context: How can Copilot help?
Before engaging with Copilot, clarify your purpose. Are you seeking assistance with drafting documents, creating presentations, or analyzing data? Knowing your objective will guide your interactions.
Stakeholders: Who’s involved?
Identify the key players. Are you collaborating with a team, clients, or stakeholders? Recognize their roles and expectations. Copilot can adapt its responses based on the context you provide.
Expectations: How could Copilot meet your needs?
Set clear expectations. Specify the level of detail, tone, and format you desire. Copilot can generate content, but it’s up to you to review and refine it to align with your goals.
Information sources: What data should Copilot use?
Be explicit about the sources you want Copilot to draw from. Whether it’s existing documents, research articles, or internal guidelines, Copilot can incorporate relevant information.
Seamless workflows with Copilot
Copilot for Microsoft 365 is available as an AI-powered feature across Microsoft 365. This means that the power of AI can be accessed seamlessly in the apps you already know and use every day – Word, Excel, PowerPoint, Teams and more.
In Word, for example, Copilot appears in a new document to help you kickstart content from a blank page. Select “Draft with Copilot” and enter your prompt to being an outline, summary, or even long-form content.
Copilot can also “sit next to you” as your assistant as you write, edit, or read documents. When you open a document, the Copilot panel lets you quickly summarize, ask for editing suggestions, build an outline, or check for clarity:
The advantage of using Copilot in Microsoft 365 is that the power of AI is available to pull insights and create new content within the tools you already use. Copilot is also interoperable between apps – you can easily turn a Word document into a PowerPoint presentation or pull meeting notes from Teams into an email.
Learn more about the breadth of Copilot for Microsoft 365 and be sure to watch Jared Spataro’s Copilot demo where he shows how quickly you can create insights and content.
Example scenario: Launching a summer mentoring program
Let’s explore how Copilot can assist different teams involved in a nonprofit’s new mentoring program:
1. Program Management Team: Creating Guidelines and a Handbook (Copilot in Word)
Copilot generates a handbook for the summer mentoring program, outlining phases (initiation, planning, implementation, and evaluation).
It includes a checklist for mentors and mentees, clarifying their responsibilities during the program.
A sample schedule for 30-minute weekly check-ins is also provided.
2. Training Team: Crafting a Presentation (Copilot in PowerPoint)
Convert the handbook into a presentation using Copilot in PowerPoint.
Copilot outlines the introduction, phases, and checklist slides.
As an expert, review and tailor the content to match your vision.
3. Marketing Team: Engaging Volunteers via Email (Copilot in Outlook)
Draft an enthusiastic email to promote volunteering opportunities.
Copilot provides coaching, suggesting improvements to tone and formality.
Attach the mentoring program handbook for reference.
4. Fundraising Team: Analyzing Donor Contributions (Copilot in Excel)
Use Copilot in Excel to calculate total donations by donors.
Identify top donors for celebration and recognition.
5. Administrative Tasks: Capturing meeting notes (Copilot in Teams)
Record meeting notes and ask Copilot to summarize key points.
Copilot lists action items, streamlining follow-up tasks.
Remember, while Copilot streamlines tasks, your expertise ensures the final output aligns with your goals. Embrace the collaboration between human and AI, and let Copilot enhance your productivity across Microsoft 365 products.
Keep learning
Explore these resources and learning paths to keep building skills in Microsoft 365:
Microsoft Digital Skills Center for Nonprofits: aka.ms/TechSoup
AI skills for nonprofits collection on Microsoft Learn: aka.ms/AI-for-nonprofits-collection
LinkedIn Learning pathways for digital and AI fluency: aka.ms/MyLearningPathway
Note: This article was created in collaboration between the author and Microsoft Copilot.
Continue the conversation by joining us in the Nonprofit Community! Want to share best practices or join community events? Become a member by “Joining” the Nonprofit Community. To stay up to date on the latest nonprofit news, make sure to Follow or Subscribe to the Nonprofit Community Blog space!
Microsoft Tech Community – Latest Blogs –Read More
Partner Case Study Series | Uptale case study
Powerful training experiences with Uptale immersive learning on Microsoft Azure
Uptale is a software-as-a-service company providing an immersive learning platform for large and distributed enterprises in Europe, North America, and Asia. Uptale’s mission is to educate the workforce at scale by enabling anyone to create VR training. Uptale’s immersive learning platform on Azure makes situation-handling skills easy to digitize, distribute, and track. The Uptale solution features an intuitive virtual reality authoring tool to create simulated workplace environments plus distribution options to deliver consistent training content to any device, at any location, in real time. It also provides insights and analytics across workforce enablement programs.
Uptale is built on Azure and takes advantage of Azure Cognitive Services. Uptale utilizes Azure Speech services, including the Text to Speech service with new neural voices and Speech to Text for voice recognition in the Uptale VR Translator.
Continue reading here
**Explore all case studies or submit your own**
Microsoft Tech Community – Latest Blogs –Read More
Announcing the Public Preview of Upgrade Policies for Virtual Machine Scale Sets with Flexible Orche
Today we are announcing the public preview of upgrade policies for Virtual Machine Scale Sets with Flexible Orchestration. Upgrade policies allow for more granular control over the upgrade process, ensuring that your services remain available and responsive during updates.
Automatic upgrade policy
With an automatic upgrade policy, the scale set makes no guarantees about the order of virtual machines being brought down. The scale set might take down all virtual machines at the same time to perform upgrades.
Automatic upgrade policy is best suited for DevTest scenarios where you aren’t concerned about the uptime of your instances while making changes to configurations and settings.
Manual upgrade policy
With a manual upgrade policy, you choose when to update the scale set instances. Nothing happens automatically to the existing virtual machines when changes occur to the scale set model. New instances added to the scale set use the most update-to-date model available.
Manual upgrade policy is best suited for workloads where you require more control over when and how instances are updated.
Rolling upgrade policy
With a rolling upgrade policy, the scale set performs updates in batches. You also get more control over the upgrades with settings like batch size, max healthy percentage, prioritizing unhealthy instances and enabling upgrades across availability zones. Additionally, Rolling has the option to enable MaxSurge. MaxSurge deploys new instances running the latest model to replace instances using the old model. MaxSurge allows customers to maintain their full scale set capacity during the upgrade process, ensuring the entirety of their scale set is available to receive traffic
Rolling upgrade policy is best suited for production workloads that require a set number of instances always be available. Rolling upgrades is safest way to upgrade instances to the latest model without compromising availability and uptime.
Key Benefits
Keep scale set instances up to date and secure without impacting availability
Choose an upgrade policy that best fits your workload
Change and modify your upgrade policy at any time
Spend less time manually managing the upgrade process
Setting the Upgrade Policy
The upgrade policy can be set during scale set creation or change any time post creation. If you do not explicitly set an upgrade policy, it will default to manual.
During the Virtual Machine Scale Set creation in the Azure portal, under the Management tab, set the upgrade policy to Rolling, Automatic, or Manual.
Alternatively, for existing Virtual Machine Scale Sets, select the Virtual Machine Scale Set you want to change the upgrade policy for. In the menu under Settings, select Upgrade Policy and from the drop-down menu, select the upgrade policy you want to enable.
If using a Rolling Upgrade Policy, you can configure additional settings such as batch size, max unhealthy percentage or opt to use MaxSurge which will help to ensure your application remains fully up and running during the upgrade process.
Available Now
Upgrade policies for Virtual Machine Scale Sets with Flexible Orchestration are available in all public cloud regions. To get started, see Upgrade Policies for Virtual Machine Scale Sets.
Micah McKittrick
Microsoft Azure Compute Services
Senior Product Manager
Microsoft Tech Community – Latest Blogs –Read More
Skype for Business Server Roadmap Update
Today, we are providing an update on our product roadmap for Microsoft Skype for Business Server. Here’s what’s ahead:
We will release a Cumulative Update (CU)—CU8—for Skype for Business Server 2019 in H2 of 2024.
We will release Skype for Business Server Subscription Edition (SE) early in the third quarter of calendar year 2025.
Skype for Business Server SE, the next release of Microsoft Skype for Business Server, will be available for download from the Microsoft 365 admin center (previously the Microsoft Volume License Service Center) in early Q3 of 2025.
The licensing model for Skype for Business Server SE is the same as SharePoint Server Subscription Edition and Exchange Server Subscription Edition, which requires subscription licenses or licenses with active Software Assurance for server and user licenses.
The hardware, operating system, and other requirements for Skype for Business Server SE are the same as Skype for Business Server 2019.
Finally, Skype for Business Server SE will be supported under the modern lifecycle support policy.
Upcoming Changes in CU8
We’re adding Persistent Chat to Skype for Business Server 2019 in CU8 and completing our final phase of the Modern Admin Control Panel.
Persistent Chat
We are adding Persistent Chat (PChat) to Skype for Business Server 2019, which plays a pivotal role in promoting collaboration. PChat lets users create discussion rooms centered around specific topics, with those conversations persisted over time. Based on valuable feedback from our user community, we are providing an option to install PChat in our next CU.
Modern Admin Control Panel
We are also adding functionality to our new admin interface, the Modern Admin Control Panel (MACP), in our next CU.
This is the final phase for our updates to MACP. For information about previous phases, see Phase 1 (2019), Phase 2 (2020), and Phase 3 (2021).
This final phase includes:
IM & Presence: Dedicated tab for instant messaging and presence management.
Security: Centralizes security-related settings, allowing admins to configure access controls, authentication methods, and encryption protocols.
Monitoring & Archiving: Real-time monitoring and archiving capabilities to help admins keep track of system performance, user activity, and compliance requirements.
Network Configuration: Fine-tune network settings, optimize performance, troubleshoot issues, and ensure seamless connectivity.
Clients: Manage client applications, configure client policies, update versions, and address compatibility concerns.
Persistent Chat (PChat): Topic-based discussion rooms that persist over time.
Please start using the MACP today and share your feedback and questions using the ‘Give Feedback’ link.
Upgrading to Skype for Business Server SE from Previous Versions
To help accelerate the transition to Skype for Business Server SE, in addition to being code equivalent to Skype for Business Server 2019 CU8 (plus any subsequent Security Updates (SUs) or Hotfixes (HFs) to CU8), Skype for Business Server SE will support an in-place upgrade from Skype for Business Server 2019.
In-Place Upgrade
The fastest and easiest way to get to Skype for Business Server SE is to perform an in-place upgrade from Skype for Business Server 2019. The upgrade experience is identical to installing a CU. Once a server is running Skype for Business Server SE, it will be updated with our update cadence of periodic CUs and as-needed SUs and HFs.
Update Paths to Skype for Business Server SE
Below is a table that summarizes the available paths based on the version(s) you’re running:
Version in use
Upgrade Path
Skype for Business Server 2013
Upgrade to Skype for Business 2019 now, update to CU8 when available, and then upgrade in-place to Skype for Business Server SE when available.
Skype for Business Server 2015
Upgrade to Skype for Business 2019 now, update to CU8 when available, and upgrade in-place to Skype for Business Server SE when available.
Skype for Business Server 2019
Update to CU8 when available, and then upgrade in-place to Skype for Business Server SE when available.
Call to Action
Skype for Business Server SE will be available shortly before Skype for Business Server 2015 and Skype for Business Server 2019 both reach end of support on October 14, 2025. If you intend to continue to run Skype for Business Server on-premises, we recommend moving to Skype for Business Server 2019 with the latest update now, and upgrading to Skype for Business Server SE when it is available in 2025.
— Skype for Business Server Engineering Team
Microsoft Tech Community – Latest Blogs –Read More
June 2024: Azure Updates undergoing maintenance
Azure Updates website is undergoing maintenance. During this time, you may notice limited functionality affecting RSS feeds and search features. We apologize for any inconvenience this may cause. Thank you for your patience and understanding.
We are committed to bringing you weekly updates for Azure Updates, and will be posting them here, in the Tech Community every Thursday for the near term.
Critical updates and retirements will also be communicated via emails and service health alerts.
Microsoft Tech Community – Latest Blogs –Read More
Assigning tasks to multiple people
Hello Planner community, I’m trying to create a recurring Planner task that would be assigned to multiple people (ex. “Submit timesheet”). When assigning to more than one person, the task is “complete” when any one of the people completes it.
I can create a task for each person, but that becomes burdensome if the task is being assigned to a large number of people. I’m curious how others approach this problem and what workaround the community has come up with. Also curious, of course, what the Planner team has to say.
Hello Planner community, I’m trying to create a recurring Planner task that would be assigned to multiple people (ex. “Submit timesheet”). When assigning to more than one person, the task is “complete” when any one of the people completes it.I can create a task for each person, but that becomes burdensome if the task is being assigned to a large number of people. I’m curious how others approach this problem and what workaround the community has come up with. Also curious, of course, what the Planner team has to say. Read More
Pagination in Word
Please help me begin with page 1 on page 3 of document.
Thank you very much
markc12
Please help me begin with page 1 on page 3 of document. Thank you very much markc12 Read More
Export SharePoint Permissions
Hello Experts,
I am the site Owner for a Modern Teams SharePoint site (or Classic). The site permission is Private and I have several Permission Groups created with about 150 users assigned to a specific group (Region Read/Write, Region Read Only, Region Full Control, etc…).
I need to periodically review and reconcile the users assigned to this site’s permission groups with our Access Management tool to ensure that they match.
Does anyone have a solution for exporting a list of all site users with their assigned Permission Groups?
It seems that this is still a challenge without using PowerShell or having full company-level SharePoint Administration.
Is there a way a site Owner can do this?
Hello Experts, I am the site Owner for a Modern Teams SharePoint site (or Classic). The site permission is Private and I have several Permission Groups created with about 150 users assigned to a specific group (Region Read/Write, Region Read Only, Region Full Control, etc…). I need to periodically review and reconcile the users assigned to this site’s permission groups with our Access Management tool to ensure that they match. Does anyone have a solution for exporting a list of all site users with their assigned Permission Groups?It seems that this is still a challenge without using PowerShell or having full company-level SharePoint Administration. Is there a way a site Owner can do this? Read More
Exchange Online Best Practices
From an EMM / MDM perspective and on premise Exchange we would have a Secure Email Gateway (SEG) as a protection layer for email from devices. With O365 migrations is there an equivalent SEG to protect email access only from managed devices for example? And secondly, are gateways as relevant nowadays and should we instead look at 2fa, Purview and Conditional Access signal related stuff?
Any best practices and complete answers I am very grateful for. TIA.
From an EMM / MDM perspective and on premise Exchange we would have a Secure Email Gateway (SEG) as a protection layer for email from devices. With O365 migrations is there an equivalent SEG to protect email access only from managed devices for example? And secondly, are gateways as relevant nowadays and should we instead look at 2fa, Purview and Conditional Access signal related stuff?Any best practices and complete answers I am very grateful for. TIA. Read More
Formula to reveal the row number of where the duplicate value is located
Please help! Last week I found an excellent formula and now am kicking myself for not saving it.
I’m working on a large spreadsheet. On 2 columns, I have run the Conditional Formatting / Duplicate Values and highlighted the duplicates. I need the formula to add the Row Number where the duplicate is located.
Example: 2 columns referred to as A and B. In column C, I want to add the formula that shows the duplicate value is on B20001.
Please help! Last week I found an excellent formula and now am kicking myself for not saving it. I’m working on a large spreadsheet. On 2 columns, I have run the Conditional Formatting / Duplicate Values and highlighted the duplicates. I need the formula to add the Row Number where the duplicate is located. Example: 2 columns referred to as A and B. In column C, I want to add the formula that shows the duplicate value is on B20001. Read More
Microsoft Shared Bookings ignoring the bookings made by staff members
Hello,
I have tried using microsoft shared bookings and noticed the bookings created by staff members are not in sync with the bookings link.
For example If one of my staff members created a booking for 25th June 2024 10:00 AM. This time slot is still showing for our customers to book. It is supposed to block this particular time slot to avoid double booking. Can someone please help
Hello, I have tried using microsoft shared bookings and noticed the bookings created by staff members are not in sync with the bookings link. For example If one of my staff members created a booking for 25th June 2024 10:00 AM. This time slot is still showing for our customers to book. It is supposed to block this particular time slot to avoid double booking. Can someone please help Read More
Common items
Dear Experts,
I have an issue like this
So in Column A,B,C we have TEST sets TEST2/3/4 and have some items( rnti) in Column F/G we have the items( from another object say UE here) with TEST2/3/4 in column”F”,
I want to have the Common RNTI’s in both gNB/UE in Column K/K/L, example shown in J3/J4
Also , want to have the UE rnti’s in the same format as gNB(rnti’s) in column O/P/Q…, tried to do a failed attempt in Column “O”
Thanks in Advance,
Br,
Anupam
Dear Experts, I have an issue like thisSo in Column A,B,C we have TEST sets TEST2/3/4 and have some items( rnti) in Column F/G we have the items( from another object say UE here) with TEST2/3/4 in column”F”, I want to have the Common RNTI’s in both gNB/UE in Column K/K/L, example shown in J3/J4 Also , want to have the UE rnti’s in the same format as gNB(rnti’s) in column O/P/Q…, tried to do a failed attempt in Column “O”Thanks in Advance,Br,Anupam Read More
Unable to create logic app
Hi,
I am new to Azure I am learning the concepts
I am using free subscription and trying to create a logic app it is showing me the below message and not allowing me to create a logic app.
can someone help me with the issue? how to overcome
Thanks
Hi, I am new to Azure I am learning the concepts I am using free subscription and trying to create a logic app it is showing me the below message and not allowing me to create a logic app. can someone help me with the issue? how to overcome Thanks Read More
Simplifying Cloud Security with Azure Firewall Manager and Illumio
Introduction
In today’s dynamic and ever-evolving cloud environment, ensuring strong security measures is essential. This involves not only implementing the right tools, but also having effective processes in place to oversee and maintain these security measures. With Azure Firewall Manager, Microsoft offers a comprehensive and centralized platform to simplify the management of multiple firewalls at scale, addressing the challenges of managing security in a dynamic cloud landscape.
Illumio for Microsoft Azure Firewall helps Azure Firewall customers enforce Zero Trust Segmentation and go beyond network and application filtering. It helps the firewall operations teams understand rules with rich context of the resources they are protecting. With rich context, administrators can easily determine which resource is secured by the rule, who owns it, and perform rule lifecycle management more confidently.
By combining the robust features of Azure Firewall and Azure Firewall Manager with Illumio’s expertise in Zero Trust Segmentation, we aim to provide our customers with a powerful solution to navigate the complexities of modern cloud security effectively.
Illumio support in Azure Firewall Manager
Azure Firewall Manager is a centralized platform for managing firewalls, along with other core network security services, at scale. Illumio for Microsoft Azure Firewall is now directly accessible within Azure Firewall Manager.
Customers can seamlessly enable Illumio for Microsoft Azure Firewall by navigating to the “What’s New” section within Azure Firewall Manager.
This integrated approach enables users to more easily implement Illumio for Microsoft Azure Firewall and enable a comprehensive set of features and tools that seamlessly complement Azure Firewall, streamlining firewall management and bolstering overall network security measures.
Spotlight features
The Illumio platform boasts several standout features designed to streamline network security management and empower administrators of all skill levels. With its intuitive interface and robust capabilities, Illumio simplifies complex tasks and enhances visibility across the network. Let’s delve into some key features and walkthroughs for leveraging the platform effectively:
Comprehensive Network Overview:
Begin your day with a comprehensive view of your Azure network components and their status. Illumio offers a state-of-the art topology dashboard that provides real-time traffic flow data and visualizations. This dashboard enables administrators to visualize all network zones and their interconnections. By identifying which components are communicating with each other, administrators can quickly assess network health and pinpoint any potential security issues or anomalies requiring attention.
Adaptive Zero Trust Segmentation:
Zero Trust Segmentation or micro-segmentation is a critical strategy for reducing the attack surface and containing lateral movement within the network. Illumio micro-segmentation capabilities allows administrators to create logical segmentation policies based on workload attributes and communication patterns.
As an example, Illumio offers a robust labeling system, which adds a layer of contextual understanding and simplicity to the segmentation process. Labels serve as an intuitive way to categorize and identify different components within the network environment. Administrators can assign custom labels to workloads based on various criteria such as function, department, sensitivity, or compliance requirements. These labels, which can be in the form of text descriptors like “Dev workload,” “HR workload,” or “Sales workload,” offer a clear and contextual representation of the resources they represent.
As a result, administrators can create rules that explicitly permit or restrict traffic based on these labeled workloads, instead of relying on a set of IP addresses that are dynamic or more prone to errors. This enhances visibility and situational awareness across the networks, enhancing security posture and streamlining policy management.
Simulating and testing changes of the firewall policies.
Once Azure Firewall rules and policies have been configured, it’s important to validate these changes to ensure your organization’s network security standards are complying. Illumio offers features that streamline the process of simulating and testing firewall policy modifications.
Policy simulation: Illumio provides a policy simulation environment that enables administrators to forecast the impact of proposed firewall policy changes before implementation. By simulating different scenarios, one can assess potential security risks and validate the effectiveness of their policy adjustments without disrupting live production. This proactive approach helps prevent misconfigurations, reducing the likelihood of security breaches or service interruptions.
Traffic analysis: In addition, Illumio offers advanced traffic analysis that allows administrators to inspect network traffic patterns through Azure Firewall in real-time. This visibility enables administrators to adjust firewall policies to ensure that only authorized traffic is permitted, enhancing overall network security posture.
Conclusion
Whether an organization has a handful of firewalls or a vast network with numerous instances, Azure Firewall Manager addresses the common challenges security teams face when scaling Azure Firewall. Illumio helps to fill these gaps by making the deployment process of Illumio for Microsoft Azure Firewall more accessible, faster, and efficient for security teams of any size.
Read a step-by-step tutorial on getting started with Illumio for Microsoft Azure Firewall from the Azure Network Security Blog.
Microsoft Tech Community – Latest Blogs –Read More