Tag Archives: microsoft
Microsoft RD client Android app url scheme is not working
I’ve been using a legacy URL scheme in my Android app to open the RD Client app via a deep link and initiate an automatic connection with a remote server. It used to work fine, but now it’s no longer functioning. Is there a change in the URL scheme that hasn’t been documented, or perhaps an update that affects this functionality? Can someone guide me on this issue?
I’ve been using a legacy URL scheme in my Android app to open the RD Client app via a deep link and initiate an automatic connection with a remote server. It used to work fine, but now it’s no longer functioning. Is there a change in the URL scheme that hasn’t been documented, or perhaps an update that affects this functionality? Can someone guide me on this issue? Read More
Switch function with different date formats in Access SQL
Hi.
First time trying to use switch function to combine multiple queries to one. For some reason “DateValue” function overrides “DatePart” function in switch clause and gives me wrong format for the week and month parts. This query is for creating month, week and year reports in form.
Is there easy way to get this working? Date fields in table are in short text which i combine in query (C for day, B for month and A for year). Here’s the code:
SELECT Switch(
[Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),
[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))
) AS DateFormat, Sum(PK112.E) AS VM_sum, Sum(PK112.F) AS SM_sum, Sum(PK112.G) AS P1_KA_sum, Sum(PK112.H) AS P2_KA_sum, Sum(PK112.I) AS P1_KK_sum, Sum(PK112.J) AS P2_KK_sum, Avg(PK112.K) AS TP_AVG_avg, Avg(PK112.L) AS LP_AVG_avg, Avg(PK112.M) AS LV_AVG_avg
FROM PK112
WHERE ([Forms]![frm_Main]![btn_Pvk] = true)
OR ([Forms]![frm_Main]![btn_vk] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])
OR ([Forms]![frm_Main]![btn_kk] = true AND [PK112.B] = [Forms]![frm_Main].[frm_SubForm]![num_Kk] AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])
OR ([Forms]![frm_Main]![btn_vuosi] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])
GROUP BY Switch(
[Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),
[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))
)
ORDER BY Switch(
[Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),
[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))
);
Hi. First time trying to use switch function to combine multiple queries to one. For some reason “DateValue” function overrides “DatePart” function in switch clause and gives me wrong format for the week and month parts. This query is for creating month, week and year reports in form.Is there easy way to get this working? Date fields in table are in short text which i combine in query (C for day, B for month and A for year). Here’s the code: SELECT Switch([Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))) AS DateFormat, Sum(PK112.E) AS VM_sum, Sum(PK112.F) AS SM_sum, Sum(PK112.G) AS P1_KA_sum, Sum(PK112.H) AS P2_KA_sum, Sum(PK112.I) AS P1_KK_sum, Sum(PK112.J) AS P2_KK_sum, Avg(PK112.K) AS TP_AVG_avg, Avg(PK112.L) AS LP_AVG_avg, Avg(PK112.M) AS LV_AVG_avgFROM PK112WHERE ([Forms]![frm_Main]![btn_Pvk] = true)OR ([Forms]![frm_Main]![btn_vk] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])OR ([Forms]![frm_Main]![btn_kk] = true AND [PK112.B] = [Forms]![frm_Main].[frm_SubForm]![num_Kk] AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])OR ([Forms]![frm_Main]![btn_vuosi] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])GROUP BY Switch([Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A])))ORDER BY Switch([Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))); Read More
Unable to Import Excel files into SQL Server
Hello SQL Team,
I’m new to SQL Server & I just created a database and need to import an Excel file.
The problem is that the 3 methods of importing the file has failed.
If I use tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message:
2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error:
3. If I try importing in the csv format and import as a flat file, I get the following error message:
can anyone help please?
Hello SQL Team, I’m new to SQL Server & I just created a database and need to import an Excel file. The problem is that the 3 methods of importing the file has failed. If I use tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message: 2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error: 3. If I try importing in the csv format and import as a flat file, I get the following error message: can anyone help please? Read More
Only get part of the sharepoint list with JavaScript Fetch
Hello.
I have a problem with getting all SP list item (257 currently) with fetch.
I have the following code:
var tasks = new Request(
webUrl + “/_api/web/lists/GetByTitle(‘” + listName + “‘)/items?$top=300”
, {
method: “GET”,
credentials: ‘same-origin’,
headers: new Headers({
“Accept”: “application/json; odata=nometadata”,
})
});
fetch(tasks)
.then((response) => response.json())
.then((data) => {
let items = data.value;
console.log(‘Van: ‘ + data[“@odata.nextLink”])
items.forEach((item) => {
console.log(item.ID,item.Title,item.Program);
});
});
Without the top=300 part it only list 131 item (with it i get all item).
And the odata.nextLink is undefined. So it seems i dont get that.
How can i get all data?
Hello. I have a problem with getting all SP list item (257 currently) with fetch. I have the following code:var tasks = new Request(
webUrl + “/_api/web/lists/GetByTitle(‘” + listName + “‘)/items?$top=300”
, {
method: “GET”,
credentials: ‘same-origin’,
headers: new Headers({
“Accept”: “application/json; odata=nometadata”,
})
});
fetch(tasks)
.then((response) => response.json())
.then((data) => {
let items = data.value;
console.log(‘Van: ‘ + data[“@odata.nextLink”])
items.forEach((item) => {
console.log(item.ID,item.Title,item.Program);
});
});Without the top=300 part it only list 131 item (with it i get all item).And the odata.nextLink is undefined. So it seems i dont get that.How can i get all data? Read More
Copilot Deployment Kit in Viva Amplify now generally available
We are excited to announce the general availability of the Copilot Deployment Kit in Viva Amplify. Transform your organization to a new way of working with the power of AI in Copilot for Microsoft 365! Leveraging Microsoft’s internal Copilot deployment learnings and best practices, this Copilot Deployment Kit will help you drive awareness and adoption of Copilot by enabling employees to learn how to get ready for Copilot, what Copilot can do for them in their Microsoft 365 apps, and where to learn more.
Pre-built Copilot Deployment Kit available on campaign home page in Viva Amplify.
Includes 8 pre-drafted communications and campaign brief with objectives and key messages. Communicators can easily edit, review and publish to desired audiences through multiple channels including Outlook, Teams and SharePoint.
Communications include video introduction, simple and practical ways to try Copilot with example prompts, and additional resources to help build AI skills.
Campaign and publication reports help you see the effectiveness of the campaign.
See the the following video for a live demo on the Copilot Deployment Kit with Britt Boston (Microsoft) and and Vesa Juvonen (Microsoft).
Frequently asked questions
When will this happen?
The feature is rolling out currently to Targeted Release customers and will continue to roll out to all customers in June 2024.
This message is associated with Microsoft 365 Roadmap ID 392453.
What do you need to prepare?
This is add-on feature with the Viva Amplify and will be available within the product without any actions from your side.
How to get started using Viva Amplify
Viva Amplify empowers organizational communication teams and leaders to elevate their message and energize their people. Viva Amplify is part of Microsoft Viva Employee Experience platform. See more details from the official documentation.
What is next?
There are lot of new features in the roadmap for the Viva Amplify. We are currently working on the publishing support for the Viva Engage directly from the Viva Amplify, which will be available later this year (current plan). We are also looking into providing similar content packs with the Viva Amplify in future to streamline communications and make the change management easier. Your feedback and input is invaluable on building these experiences. Got an idea or feedback? – Please add comment below or use the Microsoft Feedback portal.
Thanks for reading. Let us know about your feedback on Viva Amplify or the Copilot Deployment Kit in the comments.
Microsoft Tech Community – Latest Blogs –Read More
Regarding file system error on Windows 10
I’ve been experiencing a strange issue with my Windows 10 system where I’m getting frequent file system errors. The error message usually appears when I’m trying to access or move files, and it says that the file system has encountered an error and is unable to complete the requested action. The error message also mentions a specific file or folder, but it’s always a random one. Sometimes the error is resolved by restarting the system or closing the application, but other times it persists and I’m unable to access the affected files or folders. Has anyone else experienced similar issues with their Windows 10 system, and if so, how did they resolve it?
I’ve been experiencing a strange issue with my Windows 10 system where I’m getting frequent file system errors. The error message usually appears when I’m trying to access or move files, and it says that the file system has encountered an error and is unable to complete the requested action. The error message also mentions a specific file or folder, but it’s always a random one. Sometimes the error is resolved by restarting the system or closing the application, but other times it persists and I’m unable to access the affected files or folders. Has anyone else experienced similar issues with their Windows 10 system, and if so, how did they resolve it? Read More
How to access shared subcalendars in Outlook new?
We use several shared calendarfolders for sharing information. These folders reside as subfolders of an account and are shared with everyone in the company. The users can access the folders perfectly in the old outlook desktop version, but this is not possible in the new version. Or is it possible that it’s only me that hasn’t figured out how? Does anybody know?
We use several shared calendarfolders for sharing information. These folders reside as subfolders of an account and are shared with everyone in the company. The users can access the folders perfectly in the old outlook desktop version, but this is not possible in the new version. Or is it possible that it’s only me that hasn’t figured out how? Does anybody know? Read More
I’m unable to login to https://dynamicspartners.transform.microsoft.com/
Hi,
I’m unable to login to https://dynamicspartners.transform.microsoft.com/. Nothing happens when I try to press the login button on the upper right corner.
Result has been the same with three different browsers (Firefox, Chrome & Edge) and with two different PCs.
Our IT says that I have the same rights than my predecessor who used to handle MS incentive cases. I am unable to for example download Proof of Execution documentation f.e: https://dynamicspartners.transform.microsoft.com/download/protected?assetname=protectedassets%2FPartner%20Activities%20-%20Business%20Value%20Assessment%20-%20POE%20Template.pptx&protected=1
Nothing happens when I open that link.
What rights should I have to be able to login to https://dynamicspartners.transform.microsoft.com/?
Any ideas that what could be causing this?
-Ossi
Hi, I’m unable to login to https://dynamicspartners.transform.microsoft.com/. Nothing happens when I try to press the login button on the upper right corner. Result has been the same with three different browsers (Firefox, Chrome & Edge) and with two different PCs. Our IT says that I have the same rights than my predecessor who used to handle MS incentive cases. I am unable to for example download Proof of Execution documentation f.e: https://dynamicspartners.transform.microsoft.com/download/protected?assetname=protectedassets%2FPartner%20Activities%20-%20Business%20Value%20Assessment%20-%20POE%20Template.pptx&protected=1 Nothing happens when I open that link. What rights should I have to be able to login to https://dynamicspartners.transform.microsoft.com/? Any ideas that what could be causing this? -Ossi Read More
Cannot get “$_.hiddenfromaddresslistsenabled -eq $true” to work with other parameters.
Hi Cannot get this command to work. Tried different variations and commands.
Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false -and $_.hiddenfromaddresslistsenabled -eq $true}
The below works fine:
Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false}
Can anyone help?
Hi Cannot get this command to work. Tried different variations and commands. Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false -and $_.hiddenfromaddresslistsenabled -eq $true} The below works fine:Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false} Can anyone help? Read More
Playlist Videos in Sharepoint list shows “Request Access” but i can be played upon clicking it
Hi Team,
We created a playlist and have shared the playlist videos to specific users. However, the playlist shows that they have to request for access. If the select the video, it can be played.
Why the “Request Access” is displayed though access is available. It misleads the user.
Hi Team, We created a playlist and have shared the playlist videos to specific users. However, the playlist shows that they have to request for access. If the select the video, it can be played. Why the “Request Access” is displayed though access is available. It misleads the user. Read More
Understanding SharePoint Online Storage
Understanding SharePoint Online storage used to be easy. Then applications like Loop arrived. Other influences like retention and archive can affect storage too. It’s a complicated situation before you throw OneDrive for Business into the mix and consider that Microsoft has removed unlimited OneDrive storage while an increasing number of apps store files in OneDrive. It’s a complicated situation.
https://office365itpros.com/2024/06/10/sharepoint-online-storage-2/
Understanding SharePoint Online storage used to be easy. Then applications like Loop arrived. Other influences like retention and archive can affect storage too. It’s a complicated situation before you throw OneDrive for Business into the mix and consider that Microsoft has removed unlimited OneDrive storage while an increasing number of apps store files in OneDrive. It’s a complicated situation.
https://office365itpros.com/2024/06/10/sharepoint-online-storage-2/ Read More
The End for Office 365 Connectors Comes Into Sight
Office 365 Connectors bring data from external sources into Microsoft 365 apps like Teams and Outlook. Workflows and Power Automate are replacing Connectors for Microsoft 365 Groups (Outlook groups) and SharePoint Online. Connectors are still available in Teams but for how long? No one knows, but it does seem like Microsoft is rationalizing no-code automation around Power Automate.
https://office365itpros.com/2024/06/11/office-365-connectors-end/
Office 365 Connectors bring data from external sources into Microsoft 365 apps like Teams and Outlook. Workflows and Power Automate are replacing Connectors for Microsoft 365 Groups (Outlook groups) and SharePoint Online. Connectors are still available in Teams but for how long? No one knows, but it does seem like Microsoft is rationalizing no-code automation around Power Automate.
https://office365itpros.com/2024/06/11/office-365-connectors-end/ Read More
Outlook Web based.
Good day!
I am hoping someone can assits me.
My dowloaded Outlook (Left) picks up all my messages but when I log into outlook on the microsoft website (right) it does not pick up any messages?
Good day! I am hoping someone can assits me.My dowloaded Outlook (Left) picks up all my messages but when I log into outlook on the microsoft website (right) it does not pick up any messages? Read More
Save the Date for Global DevOps Experience on June 15!
The Global DevOps Bootcamp, an annual event series that has captured the attention of the DevOps community worldwide by hosting local events to share the latest DevOps and relevant technologies as well as case studies, is being rebranded as the “Global DevOps Experience” (GDEX). This exciting event will take place on Saturday, June 15, 2024.
This event series will feature insights on DevOps, Platform Engineering, and Developer Experience (DevEx), leveraging technologies such as Azure, AI, and GitHub. DevOps communities from around the globe will come together to share their knowledge and experience. Microsoft MVPs and Regional Directors are planning various local events, eagerly anticipating interactions with participants as organizers and speakers.
Visit the event page to learn more about the event story and details of local community events in different countries. Don’t miss out on the opportunity to join an event that interests you.
Microsoft Tech Community – Latest Blogs –Read More
How to get the planner task Progress using power automate?
I am trying to filter the planner tasks based on the Progress column:-
i tried those 3 actions, but none of them will return or allow us to filter based on the Progress column:
1) List all Tasks
2) Get Task Details
3) Get a Task
any advice?
Thanks
I am trying to filter the planner tasks based on the Progress column:- i tried those 3 actions, but none of them will return or allow us to filter based on the Progress column: 1) List all Tasks2) Get Task Details3) Get a Task any advice?Thanks Read More
Can’t find password to email address on my pc
I’m having trouble accessing my email account on my Windows 11 computer. I’ve forgotten my password and can’t seem to recover it. I’ve tried using the password recovery feature on the email provider’s website, but it’s not working for me. I’ve checked my PC’s settings and can’t find any information on where my email password might be stored. Now, I’m stuck and unable to access my email account.
I’m looking for advice on how to recover my email password or reset it if possible.
I’m having trouble accessing my email account on my Windows 11 computer. I’ve forgotten my password and can’t seem to recover it. I’ve tried using the password recovery feature on the email provider’s website, but it’s not working for me. I’ve checked my PC’s settings and can’t find any information on where my email password might be stored. Now, I’m stuck and unable to access my email account. I’m looking for advice on how to recover my email password or reset it if possible. Read More
Recent changes could not be saved. Refresh the page to undo the changes and continue working
Hello,
Over the past few days I have experienced challenges with the Project for the web part.
It consists of changes not saved in the project folder. Instead, this error message appears.
“Recent changes could not be saved. Refresh the page to undo the changes and continue working. Correlation ID: 6883f5fd-35f0-4bef-8423-8e5bf2dfd36f”
What does this mean and what must be done so that I can use Project for the web again?
Best regards,
Hello, Over the past few days I have experienced challenges with the Project for the web part.It consists of changes not saved in the project folder. Instead, this error message appears.”Recent changes could not be saved. Refresh the page to undo the changes and continue working. Correlation ID: 6883f5fd-35f0-4bef-8423-8e5bf2dfd36f” What does this mean and what must be done so that I can use Project for the web again? Best regards, Read More
How pricing works on Azure Stack HCI?
Hi Experts,
We are planning to use Azure Stack HCI, one of our questions is how the pricing works for SQL on a VM and SQL using PaaS on HCI?
In our understanding SQL on a VM requires: SQL license, OS license, compute and storage cost.
Paas SQL on HCI requires compute and storage cost.
is this correct and which one is the most cost effective and if can you expound why?
Thank you in advance.
Hi Experts, We are planning to use Azure Stack HCI, one of our questions is how the pricing works for SQL on a VM and SQL using PaaS on HCI?In our understanding SQL on a VM requires: SQL license, OS license, compute and storage cost.Paas SQL on HCI requires compute and storage cost. is this correct and which one is the most cost effective and if can you expound why? Thank you in advance. Read More
matching excel row data to filename based on matching data left of underscore
Hoping somebody can help with what I believe can be done either using Power Query or VBA.
I have an Excel file that includes thousands of entries – each entry has an object number and SOME objects will have an associated file on the hard drive (or SharePoint / remote server). I would like the script to be able to review the data from the file name left of the first underscore to match with the object number and record the filename in the correct field “demo file path” in the attached sample file. E.g. object number 123 is related to file 123_has-extra_from_3733-AREA_RULE_Progress_Report_Feb._231955.pdf
I am OK if the system needs to place a message in the related entry that states “no match found”, it is a bonus but not required.
Hopefully with the sample data that includes a second tab of the file that are in the existing folder and the above details somebody can help out.
If the solution cannot read directly from a specific folder / site and needs a worksheet with all the file names, I can easily work with that solution.
Thank you.
Sample File Hoping somebody can help with what I believe can be done either using Power Query or VBA. I have an Excel file that includes thousands of entries – each entry has an object number and SOME objects will have an associated file on the hard drive (or SharePoint / remote server). I would like the script to be able to review the data from the file name left of the first underscore to match with the object number and record the filename in the correct field “demo file path” in the attached sample file. E.g. object number 123 is related to file 123_has-extra_from_3733-AREA_RULE_Progress_Report_Feb._231955.pdf I am OK if the system needs to place a message in the related entry that states “no match found”, it is a bonus but not required. Hopefully with the sample data that includes a second tab of the file that are in the existing folder and the above details somebody can help out. If the solution cannot read directly from a specific folder / site and needs a worksheet with all the file names, I can easily work with that solution. Thank you. Read More
How can I mute and unmute yourself from Windows taskbar in Microsoft Teams?
Specifically, I’m trying to find a way to mute and unmute myself directly from the Windows taskbar. I’ve noticed that sometimes my audio is turned on and I’m accidentally broadcasting my background noise to the team. I’d like to be able to quickly mute and unmute myself without having to navigate through the Microsoft Teams app or desktop interface.
Does anyone know how to access the audio settings from the Windows taskbar, or if there’s a shortcut or hotkey that allows me to quickly mute and unmute myself in Microsoft Teams?
Specifically, I’m trying to find a way to mute and unmute myself directly from the Windows taskbar. I’ve noticed that sometimes my audio is turned on and I’m accidentally broadcasting my background noise to the team. I’d like to be able to quickly mute and unmute myself without having to navigate through the Microsoft Teams app or desktop interface.Does anyone know how to access the audio settings from the Windows taskbar, or if there’s a shortcut or hotkey that allows me to quickly mute and unmute myself in Microsoft Teams? Read More