Category: Microsoft
Category Archives: Microsoft
Advice for a Dynamic Worksheet Selector
Hello, I am trying to make my code automatically paste data on all relevant dates. My issue is that it does no do this due to how my code currently works.
When the dates in C33:C59 cross over from 2025 to 2026 and beyond it should paste on the relevant dates but all I get is “Object variable or With block variable not set” because worksheet 2026 or 2027 is not set. So, is there a way for it to dynamically select the relevant worksheet using the date in C33:C59?
My current code for more context:
Option Explicit
Sub ValidateExportData()
Static LastProcessedRow As Long ‘ Static variable to keep track of the last processed row
Dim RequestForm As Workbook
Dim TaskCalendar As Workbook
Dim DataSource As Worksheet
Dim DataDestination As Worksheet
Dim TrialOwner As Range
Dim TrialTitle As Range
Dim TrialDate As Range
Dim LastRowDate As Long
Dim CurrentDate As Date
Dim OrangeColor As Long
Dim TargetRow As Long
Dim DateRange As Range
Dim Cell As Range
Dim DateCell As Range
Dim isWeekend As Boolean
Dim msg As String
Dim InsertRow As Long
On Error GoTo ErrorHandler ‘ Basic error handling
‘ Initialize variables and open workbooks
Set RequestForm = ThisWorkbook
Set TaskCalendar = Workbooks.Open(“S:SiteDepartmentPerson1Person2Task Management Calendar SystemTask Calendar.xlsx”)
Set DataSource = RequestForm.Worksheets(“Analysis Request Form”)
Set DataDestination = TaskCalendar.Worksheets(“2025”)
Set TrialOwner = DataSource.Range(“E11”)
Set TrialTitle = DataSource.Range(“E12”)
Set TrialDate = DataSource.Range(“E14”)
OrangeColor = RGB(255, 165, 0) ‘ Color code for orange
LastRowDate = DataDestination.Range(“B” & DataDestination.Rows.Count).End(xlUp).Row
‘ Set the range of dates to match
Set DateRange = DataSource.Range(“C33:C59”)
‘ Initialize the LastProcessedRow if it’s the first run
If LastProcessedRow = 0 Then
LastProcessedRow = 2 ‘ Assuming data starts from row 2
End If
‘ Disable screen updating for performance
Application.ScreenUpdating = False
‘ Check if there are rows left to process
If LastProcessedRow <= LastRowDate Then
‘ Process the current row
CurrentDate = DataDestination.Range(“B” & LastProcessedRow).Value
‘ Ensure CurrentDate is a date before proceeding
If IsDate(CurrentDate) Then
‘ Check if the cell color is not orange
If DataDestination.Range(“B” & LastProcessedRow).Interior.Color <> OrangeColor Then
‘ Loop through each date in the range C33:C59
For Each Cell In DateRange
If IsDate(Cell.Value) Then
‘ Check if the date is a Saturday or Sunday
isWeekend = Weekday(Cell.Value, vbSunday) = vbSaturday Or Weekday(Cell.Value, vbSunday) = vbSunday
If isWeekend Then
msg = “Weekend date found: ” & Cell.Address & ” with value ” & Cell.Value
MsgBox msg
‘ Insert a new row based on the weekend date
InsertRow = LastProcessedRow
If Weekday(Cell.Value, vbSunday) = vbSaturday Then
‘ Insert a new row below Friday
InsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value – 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1
DataDestination.Rows(InsertRow).FormatConditions.Delete
ElseIf Weekday(Cell.Value, vbSunday) = vbSunday Then
‘ Insert a new row below Monday
InsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value + 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1
DataDestination.Rows(InsertRow).FormatConditions.Delete
End If
‘ Insert new row and paste data
DataDestination.Rows(InsertRow).Insert Shift:=xlDown
DataDestination.Rows(InsertRow).FormatConditions.Delete
DataDestination.Cells(InsertRow, 4).Value = TrialOwner.Value
DataDestination.Cells(InsertRow, 5).Value = TrialTitle.Value
Else
‘ Find the row matching the date in C33:C59
Set DateCell = DataDestination.Range(“B:B”).Find(What:=Cell.Value, LookIn:=xlValues, LookAt:=xlWhole)
If Not DateCell Is Nothing Then
TargetRow = DateCell.Row
‘ Check if data already exists in the target row
If Application.WorksheetFunction.CountA(DataDestination.Range(“B” & TargetRow & “:B” & TargetRow)) > 0 Then
‘ Insert a new row below the matched row
DataDestination.Rows(TargetRow + 1).Insert Shift:=xlDown
TargetRow = TargetRow + 1 ‘ Update TargetRow to the new row
‘ Clear conditional formatting in the new row
DataDestination.Rows(TargetRow).FormatConditions.Delete
End If
‘ Paste the data into the correct row
With DataDestination
.Range(“D” & TargetRow).Value = TrialOwner.Value
.Range(“E” & TargetRow).Value = TrialTitle.Value
End With
End If
End If
End If
Next Cell
End If
End If
‘ Move to the next row
LastProcessedRow = LastProcessedRow + 1
Else
MsgBox “All rows have been processed.”
End If
Application.ScreenUpdating = True
Application.CutCopyMode = False ‘ Clear the clipboard
TaskCalendar.Save
‘ TaskCalendar.Close SaveChanges:=True
Exit Sub
ErrorHandler:
MsgBox “An error occurred: ” & Err.Description
If Not TaskCalendar Is Nothing Then
TaskCalendar.Close SaveChanges:=False
End If
Application.ScreenUpdating = True
End Sub
Hello, I am trying to make my code automatically paste data on all relevant dates. My issue is that it does no do this due to how my code currently works. When the dates in C33:C59 cross over from 2025 to 2026 and beyond it should paste on the relevant dates but all I get is “Object variable or With block variable not set” because worksheet 2026 or 2027 is not set. So, is there a way for it to dynamically select the relevant worksheet using the date in C33:C59? My current code for more context:Option ExplicitSub ValidateExportData()Static LastProcessedRow As Long ‘ Static variable to keep track of the last processed rowDim RequestForm As WorkbookDim TaskCalendar As WorkbookDim DataSource As WorksheetDim DataDestination As WorksheetDim TrialOwner As RangeDim TrialTitle As RangeDim TrialDate As RangeDim LastRowDate As LongDim CurrentDate As DateDim OrangeColor As LongDim TargetRow As LongDim DateRange As RangeDim Cell As RangeDim DateCell As RangeDim isWeekend As BooleanDim msg As StringDim InsertRow As LongOn Error GoTo ErrorHandler ‘ Basic error handling’ Initialize variables and open workbooksSet RequestForm = ThisWorkbookSet TaskCalendar = Workbooks.Open(“S:SiteDepartmentPerson1Person2Task Management Calendar SystemTask Calendar.xlsx”)Set DataSource = RequestForm.Worksheets(“Analysis Request Form”)Set DataDestination = TaskCalendar.Worksheets(“2025”)Set TrialOwner = DataSource.Range(“E11”)Set TrialTitle = DataSource.Range(“E12”)Set TrialDate = DataSource.Range(“E14”)OrangeColor = RGB(255, 165, 0) ‘ Color code for orangeLastRowDate = DataDestination.Range(“B” & DataDestination.Rows.Count).End(xlUp).Row’ Set the range of dates to matchSet DateRange = DataSource.Range(“C33:C59”)’ Initialize the LastProcessedRow if it’s the first runIf LastProcessedRow = 0 ThenLastProcessedRow = 2 ‘ Assuming data starts from row 2End If’ Disable screen updating for performanceApplication.ScreenUpdating = False’ Check if there are rows left to processIf LastProcessedRow <= LastRowDate Then’ Process the current rowCurrentDate = DataDestination.Range(“B” & LastProcessedRow).Value’ Ensure CurrentDate is a date before proceedingIf IsDate(CurrentDate) Then’ Check if the cell color is not orangeIf DataDestination.Range(“B” & LastProcessedRow).Interior.Color <> OrangeColor Then’ Loop through each date in the range C33:C59For Each Cell In DateRangeIf IsDate(Cell.Value) Then’ Check if the date is a Saturday or SundayisWeekend = Weekday(Cell.Value, vbSunday) = vbSaturday Or Weekday(Cell.Value, vbSunday) = vbSundayIf isWeekend Thenmsg = “Weekend date found: ” & Cell.Address & ” with value ” & Cell.ValueMsgBox msg’ Insert a new row based on the weekend dateInsertRow = LastProcessedRowIf Weekday(Cell.Value, vbSunday) = vbSaturday Then’ Insert a new row below FridayInsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value – 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1DataDestination.Rows(InsertRow).FormatConditions.DeleteElseIf Weekday(Cell.Value, vbSunday) = vbSunday Then’ Insert a new row below MondayInsertRow = DataDestination.Columns(“B”).Find(What:=Cell.Value + 1, LookIn:=xlValues, LookAt:=xlWhole).Row + 1DataDestination.Rows(InsertRow).FormatConditions.DeleteEnd If’ Insert new row and paste dataDataDestination.Rows(InsertRow).Insert Shift:=xlDownDataDestination.Rows(InsertRow).FormatConditions.DeleteDataDestination.Cells(InsertRow, 4).Value = TrialOwner.ValueDataDestination.Cells(InsertRow, 5).Value = TrialTitle.ValueElse’ Find the row matching the date in C33:C59Set DateCell = DataDestination.Range(“B:B”).Find(What:=Cell.Value, LookIn:=xlValues, LookAt:=xlWhole)If Not DateCell Is Nothing ThenTargetRow = DateCell.Row’ Check if data already exists in the target rowIf Application.WorksheetFunction.CountA(DataDestination.Range(“B” & TargetRow & “:B” & TargetRow)) > 0 Then’ Insert a new row below the matched rowDataDestination.Rows(TargetRow + 1).Insert Shift:=xlDownTargetRow = TargetRow + 1 ‘ Update TargetRow to the new row’ Clear conditional formatting in the new rowDataDestination.Rows(TargetRow).FormatConditions.DeleteEnd If’ Paste the data into the correct rowWith DataDestination.Range(“D” & TargetRow).Value = TrialOwner.Value.Range(“E” & TargetRow).Value = TrialTitle.ValueEnd WithEnd IfEnd IfEnd IfNext CellEnd IfEnd If’ Move to the next rowLastProcessedRow = LastProcessedRow + 1ElseMsgBox “All rows have been processed.”End IfApplication.ScreenUpdating = TrueApplication.CutCopyMode = False ‘ Clear the clipboardTaskCalendar.Save’ TaskCalendar.Close SaveChanges:=TrueExit SubErrorHandler:MsgBox “An error occurred: ” & Err.DescriptionIf Not TaskCalendar Is Nothing ThenTaskCalendar.Close SaveChanges:=FalseEnd IfApplication.ScreenUpdating = TrueEnd Sub Read More
Automatically Resize Windows to Fill Available Space When Snapping
“Is there a method to restore the option to manually resize windows instead of having them automatically fill the available space when snapped? Appreciate your help.”
”Is there a method to restore the option to manually resize windows instead of having them automatically fill the available space when snapped? Appreciate your help.” Read More
“NaviCMD Flashes Multiple Times a Day”
Throughout the day, I’ve observed that the “cmd” prompt briefly appears on my screen multiple times. Despite running antivirus scans that detect no threats, I remain puzzled about the source of this mysterious activity. I am unsure whether something is attempting to install or update without my knowledge. Can anyone provide suggestions on how I can investigate the cause of these frequent cmd flashes?
Throughout the day, I’ve observed that the “cmd” prompt briefly appears on my screen multiple times. Despite running antivirus scans that detect no threats, I remain puzzled about the source of this mysterious activity. I am unsure whether something is attempting to install or update without my knowledge. Can anyone provide suggestions on how I can investigate the cause of these frequent cmd flashes? Read More
Assistance Needed: Win11 Administrator Accounts Unable to Modify C Drive
Hello everyone,
There seems to be an issue where new accounts with Administrator privileges are unable to make changes to the C drive. Surprisingly, the account that was initially used to install Windows 11 is functioning properly. Additionally, even the YHotmail account used for activating Windows 11 has lost access to the OS drive.
Could anyone shed some light on why this is happening?
Hello everyone, There seems to be an issue where new accounts with Administrator privileges are unable to make changes to the C drive. Surprisingly, the account that was initially used to install Windows 11 is functioning properly. Additionally, even the YHotmail account used for activating Windows 11 has lost access to the OS drive. Could anyone shed some light on why this is happening? Read More
SharePoint Search returns people based on name of Distribution List of which person is a member
In SharePoint, doing a search for ‘Education’ for example.
Results include people who are members of an Exchange Online Distribution List (DL) whose name includes ‘Education’.
Nothing on the user accounts themselves refer to ‘Education’ – it is literally only that the people are members of the DL.
Testing in a different tenant, I am able to reproduce it, and indicates that it is specifically DLs affected – not Security or M365 groups
This is reported by my customer to have started occuring in the last 2 weeks.
No relevant config changes have been made on the customer side recently.
Anyone got any ideas whether this is a recent change, and if so, where it is documented?
In SharePoint, doing a search for ‘Education’ for example. Results include people who are members of an Exchange Online Distribution List (DL) whose name includes ‘Education’. Nothing on the user accounts themselves refer to ‘Education’ – it is literally only that the people are members of the DL. Testing in a different tenant, I am able to reproduce it, and indicates that it is specifically DLs affected – not Security or M365 groups This is reported by my customer to have started occuring in the last 2 weeks. No relevant config changes have been made on the customer side recently. Anyone got any ideas whether this is a recent change, and if so, where it is documented? Read More
8 new resources to enhance your Microsoft Viva adoption
In today’s fast-paced digital workplace, staying connected and productive is more important than ever. Microsoft Viva Engage, Amplify, and Connections can help your organization communicate and connect effectively to keep up with today’s continuous AI-driven digital transformation. These 8 new resources can help you on your Microsoft Viva adoption journey by offering various ways to leverage Viva to communicate and build communities. From streamlining multi-channel communications that enhance employee experience to extracting data-driven community insights, Viva is not only an employee experience tool; it’s an ROI-driven catalyst for rolling out new technology and accelerating AI.
Build communities in Viva Engage
Transform communications with Viva Engage and AI
Viva Amplify deployment guide
Corporate communications strategy playbook
News and announcements with Viva Amplify
Employee survey campaign playbook
Viva Connections overview
Build Viva Connections cards
Viva Engage
1. Build communities in Viva Engage
Building effective communities is a complex challenge, often hindered by the need to align with business objectives and strengthen the employee experience. Viva Engage addresses this by offering practical strategies and tools, to streamline community creation and management, as outlined in this guide. Explore how you can use AI-powered communications to build diverse communities that resonate with employees and support organizational growth.
2. Transform communications with Viva Engage and AI
Passive communication can undermine company culture and engagement, presenting a persistent challenge for leaders and communicators. In this guide, discover how you can use Viva Engage and AI to drive employee performance, scale culture, and innovate. As a bonus, this guide includes 6 objectives for optimizing your Engage experience – such as sharing urgent news across applications and empowering leaders to engage with their teams effectively.
Learn how you can leverage Microsoft Viva to accelerate your organization’s rollout of Copilot.
Viva Amplify
3. Viva Amplify deployment guide
Navigating the complexities of digital workplace communications can lead to information bottlenecks, with critical messages often missed. Fortunately, with the help of Viva Amplify, you can centralize your approach to multi-channel publishing and leverage insightful analytics to help ensure messages are effectively dispersed. This guide can help you quick start your Amplify deployment by helping you optimize content distribution, engage employees, and tailor communications. This guide also includes a peek into Viva Amplify’s product roadmap for 2024 and beyond.
4. Corporate communications strategy playbook
From gauging message reach to acting as a change agent, corporate communications can be challenging without the right insights. However, with the help of Viva Amplify and SharePoint News, you can develop and implement a corporate communications strategy that energizes employee engagement with precision. In this playbook, you can uncover 6 key best practices – including how to develop a compelling voice and expand reach with digital tools. Now is the time to implement a cutting-edge corporate communications strategy.
5. News and announcements with Viva Amplify
Communicating across your organization can be overwhelming, especially when redrafting messages for different channels and involving leaders with organization-wide campaigns. Viva Amplify offers a strategic solution, enabling effective campaigns and leadership involvement for impactful communication and employee engagement. In this guide, you will dig into Amplify’s robust analytics to measure campaign reach and engagement while also leveraging Viva Engage for targeted communications.
6. Employee survey campaign playbook
Conducting effective employee surveys can be a complex puzzle – with challenges in creating, conducting, and extracting actionable insights. In this playbook, discover how you can unlock a more engaged and responsive workforce by harnessing the power of Viva Amplify with the synergies of Viva Connections and Viva Engage. Learn how to boost survey engagement, personalize experiences based on outcomes, and explore analytics to listen to your employees.
Viva Connections
7. Viva Connections overview
Without a centralized yet dynamic source of truth, connecting and empowering employees for corporate success can be challenging. This guide offers strategic insights to harness a centralized platform that encourages employee engagement and organizational growth. Discover how you can configure Viva Connections to empower cohesive employee connectivity that can support up to 50 unique experiences.
8. Build Viva Connections cards
Creating engaging digital experiences across platforms like SharePoint, Teams, and Viva Connections can be a daunting task without a unified toolkit to streamline connectivity and extensibility. Viva Connections offers a solution of versatile cards, allowing you to build with low-code, pro-dev, or no-code models for streamlined user experiences and productivity. This guide provides insights into optimizing Viva Connections cards for various use cases – including corporate culture and frontline workers – and details on leveraging the Adaptive Card Extension architecture for a cohesive platform experience.
Continue your Microsoft Viva adoption journey
Take your adoption journey to the next level by exploring more resources on the Microsoft Viva adoption webpage. Foster a culture of continuous learning and collaboration with Microsoft Viva to stay agile and competitive in a rapidly changing world, driven faster by the continuous disruption of AI. Viva not only elevates your employee experience but also serves as a crucial asset for your organization’s competitive success.
Do you want to take your Microsoft Viva adoption journey even further? Pre-register today for the Microsoft 365 Community Conference in Las Vegas from May 6th – 8th, 2025 and secure your place with this special $150 discount code. Pre-register here. You don’t want to miss out!
Josh Hansen, Microsoft Viva Marketing
This blog was written with assistance from Copilot.
Microsoft Tech Community – Latest Blogs –Read More
Azure Infra Girls LATAM: Certificación AZ-900 (Azure Fundamentals)
La computación en la nube está revolucionando diversas áreas de la tecnología, incluyendo programación, datos, inteligencia artificial (IA) y seguridad. Para ayudar a los profesionales a especializarse en esta área en constante evolución, Microsoft está lanzando la iniciativa Azure Infra Girls. Este programa ofrece una serie de cuatro clases en vivo, gratuitas y en español, que se llevarán a cabo del 3 al 24 de septiembre, a las 12:30pm (GMT-6, Ciudad de México).
Para aquellos que desean profundizar en la computación en la nube y prepararse para la certificación AZ-900 Azure Fundamentals, tenemos una ruta de aprendizaje completa disponible en Microsoft Learn. Esta ruta aborda las principales áreas de la certificación, permitiéndote estudiar de forma gratuita y a tu propio ritmo. Además, al completar los cursos, podrás obtener certificados que pueden ser añadidos a tu perfil de LinkedIn, destacando tus nuevas habilidades y conocimientos.
Los módulos de Microsoft Learn para la certificación AZ-900 incluyen:
Descripción de los conceptos de la nube (25-30 %)
Descripción de la arquitectura y los servicios de Azure (35-40 %)
Descripción de la administración y la gobernanza de Azure (30-35 %)
Práctica para el examen:
Evaluación de sus conocimientos: estas evaluaciones le proporcionarán una infomacion general del estilo, la redacción y la dificultad de las preguntas que probablemente verá en el examen. A través de estas valoraciones, puede evaluar su preparación, determinar dónde necesita preparación adicional y llenar los vacíos de conocimiento para aumentar la probabilidad de aprobar el examen.
Demostración de experiencia: aquí puede experimentar con el aspecto del examen antes de realizarlo. Podrá interactuar con diferentes tipos de preguntas en la misma interfaz de usuario que usará durante el examen.
Microsoft Tech Community – Latest Blogs –Read More
Public preview: Microsoft Entra ID FIDO2 provisioning APIs
Today I’m excited to announce a great new way to onboard employees with admin provisioning of FIDO2 security keys (passkeys) on behalf of users.
Our customers love passkeys as a phishing-resistant method for their users, but some were concerned that registration was limited to users registering their own security keys. Today we’re announcing the new Microsoft Entra ID FIDO2 provisioning APIs that empowers organizations to handle this provisioning for their users, providing secure and seamless authentication from day one.
While customers can still deploy security keys in their default configuration to their users, or allow users to bring their own security keys which requires self-service registration by a user, the APIs allow keys to be pre-provisioned for users, so users have an easier experience on first use.
Adopting phishing-resistant authentication is critical – attackers have increased their use of Adversary-in-the-Middle (AitM) phishing and social engineering attacks to target MFA-enabled users. Phishing-resistant authentication methods, including passkeys, certificate-based authentication (CBA), and Windows Hello for Business, are the best ways to protect from these attacks.
Phishing-resistant authentication is also a key requirement of Executive Order 14028 which requires phishing-resistant authentication for all agency staff, contractors, and partners. While most federal customers use preexisting smartcard systems to achieve compliance, passkeys provide a secure alternative for their users looking for improved ways to securely sign in. With today’s release of admin provisioning, they also have a simplified onboarding process for users.
With the Microsoft Entra ID FIDO2 provisioning APIs organizations can build their own admin provisioning clients, or partner with one of the many leading credential management system (CMS) providers who have integrated our APIs in their offerings.
Tim Larson, Senior Product Manager on Microsoft Entra, will now walk you through this new capability that will help in your transition towards phishing-resistant multifactor authentication (MFA).
Thanks, and please let us know your thoughts!
Alex Weinert
—
Hello everyone,
Tim here from the Microsoft Entra product management team. I’m excited to share with you our new passkey (FIDO2) provisioning capabilities in Entra ID!
Back in May we shared how we’re expanding passkey support in Microsoft Entra ID with the addition of device-bound passkey support in Microsoft Authenticator. As part of our commitment to provide more passkey capabilities we’ve enhanced our passkey (FIDO2) credential APIs to make onboarding security keys for users more convenient.
How does it work?
With the enhancements made to our passkey (FIDO2) credential APIs you can now request WebAuthn creation options from Entra ID and use the returned data to create and register passkey credential on behalf of a user.
To simplify this process, three (3) main steps are required to register a security key on behalf of a user.
Request creationOptions for a user: Entra ID will return the necessary data for your client to provision a passkey (FIDO2) credential. This includes information like user information, relying party, credential policy requirements, algorithms, and more.
Provision the passkey (FIDO2) credential with the creationOptions: Using the creationOptions utilize a client or script which supports the Client to Authenticator Protocol (CTAP), to provision the credential. During this step you’ll need to insert a security key and set a PIN.
Register the provisioned credential with Entra ID: Utilizing the output from the provisioning process, provide Entra ID with the necessary data to register the passkey (FIDO2) credential for the targeted user.
Build your own app or use a CMS vendor offering
In addition to providing the tools above, Microsoft has also collaborated with 10 leading vendors in the CMS space to integrate the new FIDO2 provisioning APIs. These vendors have rigorously tested and are fully knowledgeable in the new APIs, and are available to help you in your provisioning journey if creating your own integration isn’t something you want to do.
This partnership underscores our commitment to delivering a secure and interoperable ecosystem for our customers. These vendors represent a diverse range of CMS solutions, each bringing unique insights and expertise to the table. Their involvement has been instrumental in ensuring that the APIs are robust, versatile, and ready for real-world challenges.
As we roll out the public preview, we are proud to announce that these vendors have pledged their support, integrating the APIs into their platforms. This collaboration not only enhances the security landscape but also paves the way for seamless adoption across various industries.
What’s next?
This public preview is the next step in our passkey journey and we’re gearing up for even more passkey (FIDO2) provisioning features. We’re looking forward to building provisioning capabilities into the Entra admin center which will empower help desk and other admins the ability to directly provision FIDO2 security keys for users.
To learn more about everything discussed here, check out how to enable passkeys (FIDO2) for your organization and review our Microsoft Graph API documentation. Reach out to your preferred CMS provider to learn more about their integrations with the Microsoft Entra ID FIDO2 Provisioning APIs.
Thanks,
Tim Larson
Read more on this topic
Public preview: Expanding passkey support in Microsoft Entra ID – Microsoft Community Hub
Learn more about Microsoft Entra
Prevent identity attacks, ensure least privilege access, unify access controls, and improve the experience for users with comprehensive identity and network access solutions across on-premises and clouds.
Microsoft Entra News and Insights | Microsoft Security Blog
Microsoft Entra blog | Tech Community
Microsoft Entra documentation | Microsoft Learn
Microsoft Entra discussions | Microsoft Community
Microsoft Tech Community – Latest Blogs –Read More
Separate Calendar for Bookings
Hi all,
How can I set my personal Bookings page to add booked events to a separate calendar in my 365 account?
In Outlook, under My Calendars, I have the default “Calendar” for day-to-day activities, and I created a new calendar for “Bookings.” How do I set my Bookings page to add events to the “Bookings” calendar?
Thanks!
Hi all, How can I set my personal Bookings page to add booked events to a separate calendar in my 365 account?In Outlook, under My Calendars, I have the default “Calendar” for day-to-day activities, and I created a new calendar for “Bookings.” How do I set my Bookings page to add events to the “Bookings” calendar? Thanks! Read More
External storage for MS Teams videos
Hello
How to configure external storage for storing videos, recorded in MS Teams ?
Our team generate 800 GB of videos daily. It costs fortune to store them in SharePoint.
How do we configure our own S3 compatible storage, for uploading videos ?
Thanks
Hello How to configure external storage for storing videos, recorded in MS Teams ?Our team generate 800 GB of videos daily. It costs fortune to store them in SharePoint.How do we configure our own S3 compatible storage, for uploading videos ? Thanks Read More
MS Form – Grant access to a submitted form (record) to other users
Hi,
I created an MS Form and sent the link to users for submitting the form. The users need to edit the form after submission, so they save the form using the “Save my response to edit” option. The user then sends the submitted link to another user (reviewer) for reviewing the submitted data. However, the reviewer cannot access the link and receives the message “The URL is invalid.” Please help me with resolving this issue.
Note: The form is able to view/edit by the same submitted user.
Hi,I created an MS Form and sent the link to users for submitting the form. The users need to edit the form after submission, so they save the form using the “Save my response to edit” option. The user then sends the submitted link to another user (reviewer) for reviewing the submitted data. However, the reviewer cannot access the link and receives the message “The URL is invalid.” Please help me with resolving this issue. Note: The form is able to view/edit by the same submitted user. Read More
Change column from Date to Date-Time in a large list
Hi all,
I have a list that was created a few months ago, it now have around 25,000 items in it.
While doing a report yesterday, I realized that one of the column is set as Date only instead of Date-Time like other columns.
Even when created, it use Date-Time variable from power automate.
But because there is more than 5,000 items, that is prohibited, because it would put too much work load on the server.
The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.
How can I fix my table ?
Thank you
Hi all,I have a list that was created a few months ago, it now have around 25,000 items in it.While doing a report yesterday, I realized that one of the column is set as Date only instead of Date-Time like other columns.Even when created, it use Date-Time variable from power automate. But because there is more than 5,000 items, that is prohibited, because it would put too much work load on the server. The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited. How can I fix my table ? Thank you Read More
I need a formula or pivot table or something to pull info based on several factors
Ok, I thought I could just do this via vlookup, but I’m having trouble figuring out all the logic and syntax to it. Can I create a pivot table based on multiple tables? Automatic Data Analysis (that’s something I haven’t looked into, yet, and don’t know much about)?
Here’s what I have:
Two tables –
1. Employee data in columns A:R (showing alpha column and column reference for vlookup)
Date in col A (column ref 1)
Name in col C (column ref 3)
Emp ID in col D (column ref 4)
Cost Center in col F (column ref 6)
Work Center in col G (column ref 7) – may be blank or no matching value found
Hours in col M (column ref 13)
Hours type (Regular Hours, Overtime, etc.) in col O (column ref 15)
2. Work center and gang times (standard hours for day)
Row 7 column C through column H has dates of the week (i.e. 8/5/24, 8/6/24, etc.)
starting in Row 8 through row 50 column A has a Work center
columns C through H has the daily gang time for that work center
What I need to compare and data I need at the end:
Basically, I need to check if an employee has more regular hours than what the gang time shows. I’ll need to return the Date, Employee Name, Emp ID, Cost Center, Work Center and regular hours worked plus the static gang time for that work center for the day in order to visually show the variance.
So, output should just be a table of those employees whose timesheet has more hours than the standard for that day. no blank lines – not wanting to just look at the same row each time.
Here’s an example of the output
I’ve attached a sample doc for your visualization of the input data.
Thank you, in advance, for any help you can provide.
Ok, I thought I could just do this via vlookup, but I’m having trouble figuring out all the logic and syntax to it. Can I create a pivot table based on multiple tables? Automatic Data Analysis (that’s something I haven’t looked into, yet, and don’t know much about)? Here’s what I have:Two tables – 1. Employee data in columns A:R (showing alpha column and column reference for vlookup) Date in col A (column ref 1) Name in col C (column ref 3) Emp ID in col D (column ref 4) Cost Center in col F (column ref 6) Work Center in col G (column ref 7) – may be blank or no matching value found Hours in col M (column ref 13) Hours type (Regular Hours, Overtime, etc.) in col O (column ref 15) 2. Work center and gang times (standard hours for day) Row 7 column C through column H has dates of the week (i.e. 8/5/24, 8/6/24, etc.) starting in Row 8 through row 50 column A has a Work center columns C through H has the daily gang time for that work center What I need to compare and data I need at the end:Basically, I need to check if an employee has more regular hours than what the gang time shows. I’ll need to return the Date, Employee Name, Emp ID, Cost Center, Work Center and regular hours worked plus the static gang time for that work center for the day in order to visually show the variance. So, output should just be a table of those employees whose timesheet has more hours than the standard for that day. no blank lines – not wanting to just look at the same row each time.Here’s an example of the output I’ve attached a sample doc for your visualization of the input data. Thank you, in advance, for any help you can provide. Read More
Both my Email accounts have been hacked
Hi,
Recently both of my emails of my emails have been compromised by someone in a different country. They got past my 2F authentication(I wasn’t using an Authenticator though I will be from now on) and removed security from my account after getting in.
I can’t access either anymore as they’ve changed the passwords and the recovery email to their own. I did manage to get my account back briefly using security questions and proving I own it, but they accounts passwords and security was changed again within 15 minutes of me getting it back.
The main reason I’m putting this in here is because I cant seem to find any way of contacting Microsoft or the Outlook team to help with this issue as they require you to sign but I can’t.
Is there a number or email I can contact to help me block this person and get my accounts back?
Hi, Recently both of my emails of my emails have been compromised by someone in a different country. They got past my 2F authentication(I wasn’t using an Authenticator though I will be from now on) and removed security from my account after getting in. I can’t access either anymore as they’ve changed the passwords and the recovery email to their own. I did manage to get my account back briefly using security questions and proving I own it, but they accounts passwords and security was changed again within 15 minutes of me getting it back. The main reason I’m putting this in here is because I cant seem to find any way of contacting Microsoft or the Outlook team to help with this issue as they require you to sign but I can’t. Is there a number or email I can contact to help me block this person and get my accounts back? Read More
Repeat a cell value each month
I’m trying to build a budget ongoing cash flow, so I have an amount going out each month on a particular day. I would like to put in the amount and for that to repeat on the 3rd of each month.
My cells on the left have Provider-Amount-repeat day, Accpros the top I have the date.
Any help would be appreciated.
06/08/202407/08/2024Day in MonthTuesday Balance-£4.79 ü Gym£10.003
I’m trying to build a budget ongoing cash flow, so I have an amount going out each month on a particular day. I would like to put in the amount and for that to repeat on the 3rd of each month. My cells on the left have Provider-Amount-repeat day, Accpros the top I have the date. Any help would be appreciated. 06/08/202407/08/2024Day in MonthTuesday Balance-£4.79 ü Gym£10.003 Read More
Unable to update Windows 10
I am unable to update Windows 10 and was trying to increase the size of my partition.. I really dont know what Im talking about, but I have lost 3 remote jobs in the last month and a half because im unable to keep windows updated with KB5034441 & KB5001716. Can someone please help? Im about to lose job #4 if I cant get this fixed.
I am unable to update Windows 10 and was trying to increase the size of my partition.. I really dont know what Im talking about, but I have lost 3 remote jobs in the last month and a half because im unable to keep windows updated with KB5034441 & KB5001716. Can someone please help? Im about to lose job #4 if I cant get this fixed. Read More
Azure Specialization Query
Hello,
We are a solutions partner that is looking at obtaining a couple of advanced specializations in the Azure tracks. I have a couple of queries that I think are unclear from the checklists:
In the case of required evidence from customer projects for the various controls in the audit checklist, is it acceptable to have evidence from multiple customers for the various controls? Or do we need to satisfy the requirements across all controls for the same set of customers?Believe that customer projects cited across Module A and B can be different. Pls confimr my understanding.Is there a standard template available from/recommended by MSFT that is available for documentary evidence? Asking this for assets like Project Plan, Functional Specifications, Solution Design Documents, Architectural Diagram etcAlso are all of these required evidences mandatory for fulfilling the requirement of each control? Or do we provide some of them?
I know this post is long, but any direction/guidance here would be sincerely appreciated.
Thx!
Hello,We are a solutions partner that is looking at obtaining a couple of advanced specializations in the Azure tracks. I have a couple of queries that I think are unclear from the checklists:In the case of required evidence from customer projects for the various controls in the audit checklist, is it acceptable to have evidence from multiple customers for the various controls? Or do we need to satisfy the requirements across all controls for the same set of customers?Believe that customer projects cited across Module A and B can be different. Pls confimr my understanding.Is there a standard template available from/recommended by MSFT that is available for documentary evidence? Asking this for assets like Project Plan, Functional Specifications, Solution Design Documents, Architectural Diagram etcAlso are all of these required evidences mandatory for fulfilling the requirement of each control? Or do we provide some of them?I know this post is long, but any direction/guidance here would be sincerely appreciated.Thx! Read More
Threat Monitoring for GitHub Connector broken – 403 error
Hello,
I can deploy successfully the connector and all the other components, but when I put the Org name and the API key I get this error:
The permission in Github is the one requested and I even added +80 Azure IPs to our allowlist.
Still get the same error.
Appreciate any help.
Hello, I can deploy successfully the connector and all the other components, but when I put the Org name and the API key I get this error: The permission in Github is the one requested and I even added +80 Azure IPs to our allowlist.Still get the same error. Appreciate any help. Read More
“Microsoft 365 Backup – Commvault” 🎙 – The Intrazone podcast
You need reliable backup and restore of for your data, within hours – not weeks or months. Microsoft 365 Backup is your in-place solution for lightning-fast restorability, ensuring business continuity. We appreciate the value our partner ecosystem brings to extend our core offering.
On this episode, guest host, Brad Gussin (Principal PM Manager on the SharePoint team) and me provide an overview of the core Microsoft offering. You’ll then hear Brad (Microsoft) interview our valued partner, Brad Kirby (Senior Director of Product Management at Commvault) about their integration of Commvault Cloud with our Microsoft 365 Backup storage platform – extending data recoverability and searchability.
OK, this episode is all backed up and ready to restore your backup and recovery knowledge base.
The Intrazone, episode 112:
Subscribe to The Intrazone podcast + show links and more below.
Links to important on-demand recordings and articles mentioned in this episode:
Hosts, guests, and related links and information
Brad Kirby (Commvault) | LinkedIn | @Commvault [guest]
Brad Gussin | LinkedIn [guest co-host]
SharePoint | Facebook | @SharePoint | SharePoint community blog | Feedback
Mark Kashman |@mkashman [co-host]
Related videos, common admin articles and sites
“Microsoft Announces General Availability of Microsoft 365 Backup and Microsoft 365 Backup Storage” by Zach Rosenfield [July 31, 2024]
Learn more about Commvault’s Microsoft 365 Backup solution
Learn more about Microsoft 365 Backup (adoption.microsoft.com)
Watch “The Ins and Outs of Microsoft 365 Backup & Archive“
Microsoft Docs – The home for Microsoft documentation for end users, developers, and IT professionals.
Microsoft Tech Community Home
Stay on top of Office 365 changes
Listen to other Microsoft podcasts
Upcoming Events
TechCon365 – DC | Washington DC | Aug. 12-16, 2024
CollabDays Hamburg | August 31, 2024 – Hamburg, Germany
Microsoft Power Platform Conference | September 18-20 – Las Vegas, NV, USA
CollabDays Portugal Porto 2024 (previously CollabDays Lisbon)| Sept. 21 Venue: Instituto Superior de Engenharia do Porto
CollabDays New England | October 18-19, 2024 – Burlington, Massachusetts, USA
TechCon365 – Dallas | Nov. 11-15, 2024 | Dallas, TX, USA
Microsoft Ignite (+ more info) | Nov 18-22, 2024, “Save the date,” Chicago, IL
ESPC | European SharePoint Conference | Dec 2-5, 2024 | Stockholm, Sweden
+ always review and share the CommunityDays.org website to find your next event.
Subscribe today!
Thanks for listening! If you like what you hear, we’d love for you to Subscribe, Rate and Review on iTunes or wherever you get your podcasts.
Be sure to visit our show page to hear all episodes, access the show notes, and get bonus content. And stay connected to the SharePoint community blog and where we’ll share more information per episode, guest insights, and take any questions or suggestions from our listeners and SharePoint users via email at TheIntrazone@microsoft.com.
Get The Intrazone anywhere and everywhere
Listen to other Microsoft podcasts at aka.ms/microsoft/podcasts.
Microsoft Tech Community – Latest Blogs –Read More
Announcing General Availability of Workspaces in Azure API Management
We are excited to announce the general availability of workspaces in Azure API Management! Workspaces enable organizations to manage APIs more productively, securely, and reliably using a federated approach.
Enhanced Autonomy and Productivity
Workspaces bring a new level of autonomy to API teams, enabling them to create, manage, and publish APIs faster, more reliably, securely, and productively within an API Management service. By providing isolated administrative access and API runtime, workspaces empower API teams, while allowing the API platform team to retain oversight with central monitoring, enforcement of API policies and compliance, and publishing APIs for discovery through a unified developer portal.
Isolated Administrative Access and API Runtime
Workspaces function like “folders” within an API Management service. Each workspace contains APIs, products, subscriptions, named values, and related resources. Access to resources within a workspace is managed through Azure’s role-based access control (RBAC) with built-in or custom roles assignable to Microsoft Entra accounts.
Workspaces now offer API runtime isolation through association with a workspace API gateway, allowing teams to manage gateways and their configurations. Segregated runtimes ensure that faults, such as gateway resource starvation or cybersecurity incidents, are contained within individual workspaces, preventing them from affecting all organization’s APIs. Runtime isolation also enables attribution of issues and platform usage to a workspace.
Learn how to create a workspace in API Management.
Independent Deployment Lifecycles
Each workspace typically follows its own deployment lifecycle. The APIOps toolkit release 6.0.2 introduces support for automated deployment of workspaces across API Management services representing different environments. Additionally, the management API version 2023-09-01-preview enables programmatic management of workspaces.
Federated API Management with Workspaces
Workspaces bring first-class support for a federated model of managing APIs in Azure API Management, complementing the existing centralized and siloed models.
Centralized Model
In the centralized model, organizations use a single API Management service shared among multiple API teams without isolating administrative access or API runtime. While this setup simplifies API governance and discovery, it can cause the platform team to become a bottleneck as more API teams are onboarded. Additionally, runtime issues or misconfigurations can lead to platform-wide outages, with the API gateway being a single point of failure.
Siloed Model
In the siloed API management model, each API team owns and operates its own API Management service. While this approach provides full isolation of administrative access and API runtime missing in the centralized model, it leads to internal proliferation of services, making infrastructure maintenance challenging, increasing costs, and resulting in fragmented and ineffective API governance and discovery.
Federated Model with Workspaces
Workspaces enable organizations to adopt a federated approach to API management, combining the benefits of both centralized and siloed models. Workspaces allow API teams to independently, effectively, and efficiently manage APIs throughout their lifecycle, while platform teams can enforce runtime policies for APIs across workspaces, centralize platform logs and metrics (coming soon), implement chargeback by attributing gateway costs to teams in the organization, and facilitate API discovery and onboarding through a unified developer portal.
Upcoming Improvements
With their general availability, workspaces serve as an excellent tool for federating API management in organizations where teams need or benefit from full API runtime isolation. We are actively working on new features and improvements to workspaces:
Shared gateways: Optimize platform costs by associating multiple workspaces with a shared gateway, if complete runtime isolation between workspaces isn’t required
Managed identity support: Authenticate with user-assigned managed identity within workspaces
Regional availability: Use workspaces in API Management services in more regions
Faster provisioning: Create workspace gateways in minutes
Enhanced monitoring: Complement Application Insights telemetry with Azure Monitor logs and metrics
Get Started Today
By isolating administrative access and API runtime for API teams and centralizing API governance and discovery, workspaces increase productivity and improve the reliability and security of APIs managed with API Management. Learn how to get started with workspaces.
Migrating from Preview to Generally Available Workspaces
As part of the general availability of workspaces, we are discontinuing support for preview workspaces in API Management. To continue using workspaces created during the preview, you need to make the following changes:
Associate workspaces with a workspace gateway: Each workspace must be associated with a workspace gateway that isolates the workspace’s runtime traffic, enhancing API reliability, resiliency, and observability. In preview, workspaces shared a gateway with the service.
Remove workspaces’ dependency on service-level managed identity: Service-level managed identity can no longer be used in workspaces, as it may compromise the platform’s reliability and security. We are working on enabling managed identity support within workspaces.
Workspaces without a workspace gateway or relying on service-level managed identity will stop working after March 31, 2025. Learn more about these changes and how to migrate your preview workspaces. If you need to associate multiple workspaces with a shared gateway to migrate to the general availability version of workspaces, this feature will be available before the changes take effect.
Explore the power of workspaces and take your API management to the next level today!
Microsoft Tech Community – Latest Blogs –Read More