Category: Microsoft
Category Archives: Microsoft
What Microsoft tools allow you to use Microsoft Reflect with your staff/students (check all that app
What Microsoft tools allow you to use Microsoft Reflect with your staff/students (check all that apply)?
¨ Microsoft Teams for Education
¨ PowerPoint
¨ Microsoft Word
¨ Class OneNote Notebook
¨ Microsoft Forms
What Microsoft tools allow you to use Microsoft Reflect with your staff/students (check all that apply)?¨ Microsoft Teams for Education¨ PowerPoint¨ Microsoft Word¨ Class OneNote Notebook¨ Microsoft Forms Read More
Controlling Data Egress in Azure
What Azure services allow data egress?
Virtual Network subnets or VMs without UDR or BGP Control – traffic can leave the default outbound access IP which is not controllable or managed by the customer.
Private VNETs will be available with secure by default enabled scheduled 2025 and will provide a means to disable this unmanaged Public egress pattern. – Azure Private Subnet
User Defined Route (UDR) – Routes added to UDRs can inject routes to VMs and services deployed to a subnet.
A UDR can have a route that directs traffic directly to the internet, but this traffic would go out as mentioned above via a customer unmanaged IP address.
If the Subnet has a NAT Gateway associated to it and has a route targeting traffic to next hop internet, it should reach the public internet via the NAT Gateway’s associated IP addresses.
If the Subnet has a route targeting traffic to next hop Azure Firewall or 3rd party NVA, the traffic will reach the internet via that devices route table or public IP address.
NAT Gateway – NAT Gateway plays a role in allowing a subnet to reach the internet from a specific IP address or prefix. This allows data to leave and reply to requests BUT does not allow an Ingress point for data.
A scenario here would be: I have an Azure VM that needs to reach out to our partner who whitelists IP addresses that can communicate with them. A NAT Gateway would allow that known public IP address to be provided to the partner without allowing unsecure access to your virtual machines. More information can be found here: NAT Gateway
VNET Gateway for Express Route or VPN (VNG) – Data can only leave Virtual Network Gateways if it is going through a Express Route or VPN (S2S or P2S). If traffic destined for the public internet is directed to the VNG, the traffic will drop. If you need traffic from subnets to leave a known IP address on your network, please leverage NAT Gateway. If Traffic is directed via a BGP or UDR entry to an on-prem IP address, the traffic can pass through the VNET Gateway over the secure connection to the on-prem IP address for egress.
Public IP Addresses – If an Azure VM or PaaS service has a public IP address, traffic will egress from that known published Public IP address.
For example, if a 3rd party network solution (Cisco or Palo Alto for example) is deployed on a VM in Azure with a public IP address associated to it, traffic on the internet would show that data’s source would be the public IP address assigned to the VM. Public IP Egress for VMs
External Load Balancer (ELB) – For example, if a 3rd party network solution (Cisco or Palo Alto for example) is deployed on a VM in Azure without a public IP address associated to it, but has a Public Standard Load Balancer attached, the traffic on the internet would show that data’s source would be the public IP address assigned to the ELB. Azure VM Outbound Connectivity Methods
For PaaS Services with Public IP addresses, it can reach the internet through its public IP Address. If the PaaS Service supports VNET integration, that traffic can be redirected to the appropriate network services to control/govern that data as needed. If VNET integration is enabled and the subnet connected to the PaaS service has a NAT Gateway or a UDR directing the applicable traffic, the traffic would come from that known IP address instead. Azure VNET Integration
Public IP Prefix – Public IP Prefixes allow a group of IP addresses to be used for data egress on services such as Virtual Machines, Standard Load Balancers, Azure Firewall, and VPN Gateway. The benefit of this service is to allow you to expand past the standard network limits for a single public IP address such as SNAT (Source NAT). Azure Public IP Prefix
Azure Firewall (AzFW) – Azure Firewall is a scalable Cloud-Native Firewall. AzFW can replace or supplement 3rd party network solutions in a number of secure network designs, but focusing on egress, traffic directed to the Azure Firewall can egress to the internet via a NAT Gateway or an associated public IP address. Azure Firewall Public IP Address
Azure Firewall has a huge number of security benefits which can be found: Azure Firewall Version Comparison
Now that we discussed what can egress, how can we monitor/secure it? What does this look like in practice?
Azure Network Security Group (NSG) – As mentioned in various documents, micro segmentation is a key component of ensuring zero trust and reducing attack surfaces for network attacks. When creating NSG rules – similar to ACLs (Access Control Lists) in other network solutions, ensure only approved traffic is allowed. NSGs
Example: If I have a web server running on a windows VM that doesn’t require egress, ensure the NSG rules specify:
Inbound:
Allow port 443 for https from its allowed sources at priority 100
RDP for management/access at priority 101
Implicit DENY for all inbound traffic at rule priority 4000.
Default rules at 65000, 65001, and 65500 should be ignored.
Outbound:
Allow outbound communication to authentication servers at priority 100
Allow outbound communication to DNS servers at priority 101
Allow outbound communication to management applications at priority 101
Implicit DENY for all outbound traffic at rule priority 4000.
Default rules at 65000, 65001, and 65500 should be ignored.
NSGs have default rules that allow certain traffic BEFORE the implicit deny. If you are advertising addresses through a Virtual Network Gateway from a Site-to-Site VPN or BGP configuration, the on-prem communication may be allowed as part of the ‘VNET communication’ default rule since it is a private address that announced to your Virtual Networks.
Flow Logs:
Only Option Until April 2024 – NSG Flow Logs – NSG Flow logs can help monitor what traffic is being allowed to reach the various sources including the public internet. This information can be sent to a SIEM solutions for central review of all traffic from Azure.
VNET Flow logs was released April 2024, can simplify the capturing of flow logs and be deployed per VNET instead of per subnet. – VNET Flow Logs
Azure UDR – User Defined Routes can control what routes are published to subnets in Azure and can control if routes from on-prem are published to Azure. Routes such as Communication to IP addresses, IP ranges, or Azure Services can be manipulated to direct traffic. For example, if an environment is using an Azure Firewall for Azure Native traffic, but all other traffic firewall should be going to a particular 3rd party solution to leave the environment:
Subnets will have a UDR that directs the applicable Service Tag will say next hop = Azure Firewall.
Azure Service Tags – A Service Tag is a Microsoft Managed logical grouping of public IP addresses in the Azure Backbone to provide access to services with or without region association. Examples can be found: Service Tags
Azure Policy
NSGs should be associated with all subnets
Flow Logs should be deployed to capture all data on networks in Azure.
Per Subnets – Flow logs should be configured for every network security group
Per Virtual Networks – Audit flow logs configuration for every virtual network
What can govern your Azure Data Egress requests?
Azure Firewall
Deploy Route Table to control traffic. Azure Firewall UDR Support
Network Rules on Azure Firewall to control traffic
3rd party NVAs (Palo, Cisco, Juniper, etc)
Deploy Route Table to control traffic. Azure Firewall UDR Support
Network Rules on NVAs to control traffic
Azure NSGs
Deployed per subnet as mentioned above.
In conclusion, the secure management of egress traffic is a critical component of our overall security posture. By adhering to the guidelines and principles outlined in this document, we fortify our defenses against potential threats and ensure the integrity of our data as it traverses beyond the confines of our internal network. Thank you for your commitment to upholding these standards and contributing to our collective security efforts.
Microsoft Tech Community – Latest Blogs –Read More
Load only filtered rows in Power Query
I have a source excel table on which I use Power Query to get a desired excel table (say Table1).
Now further I want to run a Power Query on Table1 based on the filtered rows only (which I want the query to pick up dynamically) to get another table.
How do I make Power Query pick up only the filtered rows from Table1?
I have a source excel table on which I use Power Query to get a desired excel table (say Table1). Now further I want to run a Power Query on Table1 based on the filtered rows only (which I want the query to pick up dynamically) to get another table. How do I make Power Query pick up only the filtered rows from Table1? Read More
Microsoft Power BI Data Analyst Blueprint Survey Opportunity
Microsoft is updating a certification for Microsoft Power BI Data Analyst, and we need your input through our exam blueprinting survey.
The blueprint determines how many questions each skill in the exam will be assigned. Please complete the online survey by June 24th, 2024. Please also feel free to forward the survey to any colleagues you consider subject matter experts for this certification. If you have any questions, feel free to contact Rohan Mahadevan rmahadevan@microsoft.com or John Sowles at josowles@microsoft.com.
Microsoft Power BI Data Analyst blueprint survey link:
https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_7VwTpdq5UFaCA8m
Microsoft is updating a certification for Microsoft Power BI Data Analyst, and we need your input through our exam blueprinting survey.
The blueprint determines how many questions each skill in the exam will be assigned. Please complete the online survey by June 24th, 2024. Please also feel free to forward the survey to any colleagues you consider subject matter experts for this certification. If you have any questions, feel free to contact Rohan Mahadevan rmahadevan@microsoft.com or John Sowles at josowles@microsoft.com.
Microsoft Power BI Data Analyst blueprint survey link:
https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_7VwTpdq5UFaCA8m Read More
Microsoft Planner: How Can I tag somone in Planner Task Commnet?
In Microsoft Planner – we would like to have the ability to tag someone in the comment of a task and as a result would expect that the people tagged would receive a notificationemail.
I was wondering if it is possible out of the box. If not – is there any plan to implement it ? And also if there are any external ad-on that could be used to achieve this
In Microsoft Planner – we would like to have the ability to tag someone in the comment of a task and as a result would expect that the people tagged would receive a notificationemail. I was wondering if it is possible out of the box. If not – is there any plan to implement it ? And also if there are any external ad-on that could be used to achieve this Read More
Tech Talks Presents: Enabling Secure Application and Process Modernization | June 13th
Join us on Thursday, June 13th at 8am PT as Principal Product Manager, Hazim Sharaf eldin presents Enabling Secure Application and Process Modernization.
Discover the transformative features of Microsoft Power Platform’s “Environment Groups and Rules” and “Default Environment Routing.” Learn how these features streamline governance, enhance efficiency, and empower administrators to manage environments at scale with ease.
We hope you’ll join us!
Call to Action:
Click on the link to save the calendar invite: https://aka.ms/TechTalksInvite
View past recordings (sign in required): https://aka.ms/TechTalksRecording
Get started with the adoption tools here
Join us on Thursday, June 13th at 8am PT as Principal Product Manager, Hazim Sharaf eldin presents Enabling Secure Application and Process Modernization.
Discover the transformative features of Microsoft Power Platform’s “Environment Groups and Rules” and “Default Environment Routing.” Learn how these features streamline governance, enhance efficiency, and empower administrators to manage environments at scale with ease.
We hope you’ll join us!
Call to Action:
Click on the link to save the calendar invite: https://aka.ms/TechTalksInvite
View past recordings (sign in required): https://aka.ms/TechTalksRecording
Get started with the adoption tools here Read More
CoreError::CDL_WORKER_FAILURE
I couldn’t find this error message anywhere. I try to use the online Teams and I get this error message.
I couldn’t find this error message anywhere. I try to use the online Teams and I get this error message. Read More
SPO File Preview not working properly
Hello, I have an issue where a user seems to be having file previews show up in a different view than everyone else. They are trying to access the same file and the links are identical.
The user with the issues can download and open the file but they are seeing a different preview tool and getting the “404 NOT FOUND” error.
Does anyone know why this is happening and how to fix it so users have the same experience.
User with Issue:
Standard User:
Hello, I have an issue where a user seems to be having file previews show up in a different view than everyone else. They are trying to access the same file and the links are identical. The user with the issues can download and open the file but they are seeing a different preview tool and getting the “404 NOT FOUND” error. Does anyone know why this is happening and how to fix it so users have the same experience. User with Issue:Standard User: Read More
Conectar excel y lista de sahrepoint
Cordial saludo , quisiera su apoyo con el siguiente problema : debo hacer una lista de SharePoint donde pueda actualizarla cada vez que se crea una fila en el archivo origen que seria un Excel ubicado en la nube, el cual a su vez es alimentado por otros archivos. El Excel que alimenta la lista tiene como 12 columnas con datos como fechas ,nombre ,números ,etc.
Intente con un flujo pero al actualizar vuelve y pone datos q ya se encontraba inicialmente
Cordial saludo , quisiera su apoyo con el siguiente problema : debo hacer una lista de SharePoint donde pueda actualizarla cada vez que se crea una fila en el archivo origen que seria un Excel ubicado en la nube, el cual a su vez es alimentado por otros archivos. El Excel que alimenta la lista tiene como 12 columnas con datos como fechas ,nombre ,números ,etc.Intente con un flujo pero al actualizar vuelve y pone datos q ya se encontraba inicialmente Read More
What’s new in Viva Insights
Updates to Copilot Dashboard
Configurable minimum aggregation threshold
The Copilot Dashboard allows users to filter analysis to a desired group, while hiding results if the selected group does not meet a minimum group size for user privacy. To enable customers with more control in specifying the desired privacy threshold, Viva Insights admins can now configure the minimum group size. The default minimum group size is set at 10 and can be lowered to a minimum of 5.
Copilot assisted hours breakdown by app and activity
Copilot assisted hours enables users to estimate the amount of time employees were assisted using Copilot. Users can now select How do we estimate this? to see a breakdown of the Copilot actions that contributed to the hours assisted, and can use the insights to better understand how the total hours assisted is calculated.
Date ranges
Specific date ranges that represent the time period of analysis have been added to the Copilot dashboard.
Microsoft 365 Copilot metrics now available in the metric library in Advanced insights
We’ve added the Microsoft 365 Copilot metrics to the metric library in Advanced insights. As a result, we’re removing the checkbox in the person query that lets analysts add the metrics to their person query. Analysts can now find these metrics in the metric library and in the “add metrics” step in a person query under the “Microsoft 365 Copilot” section.
Meeting cost and quality in the Viva Insights Teams app
With this set of new features, employees can improve meeting time for their colleagues or themselves, and managers and leaders can understand the business case for balancing meeting cost and quality within their organizations.
Each user can choose whether to view meeting cost as hours or currency, and they can edit those settings in the Viva Insights app. Admins can also adjust this setting for others.
Meeting cost and quality report
Eligible managers in Viva Insights will see a report about how much time their team spends in meetings and what share of it goes to high-cost large or long recurring meetings. Reviewing just one or two high-cost meetings can help many others get back their time.
“Like” button
Managers can show other people in their organization if they like the idea of reviewing meetings to balance meeting cost with meeting quality by selecting the Like button. When they do, they’ll be added to the list of people who have liked the scenario, and other Viva Insights users in the company may see their name or picture on related content. If the manager changes their mind, they can select the Like button again.
Meeting review card
The meeting review card is available for both managers and non-managers. The card has two faces: Meetings you organized, and Meetings you’re attending. The meetings I’ve organized side presents opportunities to improve meeting time for your colleagues, and the meetings I’m attending side presents opportunities to improve meeting time for myself. Users can see meeting insights, edit the meeting or their RSVP, or simply mark the meeting as “reviewed” to manage the list.
Meeting compose nudge
The meeting compose nudge encourages users to pay attention to the duration, frequency, and invitee list for high-cost meetings. When a user creates a new meeting in Outlook, it can trigger the infobar message to let the user know when the meeting cost (duration x frequency x invitees) is getting high.
The user can expand the message to open the Viva Insights add-in, which offers actionable suggestions. Accepting suggestions to reduce frequency or shorten duration will immediately update the invitation with a new, less costly configuration.
Viva Feature Access Management
If for any reason meeting cost features aren’t a good fit for some Viva Insights users, admins are able to toggle these features for groups or individuals using Viva Feature Access Management.
Data egress with Microsoft Graph Data Connect
We’re excited to announce the public preview release of Viva Insights data egress with partition support via Microsoft Graph Data Connect (MGDC). Customers can now export Viva Insights data (e.g., computed metrics, imported attributes) from any partition, using flexible queries that also support our PBI templates, into Azure storage. This feature enables customers to build custom analytical solutions by exporting and integrating Viva Insights data with external data or applications. They can integrate insights into business applications like CRM or perform more comprehensive analyses for purposes like workspace planning.
The MGDC export solution is scalable and secure, with the following benefits:
It allows for seamless data access at scale with integrations to the Azure toolchain to enable an accelerated path to insights.
It empowers administrators to review and explicitly consent to the types and amounts of data that applications may consume.
It alleviates concerns and allows organizations to establish detailed data governance policies about how sensitive data is handled, keeping customer data within a single, trusted service boundary.
Learn more about data egress via MGDC.
View Power BI templates in the advanced insights web app
We’re proud to announce the release of a new way to view Power BI templates in the advanced insights web app, leveraging Power BI embedded. With this new option, analysts no longer have to set up Power BI templates in Power BI Desktop, and can instead view them directly in the web app.
After successfully running a Power BI template query, analysts will find a new option to View it in the Query results page, along with the current Data export options, like download .csv.
Upon selecting View, a fully interactive Power BI template is opened. Analysts can navigate across the different pages in the report using the navigation menu and use all the features already available in our Power BI templates, like selecting the employee attributes to view and filter the report by web app.
Users with the Insights Analyst role can view Power BI templates in the advanced insights web app.
New out-of-the-box leader reports
New leader deep-dive reports in Viva Insights focus on customers, business operations, and agility. You can find these reports under Team insights in the Viva Insights app in Teams and on the web.
With these reports, leaders can view a variety of metrics and suggested actions focused on specific business outcomes. Leaders can further drill down into the insights with custom filters such as time periods and breakdowns by group.
The new reports include:
External focus
This report helps leaders understand how employees are managing external relationships, and how different parts of the company may have been impacted by business shifts.
This report can help leaders improve their strategies for communicating and collaborating with external groups. And for groups with increased external engagement, these insights can help leaders ensure these engagements don’t come at the expense of increased after-hours work.
New hire onboarding and integration
The New hire onboarding and integration report helps leaders understand the onboarding experience of new hires as well as the transition for employees who’ve started out in a new role within the company. The report also identifies opportunities to improve the onboarding and professional development experience.
Because research shows it takes new employees 12 months on average to reach their full performance potential, this report focuses on the entire 12-month period a new hire is learning, connecting, and developing in their new role.
This report can help leaders answer the following questions:
How are new hires developing their network, and how fast are they integrating into the organization’s network?
Are new hires getting the 1:1 coaching and support from their managers that they need?
Is the organization sufficiently encouraging new hires and employees to set aside time for learning and training?
Learn more about the new reports.
Microsoft Tech Community – Latest Blogs –Read More
Conditional Formatting Help with Percentages
Hi there,
I’m trying to do icon set conditional formatting on percentages in Excel. My ideal formatting would be a red icon for anything over 15%, yellow icon for anything between 10-14.9%, and green icon for anything less than 10%. Below is what I’ve selected in my parameters, but it’s not giving me my desired formatting. Can anyone assist me?
This is what is happening when I use the above parameters:
Hi there, I’m trying to do icon set conditional formatting on percentages in Excel. My ideal formatting would be a red icon for anything over 15%, yellow icon for anything between 10-14.9%, and green icon for anything less than 10%. Below is what I’ve selected in my parameters, but it’s not giving me my desired formatting. Can anyone assist me? This is what is happening when I use the above parameters: Read More
Screen artifacts, lines, and blurry text when connecting from macOS Microsoft Remote Desktop clients
We’re having many users reporting that they’re seeing screen artifacts, lines, and blurry fonts in their Windows applications. The issue appeared to have started recently, around the June 4, 2024. It seems to coincide with the latest update pushed by Microsoft, Remote Desktop Services SxS Network Stack:
This issue is occurring on Windows 10 and Windows 11 Azure Virtual Desktop machines and Windows 365 (Cloud PC), running Windows 10 and Windows 11 as well.
Users are also running Microsoft Remote Desktop version 10.9.7. Issue also occurred on users that were still running version 10.9.6.
There are several other folks in the Azure Virtual Desktop feedback forum reporting similar issues:
Vertical Lines appear for Azure Virtuals – Microsoft Community Hub
microsoft remote desktop macos graphic issue – Microsoft Community Hub
Microsoft, please get on this. I’ve opened a ticket in the Azure Help + Support interface.
We’re having many users reporting that they’re seeing screen artifacts, lines, and blurry fonts in their Windows applications. The issue appeared to have started recently, around the June 4, 2024. It seems to coincide with the latest update pushed by Microsoft, Remote Desktop Services SxS Network Stack: This issue is occurring on Windows 10 and Windows 11 Azure Virtual Desktop machines and Windows 365 (Cloud PC), running Windows 10 and Windows 11 as well. Users are also running Microsoft Remote Desktop version 10.9.7. Issue also occurred on users that were still running version 10.9.6.There are several other folks in the Azure Virtual Desktop feedback forum reporting similar issues:Vertical Lines appear for Azure Virtuals – Microsoft Community Hubmicrosoft remote desktop macos graphic issue – Microsoft Community HubMicrosoft, please get on this. I’ve opened a ticket in the Azure Help + Support interface. Read More
Power Platform & Dynamics 365 Newsletter – June 2024
June 2024 Edition
The newsletter is attached below.
Welcome to the June 2024 Edition – A large section is dedicated to Microsoft Build!
Power Platform and Dynamics 365 CE Newsletter!
As usual we have a lot of news and highlights to catch up on and plan!
No time to read it all, here are some quick reading recommendations:
Microsoft Build : Everything to know
Upcoming Microsoft events
Copilot for Sales extensibility News.
Review Power Apps, Dataverse, Copilot product updates.
Thanks & regards.
Power Platform & D365 Newsletter Team
—
Premier Support for Partners (PSfP) and Advanced Support for Partners (ASfP) are paid partner offerings at Microsoft that provide unmatched value through a wide range of Partner benefits including account management, direct-from-Microsoft advisory consultations, the highest level of reactive support available including up to 15-minute response times on critical cases, and coverage across cloud, hybrid, and on-prem.
Please review these resources to learn more and consider booking a meeting to speak directly with our teams for a better understanding of the value-added benefits of PSfP and ASfP.
Book a meeting with a PSfP Specialist
Book a meeting with an ASfP Evangelist
Visit the ASfP Website
Download the ASfP Fact Sheet
View the ASfP Impact Slide
Stop by the ASfP Partner Community
June 2024 Edition
The newsletter is attached below.
Welcome to the June 2024 Edition – A large section is dedicated to Microsoft Build!
Power Platform and Dynamics 365 CE Newsletter!
As usual we have a lot of news and highlights to catch up on and plan!
No time to read it all, here are some quick reading recommendations:
Microsoft Build : Everything to know
Upcoming Microsoft events
Copilot for Sales extensibility News.
Review Power Apps, Dataverse, Copilot product updates.
Thanks & regards.
Power Platform & D365 Newsletter Team
—
Premier Support for Partners (PSfP) and Advanced Support for Partners (ASfP) are paid partner offerings at Microsoft that provide unmatched value through a wide range of Partner benefits including account management, direct-from-Microsoft advisory consultations, the highest level of reactive support available including up to 15-minute response times on critical cases, and coverage across cloud, hybrid, and on-prem.
Please review these resources to learn more and consider booking a meeting to speak directly with our teams for a better understanding of the value-added benefits of PSfP and ASfP.
Book a meeting with a PSfP Specialist
Visit the PSfP Website
Book a meeting with an ASfP Evangelist
Visit the ASfP Website
Download the ASfP Fact Sheet
View the ASfP Impact Slide
Stop by the ASfP Partner Community
Forwarding only accepted meetings to a MTR resource account
Hello,
I am trying to forward all accepted meeting invites from a user to a specific MTR resource room. I have looked at the documentation but only see a way to forward all invites which the room auto accepts. Is there a way to automate this in poweshell?
Hello, I am trying to forward all accepted meeting invites from a user to a specific MTR resource room. I have looked at the documentation but only see a way to forward all invites which the room auto accepts. Is there a way to automate this in poweshell? Read More
List data validation suggested completions list is not fuctioning correctly in column A:A
Hi,
I’ve noticed Data Validation is not listing suggested completions, in a dropdown list shortened from the original list to include only valid completions, for column A:A only. (It used to).
Inserting a blank column A:A resolves the issue
Unchecking {View, Headings} resolves the issue
Only some users are affected
The user affected has the app based version of Excel through Office365, but others also have exactly that setup, and don’t have difficulties.
The list Data Validation references a named table on another sheet, that way users can extend the valid inputs easily, should they need to.
Why is only the first column affected? And why does inserting a blank column resolve it?
I should add, the cut down allowable completions list is visible for about 1/100th of a second, but only once. Then won’t appear again until you click away and click back.
Also, the dropdown arrow still provides access to the scrollable list in full.
Columns other than A:A on the same sheet have the same {named table, list Data Validation} arrangement and work perfectly.
Search engines suggest I’m not alone. (But then I got accused of hijacking someone else’s thread, so I hightailed it here instead!)
Thanks,
Michael.
Hi, I’ve noticed Data Validation is not listing suggested completions, in a dropdown list shortened from the original list to include only valid completions, for column A:A only. (It used to). Inserting a blank column A:A resolves the issueUnchecking {View, Headings} resolves the issueOnly some users are affected The user affected has the app based version of Excel through Office365, but others also have exactly that setup, and don’t have difficulties. The list Data Validation references a named table on another sheet, that way users can extend the valid inputs easily, should they need to. Why is only the first column affected? And why does inserting a blank column resolve it? I should add, the cut down allowable completions list is visible for about 1/100th of a second, but only once. Then won’t appear again until you click away and click back. Also, the dropdown arrow still provides access to the scrollable list in full. Columns other than A:A on the same sheet have the same {named table, list Data Validation} arrangement and work perfectly. Search engines suggest I’m not alone. (But then I got accused of hijacking someone else’s thread, so I hightailed it here instead!) Thanks, Michael. Read More
Microsoft Business Standard – Manage with PowerShell?
Hi,
Longtime Microsoft 365 admin but PowerShell & Azure newbie here. I have a need to to configure settings that only seem to be configurable via PowerShell (and not available in the Admin center GUI). However, everything I read seems to infer that PowerShell can be used just with Microsoft 365 Enterprise licenses. I would like to know whether PowerShell can be used with an organization that uses Business Basic and Business Standard licenses (Using Azure CloudShell and an Azure storage account)?
Thank you!
Hi, Longtime Microsoft 365 admin but PowerShell & Azure newbie here. I have a need to to configure settings that only seem to be configurable via PowerShell (and not available in the Admin center GUI). However, everything I read seems to infer that PowerShell can be used just with Microsoft 365 Enterprise licenses. I would like to know whether PowerShell can be used with an organization that uses Business Basic and Business Standard licenses (Using Azure CloudShell and an Azure storage account)? Thank you! Read More
Can STUN/TURN traffic for AVD vnet be routed directly to internet and not AzureFirewall/NVA?
I got a simple AVD pool with 4 hosts located in regionA. All hosts are in single vnetA which is globally peered with vnetB in regionB where AzureFirewall is. Route table is assigned to vnetA to route AVD traffic to internet and 0.0.0.0/0 to private IP of AF in vnetB.
With the ShortPath being made available for Public networks I left it turned on and added following ranges to route directly to internet from vnetA:
20.202.0.0/1613.107.17.41/3213.107.64.0/1852.112.0.0/1452.120.0.0/14
RTT is anywhere from 80 to 180ms for all clients that are local to the vnetA region where hosts are, which seems high.
Turning off ShortPath resulted in unexpected “GraphicsCapsNotReceived” errors which is a separate issue.
I got a simple AVD pool with 4 hosts located in regionA. All hosts are in single vnetA which is globally peered with vnetB in regionB where AzureFirewall is. Route table is assigned to vnetA to route AVD traffic to internet and 0.0.0.0/0 to private IP of AF in vnetB. With the ShortPath being made available for Public networks I left it turned on and added following ranges to route directly to internet from vnetA:20.202.0.0/1613.107.17.41/3213.107.64.0/1852.112.0.0/1452.120.0.0/14RTT is anywhere from 80 to 180ms for all clients that are local to the vnetA region where hosts are, which seems high. Turning off ShortPath resulted in unexpected “GraphicsCapsNotReceived” errors which is a separate issue. Read More
Conditional Formatting, just to change the the color of the font
@anyone I know there has to be a simple solution to this, and I’ve done it before, but for some reason the document I’m working on will not accept it. Not sure what I’m doing wrong.
I just need the numbers to show up black if they’re positive, or red if they’re negative. Blank background/empty cell. Help please?
@anyone I know there has to be a simple solution to this, and I’ve done it before, but for some reason the document I’m working on will not accept it. Not sure what I’m doing wrong.I just need the numbers to show up black if they’re positive, or red if they’re negative. Blank background/empty cell. Help please? Read More
My journey to the cloud with Microsoft Intune
We sat down with IT pros who have made the journey to cloud-native endpoints with Microsoft Intune and asked them what worked well, what didn’t, and how their day-to-day is different now that they are managing endpoints in the cloud.
In the condensed interviews, we hope you’ll find something you can relate to and get motivated to take the next steps in your own cloud journey. We’ve indexed the interviews and provided transcripts so you can find what you’re looking for – and if you can’t, join the conversation in the comments:
IT pro perspectives teaser
Hear from several IT pros and their quick thoughts on the journey to cloud-native endpoint management with Microsoft Intune.
Watch the video >
Anders Ljungdahl, Solution Architect, and Jennie Strömvall, IT Technician
Learn about their strategy when it came to deploying Intune and how it benefited their day-to-day activites.
Watch the video >
James Robinson, End User Computing Workstream Lead
Hear about a consultant’s experiences of customers and observations on the process of migrating to Intune.
Watch the video >
Walker McAninch, Senior Endpoint Engineer
Learn about the experience of migrating more than 1,000 devices to the cloud from an on-premises environment.
Watch the video >
We sat down with IT pros who have made the journey to cloud-native endpoints with Microsoft Intune and asked them what worked well, what didn’t, and how their day-to-day is different now that they are managing endpoints in the cloud.
In the condensed interviews, we hope you’ll find something you can relate to and get motivated to take the next steps in your own cloud journey. We’ve indexed the interviews and provided transcripts so you can find what you’re looking for – and if you can’t, join the conversation in the comments:
IT pro perspectives teaser
Hear from several IT pros and their quick thoughts on the journey to cloud-native endpoint management with Microsoft Intune.Watch the video >
Anders Ljungdahl, Solution Architect, and Jennie Strömvall, IT Technician
Learn about their strategy when it came to deploying Intune and how it benefited their day-to-day activites.Watch the video >
James Robinson, End User Computing Workstream Lead
Hear about a consultant’s experiences of customers and observations on the process of migrating to Intune.Watch the video >
Walker McAninch, Senior Endpoint Engineer
Learn about the experience of migrating more than 1,000 devices to the cloud from an on-premises environment.Watch the video > Read More
Replacement for S4UClient.UpnLogon in Windows Identity Foundation
Good morning, I need a replacement for the S4UClient.UpnLogon to be used with Windows Identity Foundation. The goal was to impersonate the SPWeb.CurrentUser in order to make a REST API call using HttpClient. However, the error “The name provided is not a properly formed account name” is encountered.
I tried to create an instance of Windows Identity using only SPWeb.CurrentUser.Name, but this resulted in the error “A specified logon session does not exist. It may already have been terminated.”
Additionally, I tried to create an instance of Windows Identity with a static user (Example: “CONTOSOuser1”), but this also led to the error “A specified logon session does not exist. It may already have been terminated.”
Good morning, I need a replacement for the S4UClient.UpnLogon to be used with Windows Identity Foundation. The goal was to impersonate the SPWeb.CurrentUser in order to make a REST API call using HttpClient. However, the error “The name provided is not a properly formed account name” is encountered.I tried to create an instance of Windows Identity using only SPWeb.CurrentUser.Name, but this resulted in the error “A specified logon session does not exist. It may already have been terminated.”Additionally, I tried to create an instance of Windows Identity with a static user (Example: “CONTOSOuser1”), but this also led to the error “A specified logon session does not exist. It may already have been terminated.” Read More
