Category: Microsoft
Category Archives: Microsoft
Coming soon: New MB courses for ILT.
New ILT course releases for Dynamics 365
As we continue to expand our Microsoft Dynamics portfolio to align with the evolving job market, Microsoft aims to enable the customization of longer-duration courses to better meet the needs of our learners.
As we continue to expand our Microsoft Dynamics portfolio to align with the evolving job market, Microsoft aims to enable the customization of longer-duration courses to better meet the needs of our learners.
As planned on November 29th, 2024, we will be retiring the following Microsoft Dynamics courses and their associated credentials:
MB-210T01: Microsoft Dynamics 365 Sales (2 days)
MB-220T00: Dynamics 365 Customer Insights – Journeys (4 days)
MB-260T00: Microsoft Customer Insights – Data Specialty (4 days)
The three retiring courses, totaling a duration of 12 days, include multiple certifications and exams, making it challenging for Learners to acquire all the necessary certifications for various Dynamics 365 roles.
We are excited to introduce a new Instructor-Led Training (ILT) offering designed to enhance our Learners’ core skills in a way that best fits their learning journey. Our new course releases, MB-280, Launching for ILT on October 28th, 2024, will be divided into four distinct course offerings, rather than a single five-day course. Each course supports essential skills for Dynamics 365 roles.
For Learners seeking the certification or aiming to pass the MB-280 exam, all four courses should be taken. However, if a Learner wishes to explore specific skills provided in any of the courses, our Partners can offer flexible ILT course options to accommodate their learning needs.
Newly enhanced Trainer materials will be available for download, providing curriculum information to help Partners and Trainers personalize and deliver their ILT offerings for learners.
Below is a brief overview of each course to help you plan how to leverage them for optimal class delivery:
MB-280T01: Configure Dynamics 365 Customer Experience Model-Driven Apps (1 day): This course introduces model-driven app configuration within the Customer Experience suite, preparing Learners with the necessary skills to build a Customer Experience solution.
MB-280T02: Empower Sellers with Dynamics 365 Sales and Microsoft Copilot for Sales (2 days): This course covers Dynamics 365 Sales, including lead and opportunity management, product catalog organization, sales order processing, and key features of Microsoft Copilot for Sales.
MB-280T03: Design and Deliver Powerful Customer Experiences with Dynamics 365 Customer Insights (1 day): This course teaches Learners how to use Dynamics 365 Customer Insights to understand and target customers, create unified customer profiles, and build impactful marketing assets.
MB-280T04: Configure a Dynamics 365 Customer Experience Solution (1 day): This applied workshop allows students to apply their learnings in a real-world challenge, configuring Dynamics 365 Sales and Customer Insights model-driven apps to create a full Customer Experience solution.
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
Microsoft Tech Community – Latest Blogs –Read More
Help with VLOOKUP formula for yesterday’s data please
Hi!
I’m asking for help creating a formula that pulls Yesterday’s data into another spreadsheet. I pull an excel report that lists by column today’s data, yesterday’s data, the previous day’s data, and so on. I want to pull both today’s and yesterday’s data into a new spreadsheet. The rows are separate buildings., ex Building 1, Building 2, Building 3.
Currently I can pull today’s data no problem using VLOOKUP; how can I pull the next column when yesterday’s date will always change? Please help!
Adding a screen shot of the report.
Building09/11/202409/10/20247K-51123.4 deg24.2 deg550-1418.3 deg 20K-0123.9 deg 350-0717.8 deg 7K-515 24.9 deg7K-51324.5 deg24.4 deg7K-51424.5 deg 7K-51524.9 deg 7K-51224.7 deg
Hi!I’m asking for help creating a formula that pulls Yesterday’s data into another spreadsheet. I pull an excel report that lists by column today’s data, yesterday’s data, the previous day’s data, and so on. I want to pull both today’s and yesterday’s data into a new spreadsheet. The rows are separate buildings., ex Building 1, Building 2, Building 3.Currently I can pull today’s data no problem using VLOOKUP; how can I pull the next column when yesterday’s date will always change? Please help! Adding a screen shot of the report.Building09/11/202409/10/20247K-51123.4 deg24.2 deg550-1418.3 deg 20K-0123.9 deg 350-0717.8 deg 7K-515 24.9 deg7K-51324.5 deg24.4 deg7K-51424.5 deg 7K-51524.9 deg 7K-51224.7 deg Read More
Archive a SharePoint Landing Page for Past Conference
I have taken over ownership of an annual event and need to “archive” the current SharePoint landing page in a SharePoint Communication Site. We want to start fresh with this year’s site but still provide easy access to the 2023 site for reference. How can I set up user-friendly navigation to allow people to look back at the 2023 site?
I have taken over ownership of an annual event and need to “archive” the current SharePoint landing page in a SharePoint Communication Site. We want to start fresh with this year’s site but still provide easy access to the 2023 site for reference. How can I set up user-friendly navigation to allow people to look back at the 2023 site? Read More
HELP!
I am being told I need to make changes to my email account(s) and I am completely confused on what I need to do. Are you able to help walk me through that process?
Anna
I am being told I need to make changes to my email account(s) and I am completely confused on what I need to do. Are you able to help walk me through that process?Anna Read More
How to connect ADF to AWS RDS
We are trying to connect an AZURE Data factory (ADF) to an AWS RDS (Relational Database Service)instance that does not have public access. We have a working VPN up and running however, we cannot connect over the private network to the AWS IP address/RDS server name.
Looking online there is not a good way to do this without creating an additional NAT instance VM. Is there a way to do this with a cloud based ADF? Or does it make more sense to just create a self hosted ADF service either in AWS or in Azure to move the data into our data warehouse?
Is it possible that fabric would have a solution for this problem?
We are trying to connect an AZURE Data factory (ADF) to an AWS RDS (Relational Database Service)instance that does not have public access. We have a working VPN up and running however, we cannot connect over the private network to the AWS IP address/RDS server name. Looking online there is not a good way to do this without creating an additional NAT instance VM. Is there a way to do this with a cloud based ADF? Or does it make more sense to just create a self hosted ADF service either in AWS or in Azure to move the data into our data warehouse?Is it possible that fabric would have a solution for this problem? Read More
Join us for the Microsoft 365 Copilot: Wave 2 digital event September 16, 8am PST
The next phase of Microsoft Copilot for Microsoft 365 innovation is designed to help optimize your customers’ daily operations.
Join us on LinkedIn Live Monday, September 16 at 11:00 AM Eastern Time/8:00 AM Pacific Time, as Satya Nadella and Jared Spataro reveal “Microsoft 365 Copilot: Wave 2.”
Discover powerful new updates, exciting features, and scenarios. Then learn how Microsoft is leveraging customer feedback to solve today’s biggest work challenges and expand beyond individual productivity to drive business-wide results.
Don’t miss this opportunity to stay ahead—mark your calendars and join us!
Register now
Microsoft Tech Community – Latest Blogs –Read More
ILT Course Retirement- AZ-1005: Configuring Azure Virtual Desktop for the Enterprise
AZ-1005: Configuring Azure Virtual Desktop for the Enterprise
Credential: N/A
Retirement date: September 30th, 2024
Replacement Course: N/A
We always want to provide our Trainers and Learners the most secure and best learning experience possible. Ensuring we provide secure lab working environments, the decision has been made to retire AZ-1005.
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
Microsoft Tech Community – Latest Blogs –Read More
Azure Lab Services – lab plan outage – September 12, 2024
Hello,
Azure Lab Services is currently experiencing an outage affecting customers using Lab Plans for their service. Customers using Lab Accounts are not affected. This issue impacts all operations across all regions.
The root cause has been identified, and a hotfix is being rolled out. We expect service to be fully restored by the end of the business day (CDT) on September 12, 2024. We will provide updates about the outage in this blog post until the issue is fully resolved.
We apologize for any inconvenience and disruption this may cause.
Microsoft Tech Community – Latest Blogs –Read More
Too many false positive with the DLP credit card number Policy
I have aDLP default template policy that flags Credit card information. The issue I see here is that it flags random documents that contains SSN numbers and other number format.
Do we need to use Regex to tell DLP policy to only looks Credit card number instead of flagging SSN (SSN number is 9 digiti format only) and SIN numbers too?
If yes, can someone share REGEx expression that works for all types of Credit card numbers. My users use something like 4513-2321-5247-6554 or 379857582890004. I see they either have at least 13 digit or 15 or sometimes 16 digit in the above format.
I have aDLP default template policy that flags Credit card information. The issue I see here is that it flags random documents that contains SSN numbers and other number format. Do we need to use Regex to tell DLP policy to only looks Credit card number instead of flagging SSN (SSN number is 9 digiti format only) and SIN numbers too? If yes, can someone share REGEx expression that works for all types of Credit card numbers. My users use something like 4513-2321-5247-6554 or 379857582890004. I see they either have at least 13 digit or 15 or sometimes 16 digit in the above format. Read More
Exchange Cross Forest migration – Outlook reconfiguration
We’re cross forest migrating users and mailbox between two forests.
Both exchange Org are 2016
The two forest uses different URLs as
FOREST A
owa.domain.com
FOREST B
webmail.domain.,com
Now we’re testing the mailbox migration part which works without issue.
The mailbox gets migrated and accessing it with WEB works.
The problem is with outlook clients that don’t reconfigure automatically as we expected.
When the test user opens outlook it get stuck trying to open it from the old URL ( owa.domain.com ) and the autodiscover is not redirecting it to the new domain.
Is there a way we can do it ?
We’re cross forest migrating users and mailbox between two forests.Both exchange Org are 2016The two forest uses different URLs asFOREST Aowa.domain.comFOREST Bwebmail.domain.,comNow we’re testing the mailbox migration part which works without issue.The mailbox gets migrated and accessing it with WEB works.The problem is with outlook clients that don’t reconfigure automatically as we expected.When the test user opens outlook it get stuck trying to open it from the old URL ( owa.domain.com ) and the autodiscover is not redirecting it to the new domain.Is there a way we can do it ? Read More
Cannot start VMs, template, or create a new lab
We are currently seeing an issue where we cannot start our VMs, we just see this message: “Virtual machine redeploy operation failed. Try redeploying the virtual machine. If the issue persists, consider reimaging it. For further assistance submit a support request.” Redeploying does not make any difference, and we are reluctant to reimage as MS have acknowledged a bug whereby the SSD of the VM can shrink after a reimage: in any case we also cannot start our template.
We cannot make a new lab: when we try we see the “gorilla holding a sign” indication that something has gone wrong on both the dashboard and template pages for that lab.
Our lab plan is based in UK South. We are unable to create an alternative lab plan in another region as the portal says we are not allowed to due the retirement of ALS in 2027!
Has anybody seen similar and has any suggestions?
We are currently seeing an issue where we cannot start our VMs, we just see this message: “Virtual machine redeploy operation failed. Try redeploying the virtual machine. If the issue persists, consider reimaging it. For further assistance submit a support request.” Redeploying does not make any difference, and we are reluctant to reimage as MS have acknowledged a bug whereby the SSD of the VM can shrink after a reimage: in any case we also cannot start our template. We cannot make a new lab: when we try we see the “gorilla holding a sign” indication that something has gone wrong on both the dashboard and template pages for that lab. Our lab plan is based in UK South. We are unable to create an alternative lab plan in another region as the portal says we are not allowed to due the retirement of ALS in 2027! Has anybody seen similar and has any suggestions? Read More
B2B sharing policy
Hi,
Microsoft has updated the B2B sharing policy, so we now need to invite externals to our Azure AD before sharing files with them. Is there any way to create an exception for certain domains, like those of our partners, so we can share files with them without having to invite them as guests?
Thank you for your help!
Best,
Hi,Microsoft has updated the B2B sharing policy, so we now need to invite externals to our Azure AD before sharing files with them. Is there any way to create an exception for certain domains, like those of our partners, so we can share files with them without having to invite them as guests?Thank you for your help!Best, Read More
Site has so many access requests that the list no longer loads in pendingreq.aspx
We have a SharePoint site that archives communications from our HR department to various groups of people, but over the past 2 years they’ve been manually managing access requests instead of using permission groups. Now they have over 7000 access requests and when anyone goes to the pending request page, they only see the following error:
The button that appears in their emails is also throwing an error, so that isn’t an option.
Is there a way to access the full list without using the pendingreq.aspx page? I tried navigating to /Access%20Requests/Forms/AllItems.aspx but only received a 404. If I can access the full list, what would happen if we deleted the old approved requests? Would that remove the access for those users?
We have a SharePoint site that archives communications from our HR department to various groups of people, but over the past 2 years they’ve been manually managing access requests instead of using permission groups. Now they have over 7000 access requests and when anyone goes to the pending request page, they only see the following error: The button that appears in their emails is also throwing an error, so that isn’t an option. Is there a way to access the full list without using the pendingreq.aspx page? I tried navigating to /Access%20Requests/Forms/AllItems.aspx but only received a 404. If I can access the full list, what would happen if we deleted the old approved requests? Would that remove the access for those users? Read More
I’am trying to download sql server, but I’m facing this problem can you help please.
I’am trying to download sql server, but I’m facing this problem can you help please. I installed it successfully before, but now when I reinstall it, i get this error and can’t install SQLServer.
I’am trying to download sql server, but I’m facing this problem can you help please. I installed it successfully before, but now when I reinstall it, i get this error and can’t install SQLServer. Read More
Select entire sheet then sort on one column (automated)
Total newb here…
This should be very simple.
Automate > Record Actions
Right-Click to the left of Column A (This highlights the entire sheet)
Sort > Custom Sort
Sort on Col J (“Amount” is the heading)
The result, when done manually, is just fine.
When recorded as a script and run it only sorts Column J, not the entire sheet like when it is done manually.
This is to be a 3 step process.
Select all cells and unwrap all text. (This one works)
Sort on column J (Amount) and delete the zero-dollar amount rows. (The delete is currently done manually, though some manner of “IF/THEN” would probably automate the process.) This one does not work as recorded.
Re-sort by Customer then Description, then Date. (Col B, F, E) This one shuffles the columns around. It’s quite odd.
Total newb here…This should be very simple.Automate > Record ActionsRight-Click to the left of Column A (This highlights the entire sheet)Sort > Custom SortSort on Col J (“Amount” is the heading) The result, when done manually, is just fine.When recorded as a script and run it only sorts Column J, not the entire sheet like when it is done manually. function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Sort the range range J2:J67 on selectedSheet selectedSheet.getRange(“J2:J67”).getSort().apply([{ key: 0, ascending: true }], false, true, ExcelScript.SortOrientation.rows);} This is to be a 3 step process.Select all cells and unwrap all text. (This one works) function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Set horizontal alignment to ExcelScript.HorizontalAlignment.general for all cells on selectedSheet selectedSheet.getRange().getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.general); selectedSheet.getRange().getFormat().setIndentLevel(0); // Set vertical alignment to ExcelScript.VerticalAlignment.bottom for all cells on selectedSheet selectedSheet.getRange().getFormat().setVerticalAlignment(ExcelScript.VerticalAlignment.bottom); selectedSheet.getRange().getFormat().setIndentLevel(0); // Set wrap text to false for all cells on selectedSheet selectedSheet.getRange().getFormat().setWrapText(false); // Set text orientation to 0 for all cells on selectedSheet selectedSheet.getRange().getFormat().setTextOrientation(0); // Indent set to 0 for all cells on selectedSheet selectedSheet.getRange().getFormat().setIndentLevel(0);}Sort on column J (Amount) and delete the zero-dollar amount rows. (The delete is currently done manually, though some manner of “IF/THEN” would probably automate the process.) This one does not work as recorded.function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Sort the range range J2:J67 on selectedSheet selectedSheet.getRange(“J2:J67”).getSort().apply([{ key: 0, ascending: true }], false, true, ExcelScript.SortOrientation.rows);}Re-sort by Customer then Description, then Date. (Col B, F, E) This one shuffles the columns around. It’s quite odd.function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // Custom sort on range range A1:K68 on selectedSheet selectedSheet.getRange(“A1:K68”).getSort().apply([{key: 1, ascending: true}, {key: 5, ascending: true}, {key: 4, ascending: true}], false, true, ExcelScript.SortOrientation.columns);}All 3 of these steps work perfectly when done manually. Recording the actions to a script produces crazy results. Any help is appreciated. Read More
To Do, how to see my task only in my day
We have a lot of shared lists. Is there a way to hide tasks assigned to others in my day view?
thank!
We have a lot of shared lists. Is there a way to hide tasks assigned to others in my day view? thank! Read More
New pricing for Microsoft Certification exams effective November 1, 2024
At Microsoft Learn, we continually review and evolve our portfolio of Microsoft Certifications to help learners around the world stay up to date with the latest technologies in our fast-changing digital world, especially as AI skills become increasingly important in the workplace. Microsoft Certifications are globally recognized credentials that validate your skills for various job roles using these technologies.
According to the 2023 Skillsoft IT Skills & Salary report, 62% of those who earned certifications felt that the quality of their work improved. They’re also more engaged at work (47%) and perform their duties faster (45%). Whether you’re a student, a professional, or someone changing careers, earning a Microsoft Certification can help you accomplish your goals and demonstrate your commitment to continuous learning and improvement. This achievement can also help boost your confidence and credibility at work as you showcase your expertise to employers and customers.
What’s changing?
We regularly update our exam content, format, and delivery to help ensure that our exams are aligned with industry standards and best practices. In recent years, we’ve made significant investments in developing and launching new exams and certifications for critical roles that use Microsoft apps and services, like Azure, Microsoft 365, Dynamics 365, and Microsoft Power Platform.
We also review and adjust exam prices to help maintain the quality and value of our Certification program. As a result, effective November 1, 2024, Microsoft is updating the retail prices for its Certification exams to reflect the current market conditions and the value of the Certifications. Our goal is to make the exam pricing simpler and more consistent across geographies while still offering a fair and affordable value proposition for our Certification candidates.
What are the new prices?
The new retail prices for Certification exams vary depending on the country or region where you take the exam. For most areas, there will be no change in the price. For some areas, the price will decrease to make the exams more affordable. In a few areas, the price will increase to align with global and regional standards. To find the updated price of the exams in your area, check out the full list of new prices for Microsoft Certifications by country or region.
How does this news affect you?
If you’re planning to take a Microsoft Certification exam, you can register for and take the exam at the current price until October 31, 2024. If you register to take the exam on or after November 1, 2024, you’ll pay the updated price. Remember, in many countries and regions, the retail price is not changing and might even be decreasing. For more information on how to register and pay for your exam, go to the Microsoft Certification exam policies and FAQs.
To prepare for the Certification exam, make the most of the many resources and opportunities available on Microsoft Learn, such as free self-paced training, along with exam readiness resources, like Practice Assessments, exam prep videos, and more. You can also enroll in instructor-led training with Microsoft Training Services Partners or join the Microsoft Learn Community to prepare with peers and colleagues.
Earn a Microsoft Certification today
Microsoft Certification exams are more than just a test of your knowledge. They demonstrate your commitment, passion, and excellence in the IT industry. Earning a Certification is an investment in your professional life that can pay off in many ways, helping you build your skills and enhance your career. A Certification can boost your career prospects, improve your professional credibility, and unlock new opportunities for growth and success. Invest in your future and earn a certification today!
Microsoft Tech Community – Latest Blogs –Read More
Customer review: Rimo3 Cloud simplified compatibility assessment with streamlined testing
Rimo3 Cloud, an app published in Microsoft Azure Marketplace, accelerates the digital modernization journey with intelligent, unattended automation that helps customers migrate, modernize, and assess application readiness for continuous change management of their Microsoft Windows estates.
Microsoft interviewed Stephen Hoensch, Head of IT Service Development at University of Cambridge, to learn what he had to say about the solution.
What do you like best about Rimo3 Cloud?
Rimo3 has significantly streamlined our application testing process, making it much easier to assess compatibility across different environments.
How has Rimo3 helped your organization?
This solution will save us countless hours by automating testing tasks that were previously manual, increasing our overall efficiency.
How are customer service and support?
Customer support has been outstanding—quick responses and knowledgeable staff who are always ready to help.
Any recommendations or insights to other users considering this solution?
For anyone looking to optimize and automate their application testing and deployment processes, Rimo3 is a game-changer. A true single pane of glass experience for applications packaging and deployment.
On a scale from 1 to 5, what is your overall rating for Rimo3 Cloud?
5
Microsoft Tech Community – Latest Blogs –Read More
Microsoft names new Executive Vice President and Chief Operations Officer
Satya Nadella, Chairman and CEO, shared the below communication with Microsoft employees this morning.
As we mark our 50th year, I’ve been reflecting on how we have remained a consequential company decade after decade in an industry where there is no franchise value. And it is because — time and time again when tech paradigms have shifted — we have seized the opportunity to reinvent ourselves. And that’s what we are doing again today in this AI platform shift.
Carolina Dybeck Happe
To continue thriving as a company, we need to raise the bar on our operational excellence, continually improving security, quality, and delivery to our customers, as well as the rigor with which we operate the business. Building this capability is essential, and I want each of us to take as much pride in exceeding customer expectations in our fundamentals as we do in our product innovation. After all, both are mission critical to our customers and our future.
In this context, I’m thrilled to share that Carolina Dybeck Happe is joining Microsoft as EVP and Chief Operations Officer. In this newly created role, she will join the senior leadership team (SLT), reporting to me.
I’ve come to admire Carolina through her work as a global business leader, including most recently her role in leading GE’s historic turnaround. She is recognized for her ability to drive transformational change at scale while delivering improved customer experiences and faster time to value. Carolina will partner with the SLT to help us drive continuous business process improvement across all our organizations and accelerate our company-wide AI transformation, increasing value to customers and partners.
As part of this transition, the Commerce + Ecosystems organization in Cloud + AI, the Microsoft Digital organization in Experiences + Devices, and the Microsoft Business Operations organization in Finance will move to report to Carolina. These teams are doing mission-critical work for us with high ambition plans on how to empower our partners, customers, and employees with world class technology and experiences.
I look forward to seeing the progress we will achieve together as we embrace continuous improvement in all we do.
Please join me in welcoming Carolina to Microsoft.
Satya
The post Microsoft names new Executive Vice President and Chief Operations Officer appeared first on The Official Microsoft Blog.
Satya Nadella, Chairman and CEO, shared the below communication with Microsoft employees this morning. As we mark our 50th year, I’ve been reflecting on how we have remained a consequential company decade after decade in an industry where there is no franchise value. And it is because — time and time again when tech paradigms…
The post Microsoft names new Executive Vice President and Chief Operations Officer appeared first on The Official Microsoft Blog.Read More
Folder sharing link – setting expiry date
Hi,
I have a SharePoint site with a number of folders that have view only access configured at folder level for a mix of internal and external users.
All of these links had expiry dates set on them and this has been working fine for the last couple of months.
Today, I created a new folder and the ability to set expiry dates for the link seems to have disappeared. (I’m using the “only specific users” option when creating the link).
Previously I would click share next to the folder name, then on the gear icon, and select a date. The option has gone.
Not only that, but on all the previous access links I’ve created on all sites I can no longer see that they have an expiry date.
There’s normally a small calendar icon next to the link and that has now disappeared for all folders across all sites.
At the moment I’m assuming this is following an update having been applied or a global setting having been changed somewhere.
I even tried creating a new, clean SharePoint site but the problem still occurs on the new site.
Can anyone advise on what may have caused the expiry date option to disappear when creating sharing links?
Hi,I have a SharePoint site with a number of folders that have view only access configured at folder level for a mix of internal and external users. All of these links had expiry dates set on them and this has been working fine for the last couple of months. Today, I created a new folder and the ability to set expiry dates for the link seems to have disappeared. (I’m using the “only specific users” option when creating the link). Previously I would click share next to the folder name, then on the gear icon, and select a date. The option has gone. Not only that, but on all the previous access links I’ve created on all sites I can no longer see that they have an expiry date. There’s normally a small calendar icon next to the link and that has now disappeared for all folders across all sites. At the moment I’m assuming this is following an update having been applied or a global setting having been changed somewhere. I even tried creating a new, clean SharePoint site but the problem still occurs on the new site. Can anyone advise on what may have caused the expiry date option to disappear when creating sharing links? Read More