Category: Microsoft
Category Archives: Microsoft
Filter a table using value selected in a list and filtering another table using the filtered values
Hi All,
I have the following tables
Table 1
TenderIDProjectTitleOrganisation2024_1Title 1Organisation12024_2Title 2Organisation22024_3Title 3Organisation32024_4Title 4Organisation4
Table 2
TenderIDTataSailJSPL2024_1YesNoYes2024_2NoYesYes2024_3YesYesYes2024_4YesNoYes
I want to select one of Tata, Sail, JSPL from a List
1. Basis the value selected, I want all those TenderIDs where value in Tata column is “Yes”
2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is “Yes”
Hi All, I have the following tables Table 1TenderIDProjectTitleOrganisation2024_1Title 1Organisation12024_2Title 2Organisation22024_3Title 3Organisation32024_4Title 4Organisation4 Table 2TenderIDTataSailJSPL2024_1YesNoYes2024_2NoYesYes2024_3YesYesYes2024_4YesNoYes I want to select one of Tata, Sail, JSPL from a List1. Basis the value selected, I want all those TenderIDs where value in Tata column is “Yes”2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is “Yes” Read More
MATRIX’S BACKGROUND COLOR
HI, I NEED A HELP
I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K.
I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX…
HOW CAN I DO THIS FOR EACH COLUMN YEAR?
THANKS
HI, I NEED A HELPI HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K.I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX… HOW CAN I DO THIS FOR EACH COLUMN YEAR? THANKS Read More
Surface Dock Connectivity Issues
Hi all,
Hoping someone can potentially provide some insight into the below issue in relation to a surface dock:
“connectivity to the external displays no longer works. The connector will charge the laptop and usb outputs work for phone charging etc. The screens/external display also work as have checked it with another laptop however will not allow display use.”
Any suggestions would be greatly appreciated.
Hi all, Hoping someone can potentially provide some insight into the below issue in relation to a surface dock: “connectivity to the external displays no longer works. The connector will charge the laptop and usb outputs work for phone charging etc. The screens/external display also work as have checked it with another laptop however will not allow display use.” Any suggestions would be greatly appreciated. Read More
Show value from table based on selection
Hi all
On an Excel spreadsheet tab I have a table with the following data:
YearSession% Passed% FailedAverageHighest2020July-2055454.882021July-2128725.052022July-2258424.262023July-2382184.062024July-2478224.27
On a separate tab I have the below table. On the data point column I have added a validation drop-down list of the above data points, i.e. % Passed, % Failed, Average and Highest. How can I then display that value in the data value column, taking into consideration the Year and Session? For example the first row below should show 58.
YearSessionData pointData value2022July-22% Passed58
Many thanks!
Hi all On an Excel spreadsheet tab I have a table with the following data: YearSession% Passed% FailedAverageHighest2020July-2055454.882021July-2128725.052022July-2258424.262023July-2382184.062024July-2478224.27 On a separate tab I have the below table. On the data point column I have added a validation drop-down list of the above data points, i.e. % Passed, % Failed, Average and Highest. How can I then display that value in the data value column, taking into consideration the Year and Session? For example the first row below should show 58. YearSessionData pointData value2022July-22% Passed58 Many thanks! Read More
PNP Connect with certificate
Hello. I have 2 registered applications in Azure. I genereted certificates and uploaded and also i granted permissions. Situation is weird because app1 i can acces from only one computer app2 from second. I cannot acces to app1 from pc2 and to app2 from pc1 because of this error:
Values are correct. Please help.
Best regards,
Kamil
Hello. I have 2 registered applications in Azure. I genereted certificates and uploaded and also i granted permissions. Situation is weird because app1 i can acces from only one computer app2 from second. I cannot acces to app1 from pc2 and to app2 from pc1 because of this error:Values are correct. Please help.Best regards,Kamil Read More
How to deploy SAP IQ-NLS Solution using Azure Premium Files on Azure.
SAP IQ High-Availability can be achieved with IQ Multiplex architecture [ SAP Note 2477758], but not when deployed in NLS mode. As per the SAP First Guidance for SAP IQ 16.x, here, Multiplex Architecture is not available/evaluated for the SAP-NLS solution. This blog outlines one of the methods for deploying SAP IQ-NLS utilizing Azure Premium Files on the Azure platform.
Overview
Several customers leverage SAP IQ for storing historical data, extracting aged data from the SAP BW system to enhance SAP BW performance and achieve cost efficiency. It’s crucial to meticulously design and implement the SAP IQ architecture to ensure that data remains online and accessible as per the demands of business processes. We collaborated with our partners and customers to develop an SAP IQ-NLS solution architecture on Azure, incorporating Azure Premium Files. This solution addresses to the customer’s need for SAP IQ High Availability across zones, aiming to achieve a Recovery Point Objective (RPO) of zero across zones in a Zonal Disaster Recovery (Zonal DR) setup. In this architecture, the Primary SAP IQ operates as a standalone system, with its database installed on Azure Premium Files using Zone-Redundant Storage (ZRS). The virtual machine (VM) is then replicated to the secondary zone through Azure Site Recovery [ASR].
As SAP does not provide an official reference for SAP IQ-NLS High Availability (HA)/Disaster Recovery [DR] architecture to meet RPO=0, a bespoke solution developed to fulfil the customer’s requirements. The DR solution has been developed and rigorously tested within the Microsoft Azure Cloud environment. It’s strongly advised that customers conduct thorough DR and performance testing of the scenario to ensure that it meets their business and performance needs.
Architecture Overview
The proposed solution comprises deploying two Virtual Machines (VMs) across different zones as active/passive SAP IQ deployment within the Azure East US region. One VM will serve as the Primary VM, hosting the SAP IQ binaries, while the other VM, deployed across a separate zone, will function as the Secondary VM using Azure Site Recovery for zonal DR.
Key Components
Virtual Machines:
Two VMs deployed across different zones in Azure East US.
Primary VM hosts SAP IQ binaries.
Secondary VM configured for zonal DR using Azure Site Recovery.
Azure Premium Files:
Database files hosted on Azure Premium Files with Zonal Redundant Storage (ZRS) feature for data redundancy across zones.
Azure Site Recovery (ASR):
For orchestrating failover to the Secondary VM in case of a zonal outage.
Recovery plan for seamless failover and Disaster Recovery requirements.
Backup Strategy:
Additional Azure managed disk to the Primary VM for regular backups.
Rubrik backup tool backup management capabilities.
Implementation Steps
VM Deployment:
Provision two VMs in Azure East US region across different zones.
Configure networking and security settings for optimal performance and security.
Azure Premium Files Setup:
Create Azure Premium Files storage account with Zonal Redundant Storage (ZRS) enabled.
SAP IQ Installation:
Install SAP IQ Software (binaries) on the Primary VM.
Database files on Azure Premium Files with ZRS feature.
Configure SAP IQ database files to be hosted on Azure Premium Files.
Azure Site Recovery Configuration:
Set up Azure Site Recovery for zonal DR between Primary and Secondary VMs.
Create recovery plan to automate failover process in case of a zonal outage.
Backup Management:
Attach an additional managed disk to the Primary VM for regular backups.
Configure Rubrik backup tool for comprehensive backup management.
Summary
Implementing SAP IQ database on Azure Premium Files ensures zone redundancy of the database files, making them available across zones to achieve an RPO of zero. The Virtual Machine hosting the SAP IQ Software will be a standalone Virtual Machine in the Primary zone, replicated to the target zone using Azure Site Recovery. This solution guarantees high availability of database files across zones and the ability to failover the compute across zones for Disaster Recovery purposes. This approach perfectly aligns with the customer’s requirements and provides a robust infrastructure for running critical SAP IQ workloads on Azure.
The architecture and documentation provided align with general best practices based on the Azure services, and it’s strongly advised that customers conduct thorough testing tailored to their business needs to mitigate any potential technical or business risks associated with deploying SAP IQ.
Additional related references:
Understand Azure Files performance | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Teams Speaker Coach preview – when will it be fully rolled out?
We would like to roll out Speaker Coach to our organization but are hesitant since it is still in “Preview” (since 2022). Is anyone aware of timing on this functionality moving out of Preview?
Preview: Speaker Coach in Microsoft Teams meetings – Microsoft Support
We would like to roll out Speaker Coach to our organization but are hesitant since it is still in “Preview” (since 2022). Is anyone aware of timing on this functionality moving out of Preview? Preview: Speaker Coach in Microsoft Teams meetings – Microsoft Support Read More
Crashes on Google Maps
Version 128.0.2664.0 (Offizielles Build) canary (64-Bit) crashes repeatedly on starting Google Maps.
Version 128.0.2664.0 (Offizielles Build) canary (64-Bit) crashes repeatedly on starting Google Maps. Read More
“Message from yourself” used to spam users.
Hello all,
a User was asking, how he got a message from “himself” he wasn’t writing.
I’m sure he wasn’t sending a spam link to himself.
Is it possible to check “messages with yourself” as admin or reconstruct the situation?
any Ideas?
Hello all,a User was asking, how he got a message from “himself” he wasn’t writing.I’m sure he wasn’t sending a spam link to himself.Is it possible to check “messages with yourself” as admin or reconstruct the situation?any Ideas? Read More
Swiss DCs Partner Update Call June 2024
Please find attached the pdf slides from this quarter’s partner Swiss DCs update call. The recording and AI recap is here: Regular Partner Q&A Call on CH DC-20240621_140141-Meeting Recording.mp4 (sharepoint.com)
Main info covered:
Please find attached the pdf slides from this quarter’s partner Swiss DCs update call. The recording and AI recap is here: Regular Partner Q&A Call on CH DC-20240621_140141-Meeting Recording.mp4 (sharepoint.com)
Main info covered:
New Public Customer Story
Luzerner Kantonsspital with partner Polypoint
Azure
Azure OpenAI GPT-4 Turbo and GPT-4o available as Provisioned Throughput in Switzerland North – PAYG not yet available, will be listed here:https://learn.microsoft.com/en-us/azure/ai-services/openai/concepts/models
Azure VMware Solution now generally available in Switzerland North
More powerful NVIDIA GPUs NVv5 now generally available in Switzerland North, enabling e.g. resource-intensive applications such as CAD for Virtual Desktop
Azure Storage Actions (preview), a fully managed platform that helps customers automate data management operations for Azure Blob Storage and Azure Data Lake Storage
Please approach me if your customers have a need for further workloads in Swiss DCs
Defender
Announcement Post | LinkedIn
Covered solutions: Microsoft Defender for Endpoint MDE, Microsoft Defender for Identity MDI and Microsoft Defender XDR as underlying platform
Be aware of a few specific points per the pdf or call recording
Next Call
Current call series will be extended, next call will be on Friday Sept 20 2024 14.00
Please approach me if you’d like to join as well Read More
Logic App Email Not Sending
Hello.
I have a Logic App that is supposed to check for Sentinel incidents every 10 minutes and send an email when an incident has been created. This only seems to work about 80% of the time and there is nothing obvious to me why emails aren’t sent for all incidents captured by the query. Run history shows a status of “Succeeded” every time.
Here is the LA;
The Recurrence is 10 minutes.
Query;
SecurityIncident
| where TimeGenerated >= ago(10m)
| summarize arg_max(TimeGenerated, *) by IncidentNumber
| where Severity != “Informational”
| where Severity != “Low”
| where Status != “Closed”
| extend AlertNum = tostring(AlertIds[0])
| extend Generated = format_datetime(datetime_utc_to_local(TimeGenerated, ‘US/Eastern’), “MM/dd/yyyy hh:mm tt”)
| project Title, AlertNum, IncidentNumber, Generated, Severity, Status, IncidentUrl
| join (SecurityAlert
| project SystemAlertId, Description
)
on $left.AlertNum == $right.SystemAlertId
If I run the query outside of the Logic App it always returns the incident.
Within the LA run history the indication is there are no results;
As mentioned, this work about 80% of the time, so the configuration of the Send Email step is properly setup.
Any suggestions appreciated.
Hello.I have a Logic App that is supposed to check for Sentinel incidents every 10 minutes and send an email when an incident has been created. This only seems to work about 80% of the time and there is nothing obvious to me why emails aren’t sent for all incidents captured by the query. Run history shows a status of “Succeeded” every time. Here is the LA;The Recurrence is 10 minutes.Query;SecurityIncident| where TimeGenerated >= ago(10m) | summarize arg_max(TimeGenerated, *) by IncidentNumber| where Severity != “Informational”| where Severity != “Low”| where Status != “Closed”| extend AlertNum = tostring(AlertIds[0])| extend Generated = format_datetime(datetime_utc_to_local(TimeGenerated, ‘US/Eastern’), “MM/dd/yyyy hh:mm tt”) | project Title, AlertNum, IncidentNumber, Generated, Severity, Status, IncidentUrl| join (SecurityAlert| project SystemAlertId, Description)on $left.AlertNum == $right.SystemAlertId If I run the query outside of the Logic App it always returns the incident. Within the LA run history the indication is there are no results;As mentioned, this work about 80% of the time, so the configuration of the Send Email step is properly setup. Any suggestions appreciated. Read More
Lesson Learned #504: Inserting Records from a CSV File using OPENROWSET into TempDB
Today, I would like to share how to insert records from a CSV file stored in Azure Blob Storage into a temporary table in TempDB in Azure SQL Database using OPENROWSET and a format file.
First, we need to create a database scoped credential and an external data source to access the Azure Blob Storage.
CREATE DATABASE SCOPED CREDENTIAL MyCredential
WITH
IDENTITY = ‘SHARED ACCESS SIGNATURE’,
SECRET = ‘sv=2022-11-02&ss=bfqt&srt=sco&sp=rwdlacupiytfx&se=2024-06-30T16:56:42Z&st=2024-06-21T08:56:42Z&spr=https&sig=tAjokk5xO9kc%3D’;
CREATE EXTERNAL DATA SOURCE MyDataSource
WITH (
TYPE = BLOB_STORAGE,
LOCATION = ‘https://blobstorage.blob.core.windows.net/demo’,
CREDENTIAL = MyCredential
);
In this situation, I would like to create a format file that defines the structure of the CSV file and how it maps to the table columns. Below is an example format file in XML.
<?xml version=”1.0″?>
<BCPFORMAT xmlns=”http://schemas.microsoft.com/sqlserver/2004/bulkload/format” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<RECORD>
<FIELD ID=”1″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”2″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”3″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”4″ xsi:type=”CharTerm” TERMINATOR=”,” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
<FIELD ID=”5″ xsi:type=”CharTerm” TERMINATOR=”rn” MAX_LENGTH=”50″ COLLATION=”SQL_Latin1_General_CP1_CI_AS”/>
</RECORD>
<ROW>
<COLUMN SOURCE=”1″ NAME=”Key” xsi:type=”SQLINT”/>
<COLUMN SOURCE=”2″ NAME=”NumData” xsi:type=”SQLINT”/>
<COLUMN SOURCE=”3″ NAME=”Col_01″ xsi:type=”SQLNVARCHAR”/>
<COLUMN SOURCE=”4″ NAME=”Col_02″ xsi:type=”SQLNVARCHAR”/>
<COLUMN SOURCE=”5″ NAME=”Col_03″ xsi:type=”SQLNVARCHAR”/>
</ROW>
</BCPFORMAT>
Save this format file and upload it to your Azure Blob Storage container.
Finally, we use OPENROWSET function to load data from the CSV file using the format file and insert it into a temporay table in TempDB.
SELECT *
INTO #test1
FROM OPENROWSET(
BULK ‘test1.csv’,
DATA_SOURCE = ‘MyDataSource’,
FORMATFILE =’format.xml’,
FORMATFILE_DATA_SOURCE = ‘MyDataSource’,
FIRSTROW = 2
) AS rows;
Microsoft Tech Community – Latest Blogs –Read More
New on Microsoft AppSource: June 7-13, 2024
We continue to expand the Microsoft AppSource ecosystem. For this volume, 193 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
Buddiz – AI for Schools & Higher Ed Colleges: Buddiz provides AI tools and solutions for schools, colleges, teachers, students, and parents, incorporating interactive chatbots into lesson planning and learning experiences. An advanced dashboard furnishes real-time analytics.
ChatGPTeMail: Najtech’s ChatGPTeMail add-in for Microsoft Outlook lets you compose and respond to emails through ChatGPT. Click the add-in icon to refine your draft’s language and tone. Compare versions before and after the transformation, then use them to elevate your professional correspondence.
Hardware Assets Inventory: Are you tired of using spreadsheets to track and manage your IT assets? IT Power’s app lets you view the status of your hardware assets from anywhere. Easily add new items, sort them into different categories, and monitor your stock. Access your inventory data from your mobile devices, your tablet, or your preferred browser.
HR Suite 360 – Human Capital Management (Start Package): HR Suite 360 from NEXXYSS offers a complete human resources solution, from recruitment to performance management. Keep employee records, track absences, store documents, and manage contracts. This offer is available in French.
Icon Map Pro: Icon Map Pro from Tekantis is a geospatial visualization tool designed for data analysts, GIS specialists, and business intelligence professionals. It offers background mapping, overlays, reference layers, and data layers. The tool provides seamless integration of geographic insights with an intuitive low-code or no-code Microsoft Power BI interface.
IndiGO Electronic Document: IndiGO Electronic Document from Indigo Technologies simplifies and automates the transfer of electronic documents for healthcare institutions. It ensures compliance with regulatory requirements and improves operational efficiency by centralizing information and reducing processing times and errors. This offer is available only in Spanish.
PleoMaintenance CMMS: PleoMaintenance from PleoData manages work orders, preventive maintenance scheduling, inventory parts, and asset costs via standard operating procedures built into workflows. Predict failures, eliminate downtime, and improve reliability with PleoMaintenance.
RENOVA2: RENOVA2 measures individual and group emotional well-being and relates this to organizational performance. Using advanced machine learning models trained on more than 90 groups, RENOVA2 identifies prevalent emotional well-being conditions in the Latin American population and issues personalized reports and recommendations. This offer is available only in Spanish.
SITA Mission Control SaaS: SITA’s Mission Control app enhances cross-functional cooperation in airline operations by connecting day-of-operations teams and driving increased collaboration through real-time air-ground information exchange. The app helps airlines better manage operational variability, turnarounds, fuel consumption, and carbon emissions.
Skypoint AI Platform for Social Services: Skypoint’s AI platform unifies all data sources into a data lakehouse and brings fragmented data into a social services-specific ontology. Streamline regulatory adherence, enhance staff scheduling, and customize care and wellness plans for residents based on data insights.
TriZetto Touchless Authorization Processing: TriZetto Touchless Authorization Processing (TTAP) is a cloud-based solution that automates healthcare prior authorization requests, streamlining the process and reducing turnaround time. It supports medical pre-planned inpatient and outpatient procedures, automates eligibility checks, and accommodates payer clinical guideline sets.
Vue.ai’s Intelligent Document Processing: Vue.ai automates document processing and workflows, allowing teams to improve accuracy and spare themselves repetitive manual tasks. Vue.ai is easy to use, handles all types of data, and has powerful AI features, such as pretrained and customizable models.
Waffle Chart Maker: The Waffle Chart Maker by VisioChart is a versatile and interactive tool for data visualization in Microsoft Power BI. It offers customizable features such as color, sorting, and display units, making it adaptable to different data representation needs. Cross-filtering enables comprehensive analysis, making it easier for stakeholders to understand and act upon insights.
Waterfall Chart: Waterfall Chart from VisioChart is a powerful visual tool for Microsoft Power BI to make your reports and dashboards informative and visually stunning. It automates variance calculations, year-over-year growth rates, and more, transforming your data into actionable insights. Customizable features ensure your chart is both aesthetically pleasing and functional.
Go further with workshops, proofs of concept, and implementations
Application Monitoring Solution with Microsoft Sentinel: AVASOFT’s consulting services aim to help you get started with or extend your use of Microsoft 365 by providing the expertise, capabilities, and know-how that you may lack in-house or need to enhance. In this engagement, AVASOFT will customize Microsoft Sentinel’s monitoring capabilities to offer detailed insights into your application’s performance and security.
CO2e Emissions Reporting Workshop: Lingaro offers sustainability expertise and data integration support to help companies accurately report carbon dioxide emissions. Using Microsoft tools like Power BI and Azure to manage, analyze, and visualize data, Lingaro’s experts will enable detailed reporting and analytics.
Continia Document Capture Installment, Workshop, and Support: Are you looking to implement Continia Document Capture? Navtilus can handle the installation process seamlessly, ensuring a smooth transition for your team. Navtilus will set up templates adjusted to fit your requirements, ensuring optimal performance and efficiency.
Copilot Change Management and Adoption: This workshop from ASI Solutions will give you hands-on experience with Microsoft 365 Copilot. Learn change management strategies to maximize the benefits of this transformative tool and provide the skills and support needed for successful adoption.
Copilot for Microsoft 365 Workshop: Inovasys will help your organization assess needs and build a plan for implementing Microsoft 365 Copilot so you can enhance productivity and gain access to resources, best practices, and community support to ensure successful implementation.
Copilot for Microsoft 365: 12-Week Impact Analysis Implementation: WM Reply offers a 12-week program to help organizations adopt Microsoft Copilot. The program includes a Copilot dashboard setup, employee surveys, focus groups, A/B testing, and ROI calculation. WM Reply provides expert mentorship to ensure effective and safe use of AI.
Copilot Microsoft 365: Workshop Sessions: This workshop from ASEE Solutions will teach participants how to integrate AI-powered tools into their daily duties, automating routine tasks and enhancing creativity. Topics will include drafting reports, summarizing data, and creating presentations.
Copilot Pro Adoption & Advisory Service: Logotel will implement DOJO, a tool based on Microsoft 365 that’s dedicated to the adoption of Microsoft Copilot. Employees can practice with a Microsoft AI assistant, facilitating fluid and effective adoption over time. Scale the impact of AI and unleash the potential of each person and team in your organization.
Dell Implementation Services for Copilot Security: Dell Technologies can maximize the full potential of your Microsoft Copilot for Security investment. Dell’s certified professionals will create customized prompts and ingest data from a range of security tools so your teams can gather intelligence, hunt threats, and effectively respond to any incident.
Device Domain Migration from On-Premises to Cloud: With the expertise of AVASOFT, your organization can efficiently migrate device domains from on-premises locations to the cloud, ensuring a secure and compliant environment while optimizing operational costs.
Device Monitoring with Microsoft Defender for Endpoint: Stay ahead of potential security breaches with the real-time monitoring and response capabilities of Microsoft Defender for Endpoint. In this offer, AVASOFT will help you manage and analyze device logs, gain activity insights, ensure compliance, centralize monitoring, and quickly identify and investigate security incidents.
Device Security Management with Microsoft Intune: Use Microsoft Intune to secure numerous devices and centralize control for easier management. In this offer, AVASOFT will help your organization implement Microsoft Intune to safeguard against cyber threats and ensure robust endpoint protection.
Dynamics 365 Business Central: 8-Week Implementation: AlphaBOLD will provide a hassle-free implementation of Microsoft Dynamics 365 Business Central. This will be preceded by a system gap analysis to identify needs, challenges, and automation opportunities. Post-go-live support will ensure system success through issue resolution, update management, ongoing training, and knowledge transfer.
Dynapt Advisory Services for Microsoft 365 Copilot: Dynapt offers AI advisory services for Microsoft 365 Copilot to enhance productivity, creativity, and innovation within organizations. The services include licensing planning, security configuration, usage setup, business case identification, pilot rollout, employee training, governance planning, and ongoing support.
Fabric in a Day: Workshop: Derevo’s workshop will accelerate your team’s adoption of Microsoft Fabric, an analytics platform that unifies data sources and tools like Azure Data Factory, Azure Synapse Analytics, and Power BI. Microsoft Fabric helps business professionals harness the potential of their data and lay the foundation for the AI era.
Increasing Efficiency with Copilot: Vision Software S.A.S will enable you to make the most of Microsoft 365 Copilot. Vision will explore different possibilities and business scenarios where Copilot can boost productivity, optimize performance, and foster dynamic collaboration. This offer is available only in Spanish.
Infosys Extending of Copilot Capabilities: Infosys can fast-track your AI journey. In this offer, Infosys will build custom copilots using Microsoft 365 Copilot and its prompts library. These copilots will automate tasks and address various persona needs in your organization.
Infra and Network Monitoring with Microsoft Sentinel: AVASOFT offers consulting services to help organizations efficiently monitor infrastructure and networks using Microsoft Sentinel. Proactive monitoring ensures resilience against threats. Focus on your business goals while AVASOFT manages your infrastructure and network security.
Integrating Microsoft Sentinel with Carbon Black EDR: Combine the power of Microsoft Sentinel analytics with Carbon Black EDR’s endpoint protection for comprehensive threat visibility. With AVASOFT’s assistance, your organization can efficiently integrate Microsoft Sentinel with Carbon Black EDR, ensuring a secure and compliant environment while optimizing operational efficiency.
Integrating Microsoft Sentinel with External EDR Service: In this offer, AVASOFT will seamlessly integrate Microsoft Sentinel with an external endpoint detection and response service to establish robust security, ensure compliance, centralize alert management, and enable proactive threat detection.
Microsoft Defender XDR Accelerator: This service from The Partner Masters will simplify your company’s security operations center workflow, reduce manual work, and provide a comprehensive view of threats. Experts from The Partner Masters will plan, design, deploy, and configure a pilot of Microsoft Defender XDR with the option for full production deployment.
Microsoft Multi-Cloud Security Engagement: 2-Week POC: Long View will use Microsoft Defender for Cloud to enhance your organization’s cloud security. Long View will establish foundational cloud security posture management, then activate cloud workload protection features to detect API threats and vulnerabilities across up to five resources.
Microsoft Volume Licensing: IT Partner’s experts will help you choose the right licensing program for your organization, as well as track renewals and monitor pricing adjustments. This will ensure you get maximum value from your Microsoft 365 investment while staying compliant and ready for audits. The service requires at least one legal business entity and the intent to purchase five products.
Power BI Migration Accelerator: 3-Week Proof of Concept: This service from iLink Systems helps businesses transition from IBM Cognos Analytics or Qlik Sense to Microsoft Power BI. It offers support for the latest Power BI features, as well as advanced data modeling and streamlined model editing and management. Minimal business interruption is ensured, and ongoing support will be provided.
Security Operations Center with Microsoft Sentinel: AVASOFT offers consulting services to help businesses efficiently manage security operations using Microsoft Sentinel. In this engagement, AVASOFT will empower your business with a security operations center powered by Microsoft Sentinel. This will streamline monitoring and analysis so your team can easily track security events and anomalies.
Self Service with Power BI: From Requirement to First Insightful Report in 4 Hours: This workshop from ITGAIN Consulting teaches skills for developing insightful reports using Microsoft Power BI, with a focus on a manufacturing company facing a drop in profit. Participants will enhance their analytical skills and visualize solutions in Power BI. The workshop can be held on-site or remotely in English or German.
SMB Readiness Workshop for Microsoft 365 Copilot: Intended for small and medium-sized businesses with 50 to 300 user, this workshop from Clear Concepts assesses readiness for Microsoft 365 Copilot. Clear Concepts will discuss the tool’s benefits, technical requirements, and licensing, then determine cloud environment readiness and deployment timelines.
Sustainability Reporting: CSRD: Lingaro offers comprehensive sustainability reporting services to help businesses comply with the European Union’s Corporate Sustainability Reporting Directive (CSRD). Lingaro will guide clients through the reporting process using Microsoft tools like Power BI and Azure.
Sustainability Reporting: US SEC: Lingaro offers expert services to guide clients through the United States Securities and Exchange Commission reporting process, with a focus on sustainability and climate-related disclosures. Lingaro will help you properly disclose greenhouse gas emissions and climate impacts, using Microsoft tools to provide accurate reporting.
Teams for GCC High: 3-Week Implementation: RSM’s Teams for GCC High is a secure communication and collaboration platform designed to meet the compliance needs of government entities. It utilizes Microsoft’s Cloud for Sovereignty, ensuring compliance with U.S. government regulations and requirements.
Unifying Microsoft Sentinel with Cloud Services: AVASOFT offers consulting services to help organizations unify Microsoft Sentinel with cloud services for comprehensive security coverage, centralized monitoring, and strengthened data protection. Deliverables include enhanced security and risk management, resource optimization, and centralized visibility and control.
Workshops: Solve the Right Problem the Right Way: This workshop series from Sirocco helps customers overcome obstacles and agree on goals for an initial project scope. The first workshop identifies the biggest barrier to their goal; the second discovers the root cause of the barrier; the third frames the problem for solutions; the fourth generates ideas to find innovative answers.
Contact our partners
1000minds Health-Related Quality of Life Value Set
9A Advanced Manufacturing – CAD/PLM Link
Access Charity CRM Add-in for Microsoft Outlook
Access Charity CRM Add-in for Microsoft Word
Accigo Readiness Assessment for Copilot for Microsoft 365
Accurate and Updated U.S. Denied Parties List (DPL)
ADAM AI Augmented Data Management Engine
AI Assistants for Healthcare Facilities
AI Consulting Services: 1-Day Workshop
AI LaunchPad: Custom AI Solutions for Office 365
AnaApp Sourcing & Vendor Management
APIVerve: Unified API Access for Streamlined Development
Aptean Production Costing for Food and Beverage
Assessment for Migration from Dynamics AX to Dynamics 365
AVL Data Analytics for Battery
B2C eCommerce for Dynamics 365 Business Central
Barcode API for Shipping Labels
BE-terna Incoming Document Register
Bionic Reading for Microsoft Word
BURQ iPaaS: eBay Integration with Dynamics 365 Business Central
CAP Logistics: Warehouse Operations
CAPEX & OPEX Authorization for Expenditure
Cloudmore Commerce Platform for Direct CSP Providers
Contract Management Extension for Dynamics 365
Coupler.io Revenue Dashboard for QuickBooks
DataPoint Add-in for PowerPoint
Devart Connector: Connect HubSpot to Excel
Devart Connector: Connect Magento to Excel
Devart Connector: Connect Mailchimp to Excel
Devart Connector: Connect Marketo to Excel
Devart Connector: Connect MySQL to Excel
Devart Connector: Connect NetSuite to Excel
Devart Connector: Connect Oracle to Excel
Devart Connector: Connect PostgreSQL to Excel
Devart Connector: Connect QuickBooks Online to Excel
Devart Connector: Connect Salesforce Marketing Cloud to Excel
Devart Connector: Connect Shopify to Excel
Devart Connector: Connect SQLite to Excel
Devart Connector: Connect SQL Server to Excel
Dynamics GP to Dynamics 365 Business Central Migration: 4-Week Assessment
EnterpriseGPT with Smart Search
Eyna: Advanced Package Management
Financials Template for SharePoint and Excel
Folderit DMS Add-in for Outlook
Frontline Worker Assessment for Healthcare
Gen AI-Powered Insurance Underwriter
Gen AI-Based Smart Credit Underwriter
Generative AI Community Support: 6-Month Service
GetAccept for Microsoft Dynamics 365
HCP Home Care Packages Aged Care Management for Microsoft Dynamics 365
High-Quality U.S. Publicly Listed Company Hierarchy
ILINX Process Improvement Platform
InsightStore Consumer Analytics Platform
KUBE 365 Business Process Automation Platform
Kyriba Open Reports Studio – Emerald
Kyriba Open Reports Studio – Quartz
Local Government Accelerator: 1-Hour Assessment
Microsoft 365 Copilot: 4-Week AI Assessment
Microsoft 365 Optimization Assessment
Microsoft 365 Threat Assessment
Mobile Time Tracking for Microsoft Dynamics 365
Nanhua Futures Assistant for Microsoft Excel
OnePortal: Digital Grid Connection Requests
OneTrust Data Activation and Compliance Risk Platform
Oraya Insights: Market Monitoring Your Way
Patient Experience: 2-Hour Briefing
Power Apps Process Coordination: Workshop & Assessment
Proactive Security Monitoring Service
ProcessNx Business Process Digital Transformation Platform
Real-Time Production Monitoring & Analytics
RingCentral RingCX for Dynamics 365
SAGE: Consumer Insights AI Assistant
Security and Compliance Assessment with Microsoft Purview
Service Portal for Dynamics 365 Business Central
SSH’s Electronic Invoice Solution for Mexico
Stock Trading Platform Monitor
The Last Business Card – NFC Digital Business Cards
Thomson Reuters Legal Task Manager
TRASER DMS 365 x Continia Document Capture
With Copilot Plugin Extension for ITSM
XTEL AI Enterprise Analytics Suite
Yooz Connector for Finance and Supply Chain Management
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
Unlock the power of Microsoft Education in your Learning Management System
Microsoft Education is committed to supporting educators and learners with engaging and inclusive learning experiences, wherever teaching and learning happens. Whether you teach and learn in a physical classroom, online, or in a hybrid mode, Microsoft Education has the tools and resources to help you achieve your goals. One of the ways we do this is by integrating our products and services with popular Learning Management Systems (LMS). Building on our previous work to bring Microsoft 365 documents, Microsoft Teams collaboration, OneNote Class Notebooks, and Microsoft Reflect into LMS platforms, our new integration of Teams Assignments represents a leap forward in bringing more of the unique value of Microsoft Education directly to LMS users.
Achieve More with Assignments in your LMS
The new Teams Assignments integration brings unique new capabilities into your LMS, saving educators time, and providing powerful tools to accelerate learning. For example, with Teams assignments you can:
Leverage AI during assignment creation to rapidly draft assignment descriptions and rubrics
Accelerate student learning with powerful tools like Reading Progress, Search Progress, and Speaker Progress
Deliver quizzes with Microsoft Forms
Access unique assignment types such as Microsoft Whiteboard, MakeCode, and Flip video
Use Reflect exit check-ins to understand student sentiment related to assignments
Teams Assignments are seamlessly integrated with LMS assignments via the Learning Tools Interoperability® (LTI®) v1.3 Advantage standard. As an educator, you can create new Teams assignments or link existing Teams assignments in your LMS course. Once linked, you can view and access those assignments as you would any other assignment in the LMS course. Your students can view and access their Teams assignments in the same way as their other LMS assignments. Assignment grades in Teams are automatically imported into the LMS gradebook. You can now use the best that Teams assignments and your LMS offer working together, instead of working alongside each other.
This new integration is currently in private preview for PowerSchool Schoology Learning and Canvas. Support for additional LMS platforms will be added soon. You can sign up here for information on current and future previews.
Choose the Right Tool for the Right Assignment
Many educators are already using the OneDrive LTI® tool to bring M365 documents into LMS assignments. The new Teams Assignments LTI® tool is a complementary solution that brings unique capabilities of Teams for Education to LMS users. When creating an assignment in your LMS, you should choose the tool that best meets the needs of the specific assignment. Whatever the choice of tool, the assignment can be viewed and accessed like any other assignment in the LMS, and grades will be added into the LMS gradebook.
Teams Assignments LTI® tool
OneDrive LTI® tool
What is it best used for?
Learning Accelerators, Forms Quizzes, Whiteboard, MakeCode, Flip video, AI-assisted assignment creation, and any other features exclusive to Teams Assignments
Embedding or linking M365 documents in course content; Collaborative editing of documents; Assignments to be completed in Word, PowerPoint, or Excel
When opened in the LMS, where are assignments completed and turned in?
Microsoft Teams
Word, PowerPoint, or Excel
Where are assignments graded?
In Microsoft Teams, with grades automatically copied back to the LMS gradebook.
In the LMS, using the native LMS capabilities.
Requires Microsoft Teams for Education?
Yes
No
Leverage Microsoft Education for more than Assignments in your LMS
The new Teams assignments integration is the latest advancement in our continued efforts to bring the full value of Microsoft Education to users of learning management systems. You can already use the capabilities of Microsoft Teams, OneDrive, OneNote Class Notebooks, Microsoft Reflect directly within LMS courses. You can learn more about these integrations with leaning management systems such as Blackboard Learn, Brightspace, Canvas, Schoology Learning and Moodle in our previous overview, and our support page.
Learning Tools Interoperability® (LTI®) is a trademark of the 1EdTech Consortium, Inc. (www.1edtech.org)
Microsoft Tech Community – Latest Blogs –Read More
ZAP (Zero-Hour Auto Purge) on internal traffic
Greetings !!
Well I have ZAP enabled (Anti-spam inbound policy & Anti-malware policy) and it is working fine with some exceptions. Internal traffic that should be ZAP(ed) reports: “ZAP took no action due to a tenant policy (ZAP disabled)”.
I suppose there is something else that is preventing ZAP on internal traffic. Do any IP addresses whitelisted in the Connection filter policy (Default) bypass the Anti-spam inbound policy ?
Any thoughts ?
Thank you.
Greetings !!Well I have ZAP enabled (Anti-spam inbound policy & Anti-malware policy) and it is working fine with some exceptions. Internal traffic that should be ZAP(ed) reports: “ZAP took no action due to a tenant policy (ZAP disabled)”. I suppose there is something else that is preventing ZAP on internal traffic. Do any IP addresses whitelisted in the Connection filter policy (Default) bypass the Anti-spam inbound policy ? Any thoughts ? Thank you. Read More
Images are broken in Microsoft Teams Bot – Intermittently in the New Teams
When we are trying to upload the large image size, there is a delay in rendering within the Teams bot. This problem was not present in the older version of Teams.
When we are trying to upload the large image size, there is a delay in rendering within the Teams bot. This problem was not present in the older version of Teams. Read More
How can I force to install Windows 11 on unsupported PC?
I recently tried to install Windows 11 on my old unsupported PC and ran into a tricky problem because my hardware doesn’t meet the official system requirements. Despite running compatibility checks, I’m wondering if there is a way to bypass these limitations and force an installation. My PC is currently running an older version of Windows which works fine for my needs. I realize that forcing the installation could lead to potential problems or lack of support from Microsoft, but I am willing to take that risk. Can anyone walk me through these steps or provide a reliable way to install Windows 11 on unsupported hardware?
I recently tried to install Windows 11 on my old unsupported PC and ran into a tricky problem because my hardware doesn’t meet the official system requirements. Despite running compatibility checks, I’m wondering if there is a way to bypass these limitations and force an installation. My PC is currently running an older version of Windows which works fine for my needs. I realize that forcing the installation could lead to potential problems or lack of support from Microsoft, but I am willing to take that risk. Can anyone walk me through these steps or provide a reliable way to install Windows 11 on unsupported hardware? Read More
Since 22H2, File Explorer windows sometimes spontaneously move to the front
I normally close File Explorer windows after using them, but sometimes I forget, and since the 22H2 update, I’ve noticed that File Explorer windows sometimes spontaneously move to the front. After engaging in an arms race with developers in the 90’s and 00’s to stop programs from stealing focus in this way, Microsoft seems to have largely given up on preventing applications from doing this, but these Explorer windows are just sitting there doing nothing when it happens. They haven’t completed any action and have no reason to try to get attention, which is usually why apps want to do this. I can’t be sure, but this new behavior may have begun when File Explorer tabs were enabled, but using tabs is not a condition for the misbehavior. It definitely did not happen before 22H2. No other windows do this. Anyone else notice this? Read More
Need PNP Search results webpart to display metadata column that I added in a SharePoint library
I have an issue trying to get a SharePoint Doc Library metadata column to show up in PNP Search results webpart. Here are the details:
I have a SharePoint Site where I am just leveraging the default document Library “Documents”.
In this Library, there are the default columns “Name”, “Modified” etc. I have also created a new Metadata column called “Document type” that holds values “Test” and “Production” as choice values.
I have created two folders in this Lib called “Test Docs” and “Production Docs”
I have configured the library settings such that when user uploads document into “Test docs” folder, the column “document type” automatically gets tagged with the value “test”. Similarly when a doc is uploaded to the “Production docs” folder, this column gets tagged with value “Production”. See example image below:
I have then setup PnP Search webparts in a page in this Site. The PnP Search results webpart in this page refers to the “Documents” library above, and to return the results based on the “PnP search box” search.
I am having trouble getting the PnP search results webpart to display the metadata column which I created in the library “Document type”.
I need “document type” displayed in the PNP Search results webpart, as I need to restrict user access based on the tag value of the document in this column. So 2 things I am trying to achieve here :
1. Get the “document type” metadata column to appear in PNP Search results webpart, but I am unable to add this column to the PnP search results webpart view. I cant see this column in the list of columns when I edit this webpart (Please advice if I should do some mapping of that document type column to get it to show in the webpart view):
Please advice.
2. Once the column is displayed in the PnP search results view, I need to setup the following restriction.
– When a user of country A logs in, they should be able to only see the documents tagged as “Test” in the document type column. Same way if a user of country B logs in, they should only see the documents they are supposed to see (for eg “Production” tagged docs).
I have an issue trying to get a SharePoint Doc Library metadata column to show up in PNP Search results webpart. Here are the details:I have a SharePoint Site where I am just leveraging the default document Library “Documents”.In this Library, there are the default columns “Name”, “Modified” etc. I have also created a new Metadata column called “Document type” that holds values “Test” and “Production” as choice values.I have created two folders in this Lib called “Test Docs” and “Production Docs”I have configured the library settings such that when user uploads document into “Test docs” folder, the column “document type” automatically gets tagged with the value “test”. Similarly when a doc is uploaded to the “Production docs” folder, this column gets tagged with value “Production”. See example image below:I have then setup PnP Search webparts in a page in this Site. The PnP Search results webpart in this page refers to the “Documents” library above, and to return the results based on the “PnP search box” search.I am having trouble getting the PnP search results webpart to display the metadata column which I created in the library “Document type”.I need “document type” displayed in the PNP Search results webpart, as I need to restrict user access based on the tag value of the document in this column. So 2 things I am trying to achieve here :1. Get the “document type” metadata column to appear in PNP Search results webpart, but I am unable to add this column to the PnP search results webpart view. I cant see this column in the list of columns when I edit this webpart (Please advice if I should do some mapping of that document type column to get it to show in the webpart view):Please advice. 2. Once the column is displayed in the PnP search results view, I need to setup the following restriction.- When a user of country A logs in, they should be able to only see the documents tagged as “Test” in the document type column. Same way if a user of country B logs in, they should only see the documents they are supposed to see (for eg “Production” tagged docs). Read More
Accessed Denied error when deleting Classic WebPart via code (C# and/or PowerShell)
Hi guys,
We have an Azure (C#) Function that is used to build Subsites within a Classic Site Collection, that has been in use for many years. As part of building the sub site, the function manipulates the WebParts held within the default.aspx page, deleting OOTB supplied ones, and adding custom ones.
When we last tried to create a new subsite (on 13th June) the call to delete the WebPart failed with “Access Denied”. The run prior to that, on 5th June worked perfectly and there have been no code changes or updates in that period.
The C# Function connects to SharePoint using a ClientId/Secret created via the AppRegNew.aspx mechanism (since the application that the subsite belongs to is an AddOn app and the function is using the same Id/secret combination) with “Site Collection Full Control” permission, and the secret doesn’t expire until 11-Aug-2024.
The code in question is:
var homepage = web.GetFileByServerRelativeUrl(web.ServerRelativeUrl + “/default.aspx”);
web.Context.Load(homepage);
web.Context.ExecuteQuery();
LimitedWebPartManager wpm = homepage.GetLimitedWebPartManager(PersonalizationScope.Shared);
web.Context.Load(wpm);
web.Context.ExecuteQuery();
IEnumerable<WebPartDefinition> webPartDef = web.Context.LoadQuery(wpm.WebParts.Include(wp => wp.Id, wp => wp.WebPart.Title));
web.Context.ExecuteQuery();
if (webPartDef.Count() > 0)
{
foreach (var wpd in webPartDef)
{
if (wpd.WebPart.Title.ToLower().Equals(name.ToLower())) // If matched, remove.
wpd.DeleteWebPart(); // <=== This is now generating “Access Denied”
}
web.Context.ExecuteQuery();
}
Have tried raising Microsoft tickets, since we have Premier support, but the final one directed me to raise the issue here.
So really wondering what changed? NB: Deleting the web part using PowerShell (PnP.PowerShell module) under my Site Collection Admin credentials also fails.
Regards
Steve
Hi guys, We have an Azure (C#) Function that is used to build Subsites within a Classic Site Collection, that has been in use for many years. As part of building the sub site, the function manipulates the WebParts held within the default.aspx page, deleting OOTB supplied ones, and adding custom ones.When we last tried to create a new subsite (on 13th June) the call to delete the WebPart failed with “Access Denied”. The run prior to that, on 5th June worked perfectly and there have been no code changes or updates in that period.The C# Function connects to SharePoint using a ClientId/Secret created via the AppRegNew.aspx mechanism (since the application that the subsite belongs to is an AddOn app and the function is using the same Id/secret combination) with “Site Collection Full Control” permission, and the secret doesn’t expire until 11-Aug-2024.The code in question is:var homepage = web.GetFileByServerRelativeUrl(web.ServerRelativeUrl + “/default.aspx”);web.Context.Load(homepage);web.Context.ExecuteQuery();LimitedWebPartManager wpm = homepage.GetLimitedWebPartManager(PersonalizationScope.Shared);web.Context.Load(wpm);web.Context.ExecuteQuery();IEnumerable<WebPartDefinition> webPartDef = web.Context.LoadQuery(wpm.WebParts.Include(wp => wp.Id, wp => wp.WebPart.Title));web.Context.ExecuteQuery();if (webPartDef.Count() > 0){ foreach (var wpd in webPartDef) { if (wpd.WebPart.Title.ToLower().Equals(name.ToLower())) // If matched, remove. wpd.DeleteWebPart(); // <=== This is now generating “Access Denied” } web.Context.ExecuteQuery();}Have tried raising Microsoft tickets, since we have Premier support, but the final one directed me to raise the issue here.So really wondering what changed? NB: Deleting the web part using PowerShell (PnP.PowerShell module) under my Site Collection Admin credentials also fails.RegardsSteve Read More