Month: September 2024
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.
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
Trail Version – Invalid Activation Key(379)
I am trying to use the trail version but I am getting this Invalid Activation Key (379) error.
I just created a new gmail for the trail and never installed on any other device. I created matlab account and downloaded the trail version installer which gave me this error when trying to login to installI am trying to use the trail version but I am getting this Invalid Activation Key (379) error.
I just created a new gmail for the trail and never installed on any other device. I created matlab account and downloaded the trail version installer which gave me this error when trying to login to install I am trying to use the trail version but I am getting this Invalid Activation Key (379) error.
I just created a new gmail for the trail and never installed on any other device. I created matlab account and downloaded the trail version installer which gave me this error when trying to login to install trail, invalid licence key, 379, error 379 MATLAB Answers — New Questions
How correctly use Simple Variable Mass 3DOF (Body Axes) block?
Hello,
As in the title, I need to simulate an aircraft mission with varying mass. In the Aerospace Blockset, I’ve so found the Simple Variable Mass (3DOF). I have some problems in interpreting these inertia definitions:
Empty inertia — Body inertia when fuel tank is full
0.5 (default) | scalar
Body inertia when the fuel tank is full, specified as a double scalar.
and
Full inertia — Full inertia
3.0 (default) | scalar
Full inertia of the body, specified as a scalar.
My concerns involves the difference between Empty and full inertia. From the documentation, they seem to be the same. Can anyone help me?
Thanks.Hello,
As in the title, I need to simulate an aircraft mission with varying mass. In the Aerospace Blockset, I’ve so found the Simple Variable Mass (3DOF). I have some problems in interpreting these inertia definitions:
Empty inertia — Body inertia when fuel tank is full
0.5 (default) | scalar
Body inertia when the fuel tank is full, specified as a double scalar.
and
Full inertia — Full inertia
3.0 (default) | scalar
Full inertia of the body, specified as a scalar.
My concerns involves the difference between Empty and full inertia. From the documentation, they seem to be the same. Can anyone help me?
Thanks. Hello,
As in the title, I need to simulate an aircraft mission with varying mass. In the Aerospace Blockset, I’ve so found the Simple Variable Mass (3DOF). I have some problems in interpreting these inertia definitions:
Empty inertia — Body inertia when fuel tank is full
0.5 (default) | scalar
Body inertia when the fuel tank is full, specified as a double scalar.
and
Full inertia — Full inertia
3.0 (default) | scalar
Full inertia of the body, specified as a scalar.
My concerns involves the difference between Empty and full inertia. From the documentation, they seem to be the same. Can anyone help me?
Thanks. 3dof, varying mass, aerospace, simulink, simulation MATLAB Answers — New Questions
Simulink Variable Time Logging
Hi,
is it possible to get a simulink "to workspace" block to log the data with variable time steps? I have a model in which some parameters are used to send it to hardware and the testrig is basically controlled with my model. For some commands I send to the testrig it is not really useful to have the logged within the sample time I have for my model, for example some preparation steps when I change the temperature, which could take quite long. I tried to have the different sample times in a varaible in the base workspace and after the command in simulink/ stateflow is processed the variable is changed. I had the variable of the sample time in my "to workspace" block, and it seemed to work sometimes to refresh the block and it changed to a new sample time, but it kept it that way for the whole simulation. Do you have any suggestions on how I could do this or maybe a better way to do this?Hi,
is it possible to get a simulink "to workspace" block to log the data with variable time steps? I have a model in which some parameters are used to send it to hardware and the testrig is basically controlled with my model. For some commands I send to the testrig it is not really useful to have the logged within the sample time I have for my model, for example some preparation steps when I change the temperature, which could take quite long. I tried to have the different sample times in a varaible in the base workspace and after the command in simulink/ stateflow is processed the variable is changed. I had the variable of the sample time in my "to workspace" block, and it seemed to work sometimes to refresh the block and it changed to a new sample time, but it kept it that way for the whole simulation. Do you have any suggestions on how I could do this or maybe a better way to do this? Hi,
is it possible to get a simulink "to workspace" block to log the data with variable time steps? I have a model in which some parameters are used to send it to hardware and the testrig is basically controlled with my model. For some commands I send to the testrig it is not really useful to have the logged within the sample time I have for my model, for example some preparation steps when I change the temperature, which could take quite long. I tried to have the different sample times in a varaible in the base workspace and after the command in simulink/ stateflow is processed the variable is changed. I had the variable of the sample time in my "to workspace" block, and it seemed to work sometimes to refresh the block and it changed to a new sample time, but it kept it that way for the whole simulation. Do you have any suggestions on how I could do this or maybe a better way to do this? variable logging time, sample time, simulink MATLAB Answers — New Questions
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
Deploy agent on Azure Virtual Machine Scale Sets
Hi,
I am looking for information if Defender for Endpoint is support to be installed on Azure Virtual Machine Scale Sets?
I have not been able to find any information either way. However, the fact that my Defender for Servers plan has not installed it on them, make me suspect they are not supported.
Can anyone please confirm? a official link would be preferred to suspicions.
Hi, I am looking for information if Defender for Endpoint is support to be installed on Azure Virtual Machine Scale Sets?I have not been able to find any information either way. However, the fact that my Defender for Servers plan has not installed it on them, make me suspect they are not supported. Can anyone please confirm? a official link would be preferred to suspicions. Read More
Temporary error 403 on images
I’ve been having the following problem for some time now. Some images are repeatedly not displayed on the website (error 403). These are also linked as an image. If I click on the link, they appear without any problems. When I refresh the page with cache turned off, different images are affected. Does anyone have an idea?
for instance www.salzlandkreis.de/bildungkultur/ringheiligtum-poemmelte/impressionen
I’ve been having the following problem for some time now. Some images are repeatedly not displayed on the website (error 403). These are also linked as an image. If I click on the link, they appear without any problems. When I refresh the page with cache turned off, different images are affected. Does anyone have an idea? for instance www.salzlandkreis.de/bildungkultur/ringheiligtum-poemmelte/impressionen Read More
Searching with Loop components – What is the plan?
Q1: OneNote has a capable search that includes OCR and handwriting, but the search capabilities with Loop are limited, especially when using components throughout the 365 ecosystems. What are the blockers and what is the intent for search within Loop and components?
Q1: OneNote has a capable search that includes OCR and handwriting, but the search capabilities with Loop are limited, especially when using components throughout the 365 ecosystems. What are the blockers and what is the intent for search within Loop and components? Read More
Getting insights for book sales using Copilot
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will once again use this table of book sales, using Copilot to find more insights.
I ask Copilot:
Which category has the best user ratings
I would also like to know which author is best, so I ask Copilot:
Which author has the highest average user rating?
After getting that response, I would like to know more than just the top author, so I ask:
Show me the top 5 authors by user rating
With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation.
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will once again use this table of book sales, using Copilot to find more insights.
Table of book sales with columns for Book Id, Release date, Author, Category, Publishing Branch, User Rating and Sales
I ask Copilot:
Which category has the best user ratings
Copilot in Excel pane showing above prompt and response, The category with the best user ratings is Children Books with an average user rating of 3.861.
I would also like to know which author is best, so I ask Copilot:
Which author has the highest average user rating?
Copilot in Excel pane showing the above prompt and the response, The author with the highest average user rating is Kenneth Liew with an average user rating of 4.533.
After getting that response, I would like to know more than just the top author, so I ask:
Show me the top 5 authors by user rating
Copilot in Excel pane with the above prompt and the response: The top 5 authors by average user rating are Kenneth Liew (4.53), Tania Agius (4.5), Bernadette Leblanc (4.4), Andrew Fenec (4.35), and Belinda Kaur (4.33)
With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation.
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
Thanks for reading,
Microsoft Excel Team
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks. Read More