I’m trying to use the function with the following formula:

=SUMIF(B2:B10,”Tanken”,C2:C10)

I keep getting the, “There’s a problem with this formula”, error message.

When I close the message, the formula is highlighted from B10 through C2.

I have no idea why. According to every tutorial I have watched, the format is correct.

Any help would be greatly appreciated.

​I’m trying to use the function with the following formula:=SUMIF(B2:B10,”Tanken”,C2:C10)I keep getting the, “There’s a problem with this formula”, error message.When I close the message, the formula is highlighted from B10 through C2.I have no idea why. According to every tutorial I have watched, the format is correct.Any help would be greatly appreciated.  Read More

​

this issue is initially posted here: https://techcommunity.microsoft.com/t5/azure-virtual-desktop-feedback/ipados-rd-client-hijacks-keyboard-shortcut/idi-p/4187156

and somewhat expected it’s quickly marked as “close”. however, i need to emphasize again, this is a product design issue, not something can be “troubleshoot”ed.

No matter how much you love those macos/ios keyboard shortcuts, when you use the app to connect to a windows pc/vm, the user is expecting it to work as a windows pc, not having some shortcut hijacked to achieve the effect someone desired. it can be an option, but shouldn’t never be the default.

“as good as it supports hardware acceleration, the keyboard shortcut hijack is atrocious. all win key is hijacked to achieve some uninvited cmd-a c v x t thing in windows.

as a result almost all win key shortcuts now don’t work! to make it worse, even regular shortcut and single key doesn’t work like other app, it can be easily tested in blender, rendering the app completely useless.

also for who know what reason, even on keyboard that have pageup pagedown home end key, you need some very creative shortcut to achieve it, again, not an issue in other third party client.

the worst part is, after wreaking all the havoc, one would expect it hijack ios shortcut as well, but it doesn’t! if you press ctrl + space, that ios keyboard pops up revealing the now changed language.

can’t you just send the key as is?”

​this issue is initially posted here: https://techcommunity.microsoft.com/t5/azure-virtual-desktop-feedback/ipados-rd-client-hijacks-keyboard-shortcut/idi-p/4187156 and somewhat expected it’s quickly marked as “close”. however, i need to emphasize again, this is a product design issue, not something can be “troubleshoot”ed.  No matter how much you love those macos/ios keyboard shortcuts, when you use the app to connect to a windows pc/vm, the user is expecting it to work as a windows pc, not having some shortcut hijacked to achieve the effect someone desired. it can be an option, but shouldn’t never be the default. “as good as it supports hardware acceleration, the keyboard shortcut hijack is atrocious. all win key is hijacked to achieve some uninvited cmd-a c v x t thing in windows. as a result almost all win key shortcuts now don’t work! to make it worse, even regular shortcut and single key doesn’t work like other app, it can be easily tested in blender, rendering the app completely useless. also for who know what reason, even on keyboard that have pageup pagedown home end key, you need some very creative shortcut to achieve it, again, not an issue in other third party client. the worst part is, after wreaking all the havoc, one would expect it hijack ios shortcut as well, but it doesn’t! if you press ctrl + space, that ios keyboard pops up revealing the now changed language. can’t you just send the key as is?”  Read More

​

This issue is initially posted here: https://techcommunity.microsoft.com/t5/azure-virtual-desktop-feedback/physical-keyboard-not-working/idc-p/4194302#M3330

The origin post was closed and suggest to send it here

​This issue is initially posted here: https://techcommunity.microsoft.com/t5/azure-virtual-desktop-feedback/physical-keyboard-not-working/idc-p/4194302#M3330 The origin post was closed and suggest to send it here  Read More

​

I have an ASP.NET Core Web API that was working perfectly on my Windows machine. I needed to deploy it on an Ubuntu Linux 22.04 LTS server. I followed this guide.

The application runs and can be accessed through the browser using localhost:5169. in Linux However, when a client tries to fetch data using the Linux server’s IP address and port endpoint, it throws the following exception: I am using HTTP currently

Client Window app access then this exception shows in the terminal of Linux. If I use Client android app then it does not throw any exception it just says Time out.

fail: Microsoft.EntityFrameworkCore.Database.Connection[20004]
An error occurred using the connection to database ‘****’ on server ‘******’.
fail: Microsoft.EntityFrameworkCore.Query[10100]
An exception occurred while iterating over the results of a query for context type ‘****.ApiContext.apiContext’.
Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 – Encryption(ssl/tls) handshake failed)
—> System.IO.IOException: Received an unexpected EOF or 0 bytes from the transport stream……..

Microsoft.EntityFrameworkCore.SqlServer 8.0.2 (Installed)

Connection String

“ApiString”: “Data Source=DB***;Initial Catalog=***;User Id=user;Password=**********;Connect Timeout=30;Encrypt=false;TrustServerCertificate=true;Persist Security Info=false;Application Intent=ReadWrite;MultiSubnetFailover=false”

LaunchSettings.Json

“profiles”: {
“Image_catalogue”: {
“commandName”: “Project”,
“launchBrowser”: true,
“launchUrl”: “swagger”,
“environmentVariables”: {
“ASPNETCORE_ENVIRONMENT”: “Development”
},
“dotnetRunMessages”: true,
“applicationUrl”: “http://localhost:5169”,
“nativeDebugging”: false
},

Any assistance in resolving this issue would be greatly appreciated.

​I have an ASP.NET Core Web API that was working perfectly on my Windows machine. I needed to deploy it on an Ubuntu Linux 22.04 LTS server. I followed this guide.The application runs and can be accessed through the browser using localhost:5169. in Linux However, when a client tries to fetch data using the Linux server’s IP address and port endpoint, it throws the following exception: I am using HTTP currentlyClient Window app access then this exception shows in the terminal of Linux. If I use Client android app then it does not throw any exception it just says Time out.fail: Microsoft.EntityFrameworkCore.Database.Connection[20004]
An error occurred using the connection to database ‘****’ on server ‘******’.
fail: Microsoft.EntityFrameworkCore.Query[10100]
An exception occurred while iterating over the results of a query for context type ‘****.ApiContext.apiContext’.
Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 – Encryption(ssl/tls) handshake failed)
—> System.IO.IOException: Received an unexpected EOF or 0 bytes from the transport stream……..Microsoft.EntityFrameworkCore.SqlServer 8.0.2 (Installed)Connection String”ApiString”: “Data Source=DB***;Initial Catalog=***;User Id=user;Password=**********;Connect Timeout=30;Encrypt=false;TrustServerCertificate=true;Persist Security Info=false;Application Intent=ReadWrite;MultiSubnetFailover=false”LaunchSettings.Json “profiles”: {
“Image_catalogue”: {
“commandName”: “Project”,
“launchBrowser”: true,
“launchUrl”: “swagger”,
“environmentVariables”: {
“ASPNETCORE_ENVIRONMENT”: “Development”
},
“dotnetRunMessages”: true,
“applicationUrl”: “http://localhost:5169”,
“nativeDebugging”: false
}, Any assistance in resolving this issue would be greatly appreciated.  Read More

​

We had an outage earlier this week due to a Partner Center API change that caused our CSP marketplace to no longer work.  Can we please ask that the PC API engineering team adopt professional devops processes and a) communicate in advance when a change is being made, and b) provide a staging site that partners can test their API integration applications before the API changes are pushed to production? 

​We had an outage earlier this week due to a Partner Center API change that caused our CSP marketplace to no longer work.  Can we please ask that the PC API engineering team adopt professional devops processes and a) communicate in advance when a change is being made, and b) provide a staging site that partners can test their API integration applications before the API changes are pushed to production?   Read More

​

Hi–I’m trying to figure out how to remove Fireflies.ai. I’ve tried logging into the app, and it gives me a 403 error. I’ve recently changed employers–I’m wondering if it was installed on my former work account, and  I no longer have access to it. But the app still joins all of my meetings and sends notes to my personal gmail account (notes that I can’t open, lol). I really need to get rid of this immediately–my new employer sees it as a security risk. I’m not super tech savvy. I would deeply appreciate your help. Thanks. 

​Hi–I’m trying to figure out how to remove Fireflies.ai. I’ve tried logging into the app, and it gives me a 403 error. I’ve recently changed employers–I’m wondering if it was installed on my former work account, and  I no longer have access to it. But the app still joins all of my meetings and sends notes to my personal gmail account (notes that I can’t open, lol). I really need to get rid of this immediately–my new employer sees it as a security risk. I’m not super tech savvy. I would deeply appreciate your help. Thanks.   Read More

​

Hello ,

I am experiencing difficulties in granting access to manage emails on Microsoft Defender XDR to the SOC team. While the RBAC model in Entra ID roles supports GDAP using our CSP accounts, the roles in Defender XDR operate under a completely independent model (unified RBAC defender XDR), making management via our CSP accounts impossible.

I have reviewed the Microsoft Defender Endpoint RBAC documentation but found no solution.

There are Email & collaboration roles in the Microsoft Defender portal that have no equivalent to Microsoft Entra roles, and are important for security operations (for example the Preview role and the Search and Purge role).

Could you provide guidance on how to achieve this, or suggest an alternative approach?

Your assistance would be greatly appreciated.

​Hello ,I am experiencing difficulties in granting access to manage emails on Microsoft Defender XDR to the SOC team. While the RBAC model in Entra ID roles supports GDAP using our CSP accounts, the roles in Defender XDR operate under a completely independent model (unified RBAC defender XDR), making management via our CSP accounts impossible.I have reviewed the Microsoft Defender Endpoint RBAC documentation but found no solution. There are Email & collaboration roles in the Microsoft Defender portal that have no equivalent to Microsoft Entra roles, and are important for security operations (for example the Preview role and the Search and Purge role). Could you provide guidance on how to achieve this, or suggest an alternative approach? Your assistance would be greatly appreciated.    Read More

​

Hello, I have a MS Bookings related question, I am not sure this is the right place, since I cannot add a bookings related tag.

However, the question relates to Shared Booking Pages. Is there any chance to gt appointment into one user mailbox calendar, he is part of the booking service staff.

But while there is another staff member whith regular settings, this user mailbox is aimed to only provide a gathered overview to several users (which are part of other shared booking pages) with all appointment.

So relevant for the booking it that only one out of two staff members calendar should be considered, while both calendars are invited for a booking. That’s why this specific mailbox (yet it is an user mailbox, might also be a shared mailbox if possible) should have all meetings shown as free, because otherwise it would interfere with availability of the “real” user to be booked.

any idea how I can accomplish this?

kind regards,

Dieter

​Hello, I have a MS Bookings related question, I am not sure this is the right place, since I cannot add a bookings related tag.However, the question relates to Shared Booking Pages. Is there any chance to gt appointment into one user mailbox calendar, he is part of the booking service staff.But while there is another staff member whith regular settings, this user mailbox is aimed to only provide a gathered overview to several users (which are part of other shared booking pages) with all appointment.So relevant for the booking it that only one out of two staff members calendar should be considered, while both calendars are invited for a booking. That’s why this specific mailbox (yet it is an user mailbox, might also be a shared mailbox if possible) should have all meetings shown as free, because otherwise it would interfere with availability of the “real” user to be booked.any idea how I can accomplish this?kind regards,Dieter  Read More

​