Category: Microsoft
Category Archives: Microsoft
matching 2 spreadsheets list
I have a 2 excel docs, one with my target customer# and the second excel doc with all customer#. I want to match and sort the 2nd sheet with all customer# to match my target customer#
I have a 2 excel docs, one with my target customer# and the second excel doc with all customer#. I want to match and sort the 2nd sheet with all customer# to match my target customer# Read More
Trying to create a document that updates information based on specific information in workbook
I have a client list, some with multiple job names, requests related to job and mode of receiving said info. Those are the headings to my cells in the excel spreadsheet. What I would like to do is auto populate the information in a document that would be a running tab of correspondence for that particular job. I need to know how to copy over information(requests, mode, date) based on a particular cell (job name). Is there a formula for this. The following are images of my work so far
I have a client list, some with multiple job names, requests related to job and mode of receiving said info. Those are the headings to my cells in the excel spreadsheet. What I would like to do is auto populate the information in a document that would be a running tab of correspondence for that particular job. I need to know how to copy over information(requests, mode, date) based on a particular cell (job name). Is there a formula for this. The following are images of my work so far Read More
Outlook interpreting CTRL+DEL as “Ignore Conversation” instead of deleting the next word.
This is new behavior that started yesterday. I use Control-Delete a lot while editing messages, but suddenly it started deleting & ignoring my email threads instead of editing the text.
Microsoft® Outlook® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit
I can’t find anything on this Googling around or looking through the Community posts. What changed? Or what did I change by accident? Where is the setting to disable this feature? The ONLY keyboard shortcut that I EVER want messing with my email threads (instead of just editing the text) is CTRL+ENTER to send.
This is new behavior that started yesterday. I use Control-Delete a lot while editing messages, but suddenly it started deleting & ignoring my email threads instead of editing the text. Microsoft® Outlook® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit I can’t find anything on this Googling around or looking through the Community posts. What changed? Or what did I change by accident? Where is the setting to disable this feature? The ONLY keyboard shortcut that I EVER want messing with my email threads (instead of just editing the text) is CTRL+ENTER to send. Read More
Being an authorized reseller of Microsoft office setup keys
I am writing to express my interest in becoming an authorized reseller of Microsoft Office Professional Plus 2021 and 2019 setup keys. My organization is looking to acquire these keys in bulk, and I would like to understand the requirements and process to become an official reseller of these products.
Could you please provide details regarding the following:
The steps involved in becoming an authorized reseller for Microsoft Office Professional Plus 2021 and 2019.
The minimum purchase requirements or other conditions for bulk purchases.
Any necessary certifications, agreements, or documentation that I would need to provide.
The pricing structure and available support for authorized resellers.
I would appreciate your guidance on how I can move forward with this process and am happy to provide any additional information if required.
Thank you for your time and assistance. I look forward to your response.
I am writing to express my interest in becoming an authorized reseller of Microsoft Office Professional Plus 2021 and 2019 setup keys. My organization is looking to acquire these keys in bulk, and I would like to understand the requirements and process to become an official reseller of these products.Could you please provide details regarding the following:The steps involved in becoming an authorized reseller for Microsoft Office Professional Plus 2021 and 2019.The minimum purchase requirements or other conditions for bulk purchases.Any necessary certifications, agreements, or documentation that I would need to provide.The pricing structure and available support for authorized resellers.I would appreciate your guidance on how I can move forward with this process and am happy to provide any additional information if required.Thank you for your time and assistance. I look forward to your response. Read More
RDP issues with 26280.5000
I have been testing Citrix out in my home lab on 2025 to be prepared when customers want it. I found that the latest 26280.5000 build caused issues on a machine I upgraded. I downloaded the latest ISO and built a new machine with this version. Everything worked fine and I was able to RDP to the console to administer it as I have a vgpu applied to it. As soon as I install the remote desktop role I can no longer RDP to the machine. I have tried from multiple machines and they attempt to connect and rdp manager just sits there waiting for the connection. If I login to the machine from the vcenter console and attempt to rdp to localhost it comes right up. I have tried removing the rdp role, disabling and re-enabling the rdp admin access, and nothing.
I have been testing Citrix out in my home lab on 2025 to be prepared when customers want it. I found that the latest 26280.5000 build caused issues on a machine I upgraded. I downloaded the latest ISO and built a new machine with this version. Everything worked fine and I was able to RDP to the console to administer it as I have a vgpu applied to it. As soon as I install the remote desktop role I can no longer RDP to the machine. I have tried from multiple machines and they attempt to connect and rdp manager just sits there waiting for the connection. If I login to the machine from the vcenter console and attempt to rdp to localhost it comes right up. I have tried removing the rdp role, disabling and re-enabling the rdp admin access, and nothing. Read More
One of the test avatar breaks MeshEmulator view
Test Avatar prefab Toolkit_TestAvatar_Purple.prefab contains a camera component that overrides MeshEmulator view in PlayMode. Please remove highlighted objects.
I have Mesh-Toolkit-Unity 5.2412.187. Other test avatars are fine.
Many thanks for adding them!
Test Avatar prefab Toolkit_TestAvatar_Purple.prefab contains a camera component that overrides MeshEmulator view in PlayMode. Please remove highlighted objects. I have Mesh-Toolkit-Unity 5.2412.187. Other test avatars are fine.Many thanks for adding them! Read More
Excel formula for Ageing
Hi,
I am trying to come up with a formula to net down aged data but I am struggling!
This is a sample from my pivot, I want to run the formula alongside it and what I am trying to do is:
For customer 1 to net off the -735 from 4 Years+ with the 735 in 90-180 so it only shows 735 left in 60-90 days. Then when I refresh the pivot each month these will adjust and then the ageing formula will adjust alongside it.
Thanks,
James
Hi, I am trying to come up with a formula to net down aged data but I am struggling! This is a sample from my pivot, I want to run the formula alongside it and what I am trying to do is:For customer 1 to net off the -735 from 4 Years+ with the 735 in 90-180 so it only shows 735 left in 60-90 days. Then when I refresh the pivot each month these will adjust and then the ageing formula will adjust alongside it. Thanks,James Read More
removing unwanted data from a cell
I have a column with codes, the codes I need are FT and FC, but there are cells with extra codes which I want to remove and only have FT or FC appear in the cell. how do I do this without having to click on each cell and remove the unwanted data? example attached
I have a column with codes, the codes I need are FT and FC, but there are cells with extra codes which I want to remove and only have FT or FC appear in the cell. how do I do this without having to click on each cell and remove the unwanted data? example attached Read More
Connect-Aipservice is not working
Hello everyone,
Please is anyone able to connect to the aip service using powershell version 5.5 and above?
Even after installing and importing the aip service module, the connect-aipservice failed to work with all its parameters.
However, creating and publishing sensitivity label policy is working.
Thanks.
Hello everyone, Please is anyone able to connect to the aip service using powershell version 5.5 and above? Even after installing and importing the aip service module, the connect-aipservice failed to work with all its parameters. However, creating and publishing sensitivity label policy is working. Thanks. Read More
Root directory path in SFTP Copy Pipeline
Hi There
Please could you help ?
I have a copy pipeline that uses an SFTP location as a source. The SFTP location has multiple folders however I need to read new daily files with changing filenames from the root.
This pipeline was running perfectly until a few days ago when ADF started trying to read from one of the folders instead of the root, despite the root being configured in the source config. I can see from the error message that the pipeline is failing as a result of pipeline reading from a folder instead of the root.
How do I specify the root in the source config of the copy pipeline ?
Thanks
Dom
Hi There Please could you help ?I have a copy pipeline that uses an SFTP location as a source. The SFTP location has multiple folders however I need to read new daily files with changing filenames from the root. This pipeline was running perfectly until a few days ago when ADF started trying to read from one of the folders instead of the root, despite the root being configured in the source config. I can see from the error message that the pipeline is failing as a result of pipeline reading from a folder instead of the root. How do I specify the root in the source config of the copy pipeline ? ThanksDom Read More
Session hosts across multiped host pools suddenly unavailable
Our AVD environment was running fine this morning and suddenly we noticed that all of our session hosts have become unavailable and are getting the following error message (in addition to slow portal and cli access when trying to view session hosts and host pools)
Log Name: Application
Source: WVD-Agent
Date: 9/11/2024 10:24:55 AM
Event ID: 3019
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: fqdn
Description:
Transport received an exception The request was aborted: The request was canceled., when connecting to wss://rdbroker.wvd.microsoft.com//api/rdAgent/v1 for enum globalBrokerUri. To resolve this error, see the troubleshooting guide http://aka.ms/3019
Our AVD environment was running fine this morning and suddenly we noticed that all of our session hosts have become unavailable and are getting the following error message (in addition to slow portal and cli access when trying to view session hosts and host pools) Log Name: ApplicationSource: WVD-AgentDate: 9/11/2024 10:24:55 AMEvent ID: 3019Task Category: NoneLevel: ErrorKeywords: ClassicUser: N/AComputer: fqdnDescription:Transport received an exception The request was aborted: The request was canceled., when connecting to wss://rdbroker.wvd.microsoft.com//api/rdAgent/v1 for enum globalBrokerUri. To resolve this error, see the troubleshooting guide http://aka.ms/3019 Read More
Kerberos KDC Errors
Hello,
I have been testing Windows Server 2025 with AD DC role and sometimes in event log I can see error.
The Security Account Manager failed a KDC request in an unexpected way. The error is in the data field. The account name was and lookup type 0x108.
Just a note – I did not remove the account name; it is not just there, not even once.
I’m unable to connect it to some “action”, so it looks a bit random. In data field there is only C000000D (in words) which is every time the same. Event ID is 7.
Is this okay or anything to worry about?
Hello,I have been testing Windows Server 2025 with AD DC role and sometimes in event log I can see error.The Security Account Manager failed a KDC request in an unexpected way. The error is in the data field. The account name was and lookup type 0x108.Just a note – I did not remove the account name; it is not just there, not even once.I’m unable to connect it to some “action”, so it looks a bit random. In data field there is only C000000D (in words) which is every time the same. Event ID is 7.Is this okay or anything to worry about? Read More
Special character shortcuts working only on Microsoft Word but not in any other applications
During previous iterations of Windows, when I set special character keyboard shortcuts on Word (e.g.,
à, é), these shortcuts would be available on other applications like web browsers. I switched to a new laptop that ran on Windows 11 and set up keyboard shortcuts on Word but these would not work on other applications. Is there a fix for this?
During previous iterations of Windows, when I set special character keyboard shortcuts on Word (e.g.,à, é), these shortcuts would be available on other applications like web browsers. I switched to a new laptop that ran on Windows 11 and set up keyboard shortcuts on Word but these would not work on other applications. Is there a fix for this? Read More
Extend Viva Connections with pre-built 3rd party Adaptive cards
Viva Connections is the gateway for the employee experience and provides an extensible platform through the dashboard, where employees can see a targeted list of actionable cards that can connect to Microsoft Teams apps, Viva apps and services, partner apps, and custom solutions using the SharePoint Framework (SPFx) framework, internal links, and external links.
A Viva Connections dashboard showing some examples of third party cards.
This blog will explore a few of our diverse third-party card integrations available from can extend the capabilities of Viva Connections, allowing organizations to incorporate third party external tools, services, and data directly into their flow of work and ensure business critical investments that they have made in other services can be added directly into employee dashboards. There are countless ways to customize or build your own dashboard cards to meet the needs of employees at virtually any organization, but this blog will highlight a few pre-packaged cards from Microsoft partners that can easily be added to your app.
ServiceNow
With the ServiceNow card, enable employees to get support, find answers, and act on tasks across HR, IT, and other departments. Once deployed, the card offers a quick view of their task list by selecting View My Tasks. The ServiceNow Adaptive Card extension also provides a quick entry point into the app by simply selecting Visit Employee Center.
UKG
With the UKG card employees can view their respective pay information and review their work schedules, shifts, and PTO, to see a clearer picture of upcoming priorities.
Achievers
Achievers for Viva Connections extends the Achievers Employee Experience platform into employees’ daily workflows. Members can enjoy some of their favorite activities found on their Achievers program: view upcoming celebrations, recognitions received, the latest trending recognitions, and perform quick actions, all on one dashboard within Viva Connections.
Qualtrics
The Qualtrics card brings experience management into Viva Connections seamlessly. It enables quick access to surveys and feedback tools, allowing organizations to gather valuable insights and act on employee, customer, and product experiences right from the dashboard. The Qualtrics card can link directly to surveys and let employees know when feedback is due, eliminating common barriers to organization-wide feedback.
Workday
With the Workday card, Viva Connections brings Workday data and actions to employees’ fingertips right in the dashboard. With this integration, users can access Workday tasks such as inbox items, time off balances, and more, simplifying HR processes and saving employees time on administrative tasks.
Features:
Customizable Workday® Web part in SharePoint & Adaptive Card extension for Viva Connections dashboard
Seamless Microsoft 365 integration: Get instant access to your Workday® data right within SharePoint using our Web part integration.
Developer-friendly: Easily customize the integration to fit your organization’s unique needs.
Streamlined workflows: Enjoy a seamless connection between Workday® and your Microsoft 365 apps for smooth data sharing and collaboration.
Jira
The Jira integration transforms how employees manage tasks, bugs, and user stories by pulling them directly into the Viva Connections card.
Features:
Unified view: Gain a comprehensive overview of your Jira tasks, including tickets, comments, and updates, all within a single SharePoint Web part.
Advanced search: Quickly define your own JQL queries to locate specific sets of tasks, shining a light on your path to productivity.
Real-Time updates: Stay informed with live data synchronization, ensuring you’re always up-to-date with the latest project developments.
Zendesk
The Zendesk card for Viva Connections allows users to access and manage their Zendesk tickets directly, facilitating a more efficient customer support workflow.
Features:
Display your Zendesk data right within SharePoint with a custom web part
Enjoy a seamless experience within your Microsoft 365 environment
Redefine productivity by viewing and creating tickets from a single place
Asana
This seamless connection allows for the direct embedding of Asana tasks into your Viva Connections dashboard, creating a unified workspace where you can manage tasks without switching between applications.
Features:
Integrate Asana tasks directly into SharePoint, providing a centralized view of your projects
Utilize advanced search capabilities within Asana’s data to generate dynamic views for your SharePoint web part
Ensure a cohesive workflow across the Microsoft 365 suite, enhancing productivity and collaboration
Turn Viva Connections into a project management superhub by adding Asana cards
Many of the third-party cards highlighted in this blog are available through the Microsoft partner Adenin. Check out more about their Viva Connections cards in our recent partner showcase blog.
How to access and install third-party cards
There are a few simple steps to . Anyone can look up the available applications but only IT administrators can install them.
All users can find applications via Microsoft AppSource or the SharePoint store. Installation requires administration permissions in SharePoint.
Select “Get it Now” to request the application is added to the App Catalogue site in your SharePoint environment.
Work with the IT Admin to Deploy the app and add it to your Viva Connections dashboard.
Once Viva Connections is deployed for the organization, all employee users can access the app on their Viva Connections .
Learn how to build your own dashboard cards to meet your business needs.
Learn more about third-party and adaptive cards
With dozens of third-party partner apps and M365 Viva apps to choose from, the opportunities for customization and enhanced productivity are vast. To start leveraging these powerful integrations, visit the SharePoint store and Microsoft AppSource today.
To learn more about the extensibility capabilities within the Viva Connections dashboard. View this course on Microsoft Learn.
For further guidance and resources, check out our comprehensive documentation as well as our latest blog featuring a guide of Viva Connections first-party .
Microsoft Tech Community – Latest Blogs –Read More
Pull attachments to SharePoint list from a Form using power automate
Anyone know how I can pull an attachment from a form to a SharePoint list using power automate?
Anyone know how I can pull an attachment from a form to a SharePoint list using power automate? Read More
AD B2C session limit issue
Token lifetime limit issue
We have a requirement to set token session limit to 3 months. Is there any way we can do it?On portal it’s showing we can set session to 7 days and on document it’s saying 1 day. Which one is right?
Token lifetime limit issueWe have a requirement to set token session limit to 3 months. Is there any way we can do it?On portal it’s showing we can set session to 7 days and on document it’s saying 1 day. Which one is right? Read More
Combine multiple restrictions in a question
Currently, while Microsoft Forms provides some validation options, the ability to set multiple conditions for a single question would enable users to create more complex and tailored forms. For example, combining restrictions such as requiring a specific format (like a Number) while also enforcing a character limit. Use Case: A form could require users to input their phone number validating that only numbers can be entered and reach a specific length (e.g., exactly “10” characters).
Currently, while Microsoft Forms provides some validation options, the ability to set multiple conditions for a single question would enable users to create more complex and tailored forms. For example, combining restrictions such as requiring a specific format (like a Number) while also enforcing a character limit. Use Case: A form could require users to input their phone number validating that only numbers can be entered and reach a specific length (e.g., exactly “10” characters). Read More
Exam Voucher – Changes ?
@DanDonohue Can you tell me if there are any news on the Exam Voucher pricing ? Was something published already ? In the Community Call you mentioned Sep 9th …
@DanDonohue Can you tell me if there are any news on the Exam Voucher pricing ? Was something published already ? In the Community Call you mentioned Sep 9th … Read More
Forms to Excel with Power Automate
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they’ve completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A.
Could anyone give me any pointers as to how I can get this fixed? Thank you so much!!
Hello! I have a group of students who have to take three different exams in order to use school resources. Students who pass each of the tests fill out a form ( Form A, Form B and Form C) after each one of them, acknowledging they’ve completed the specific course. I have an Excel Sheet automatically generated from the responses gathered in Form A (email, name, acknowledgement acceptance) and would like to add two more columns to display their responses to the acceptance question in Form B & C so I can see in a singular table which of the three resources they are authorized for. As you can see in the image below, I have been able to get as far as creating a new column to gather Form B responses (Power Automate>When a response is submitted>Get response details>Get User profile>Add row into a table) but I cannot get them on the same line as the responses by the same user in Form A.Could anyone give me any pointers as to how I can get this fixed? Thank you so much!! Read More
Teams login faild
Hello,
When I log in on my Macbook Air Sonoma, I get the error message: Something didn’t work 1001,
If I log in with another account it works.
I uninstalled and reinstalled Teams from Microsoft Homepage,
delet:
~/Library/Application Support/Microsoft/Teams
~/Library/Caches/com.microsoft.teams
~/Library/Group Containers/UBF8T346G9.com.microsoft.teams
~Library/Containers/Microsoft Teams2
didn’t help, the account will not be removed from teams and i cant login
are there somewhere hidden cache files from Teams on Mac ?
what else can I try?
Hello, When I log in on my Macbook Air Sonoma, I get the error message: Something didn’t work 1001,If I log in with another account it works.I uninstalled and reinstalled Teams from Microsoft Homepage,delet:~/Library/Application Support/Microsoft/Teams~/Library/Caches/com.microsoft.teams~/Library/Group Containers/UBF8T346G9.com.microsoft.teams~Library/Containers/Microsoft Teams2didn’t help, the account will not be removed from teams and i cant loginare there somewhere hidden cache files from Teams on Mac ?what else can I try? Read More
