Tag Archives: microsoft
Excel crashing when combining BYCOL and INDIRECT
Following recent updates (Excel latest version and/or MacOS 14.5 ?), Excel crashes systematically on Mac OS 14.5, with a simple formula using BYCOL & INDIRECT:
=BYCOL(A3:E3;LAMBDA(col;INDIRECT(INDEX(col;1))))
with following data starting in A1
toto1toto2toto3toto4toto5 A1A2A3A4A5
my configuration : MacOS 14.5 on Macbook pro 16 with Apple M3 Max + Excel version 16.85 (24051214) with Microsoft 365 subscription
a few days ago (before latest updates) it wouldn’t crash.
Thanks for your support.
Following recent updates (Excel latest version and/or MacOS 14.5 ?), Excel crashes systematically on Mac OS 14.5, with a simple formula using BYCOL & INDIRECT:=BYCOL(A3:E3;LAMBDA(col;INDIRECT(INDEX(col;1))))with following data starting in A1toto1toto2toto3toto4toto5 A1A2A3A4A5my configuration : MacOS 14.5 on Macbook pro 16 with Apple M3 Max + Excel version 16.85 (24051214) with Microsoft 365 subscriptiona few days ago (before latest updates) it wouldn’t crash.Thanks for your support. Read More
Autopopulate data in one sheet (using formula’s) based on data update in another sheet.
Hi, I need to Autopopulate data in one sheet (using formula’s) based on data update in another sheet.
When i update Values in Col 1, Col2 , Col 4, Col5, Col 6 on this current sheet – i want values in another sheet in the same excel worksheet to be updated (they have formula to refer these cells).
Any suggestions on how to achieve this? Thanks.
Hi, I need to Autopopulate data in one sheet (using formula’s) based on data update in another sheet.When i update Values in Col 1, Col2 , Col 4, Col5, Col 6 on this current sheet – i want values in another sheet in the same excel worksheet to be updated (they have formula to refer these cells).Any suggestions on how to achieve this? Thanks. Read More
Entra ID Shared Device Mode Sign-out Button
Hi All
I hope you are well.
Anyway, I’m configuring some devices in Entra ID Shared Device Mode and pretty easy so far.
One thing I have noticed is that there is NO obvious SIGN-OUT button, best I could find was to swipe down from the top > Account > Sign-out
Non-technical users may struggle with that.
Any ideas on how to display a more obvious Sign-out button?
Info appreciated
Hi All I hope you are well. Anyway, I’m configuring some devices in Entra ID Shared Device Mode and pretty easy so far. One thing I have noticed is that there is NO obvious SIGN-OUT button, best I could find was to swipe down from the top > Account > Sign-out Non-technical users may struggle with that. Any ideas on how to display a more obvious Sign-out button? Info appreciated Read More
Azure Function App Http Javascript render simple html file to replicate jsrsasign sign certificate
Good day, Please Help.
1. In PowerBI im trying to render the javascript sign certificate of jsrsasign, i only got it working via an html file. So im trying to read the html file, simple hello to start of with. Am i better going directly to do the jsrsasign?
2. Locally on VS i got the simple function to return Hello Azure, but trying to read the simple html file executes no error but if i copy in postman i just get a 401 no content found, im not sure how further to debug as in VS i get Ok status, Nothing in Console?
Anybody have an example or links plz?
const { app } = require(‘@azure/functions’);
const fs = require(‘fs’);
const path = require(‘path’);
app.http(‘IC5’, {
methods: [‘GET’, ‘POST’],
authLevel: ‘anonymous’,
handler: async (request, context) => {
context.log(`Http function processed request for url “${request.url}”`);
// const name = request.query.get(‘name’) || await request.text() || ‘world’;
// return { body: `Hello, ${name}!` };
//var res = {
//body: “”,
//headers: {
//”Content-Type”: “text/html”
//}
//};
// readFile = require(‘../SharedCode/readFile.js’);
//filepath = __dirname + ‘/test3.html’;
//fs = require(‘fs’);
//await fs.readFile(filepath,function(error,content){
fs.readFile(path.resolve(‘./test3.html’), ‘UTF-8’, (err, htmlContent) => {
context.res = {
status: 200,
headers: {
‘Content-Type’: ‘text/html’
},
body: htmlContent
}
})
// if (request.query.name || (request.body && request.body.name)) {
// res.body = “<h1>Hello ” + (request.query.name || request.body.name) + “</h1>”;
//} else {
//fs.readFile(path.resolve(__dirname,’test3.html’), ‘UTF-8’, (err, htmlContent) => {
//res.body= htmlContent;
//context.res = res;
//});
// }
}
});
//TEST IN POSTMAN: http://localhost:7071/api/IC5?name=hurry
Good day, Please Help. 1. In PowerBI im trying to render the javascript sign certificate of jsrsasign, i only got it working via an html file. So im trying to read the html file, simple hello to start of with. Am i better going directly to do the jsrsasign? 2. Locally on VS i got the simple function to return Hello Azure, but trying to read the simple html file executes no error but if i copy in postman i just get a 401 no content found, im not sure how further to debug as in VS i get Ok status, Nothing in Console? Anybody have an example or links plz? const { app } = require(‘@azure/functions’);
const fs = require(‘fs’);
const path = require(‘path’);
app.http(‘IC5’, {
methods: [‘GET’, ‘POST’],
authLevel: ‘anonymous’,
handler: async (request, context) => {
context.log(`Http function processed request for url “${request.url}”`);
// const name = request.query.get(‘name’) || await request.text() || ‘world’;
// return { body: `Hello, ${name}!` };
//var res = {
//body: “”,
//headers: {
//”Content-Type”: “text/html”
//}
//};
// readFile = require(‘../SharedCode/readFile.js’);
//filepath = __dirname + ‘/test3.html’;
//fs = require(‘fs’);
//await fs.readFile(filepath,function(error,content){
fs.readFile(path.resolve(‘./test3.html’), ‘UTF-8’, (err, htmlContent) => {
context.res = {
status: 200,
headers: {
‘Content-Type’: ‘text/html’
},
body: htmlContent
}
})
// if (request.query.name || (request.body && request.body.name)) {
// res.body = “<h1>Hello ” + (request.query.name || request.body.name) + “</h1>”;
//} else {
//fs.readFile(path.resolve(__dirname,’test3.html’), ‘UTF-8’, (err, htmlContent) => {
//res.body= htmlContent;
//context.res = res;
//});
// }
}
});
//TEST IN POSTMAN: http://localhost:7071/api/IC5?name=hurry Read More
Why is Exchange 2016 using DNS A record instead of MX record to send mail?
Exchange 2016 trying to send mail to sargb.com.
Instead of sending to their MX “sargb-com.mail.protection.outlook.com”, it is sending mail to sargb.com (18.235.162.72).
I cleared the DNS cache on the 2-domain controllers and flushed DNS on Exchange.
What should I try next?
TiA!
Exchange 2016 trying to send mail to sargb.com.Instead of sending to their MX “sargb-com.mail.protection.outlook.com”, it is sending mail to sargb.com (18.235.162.72).I cleared the DNS cache on the 2-domain controllers and flushed DNS on Exchange.What should I try next?TiA! Read More
Increased security visibility through new Standard Logs in Microsoft Purview Audit
Microsoft Purview Audit provides an integrated solution to help organizations effectively respond to security incidents, forensic investigations, internal investigations, and compliance obligations. As announced in the previous Microsoft blogs in July 2023 and October 2023, Microsoft Purview Audit is expanding access to wider cloud security activity logs. As part of the changes, Audit (Standard) license holders will be able to access an additional 30 audit logs that were previously generated only for Audit (Premium) license holders. Eleven new Standard logs under Stream and Viva Engage workloads became Generally Available in November 2023.
We are excited to announce that the remaining 19 new Standard logs under Exchange, Microsoft Teams, and SharePoint Online workloads are now available in Public Preview to all Worldwide and Gov cloud customers. To learn more about when these logs will become Generally Available in your tenant, please visit the Public roadmap.
Overview of New Standard Logs
19 new Standard logs are now available in Public Preview under Exchange, Microsoft Teams, and SharePoint Online workloads. The following table provides details of these logs.
Workload
Operation
Description
Exchange
send
A message was sent, replied to or forwarded.
mailitemsaccessed
Messages were read or accessed in mailbox.
searchqueryinitiatedexchange
Triggered when a user searches for items in an Exchange mailbox.
Teams
meetingparticipantdetail
Teams added information about the participants of a meeting, including the user ID of each participant, the time a participant joined the meeting, and the time a participant left the meeting.
messagesent
A new message was posted to a chat or channel.
messageslisted
Messages from a chat or channel were retrieved.
meetingdetail
Teams added information about a meeting, including the start time, the end time, and the URL to join the meeting.
messageupdated
A message of a chat or channel was updated.
chatretrieved
A Microsoft Teams chat was retrieved.
messageread
A message from a chat or channel was retrieved.
messagehostedcontentread
Hosted content in a message, such as an image or a code snippet, was retrieved.
subscribedtomessages
A subscription was created by a listener application to receive change notifications for messages.
messagehostedcontentslisted
All hosted content in a message, such as images or code snippets, was retrieved.
chatcreated
A Teams chat was created.
chatupdated
A Teams chat was updated.
messagecreatednotification
A change notification was sent to notify a subscribed listener application of a new message.
messagedeletednotification
A change notification was sent to notify a subscribed listener application of a deleted message.
messageupdatednotification
A change notification was sent to notify a subscribed listener application of an updated message.
SharePointOnline
searchqueryinitiatedsharepoint
Triggered when a user searches for items in SharePoint sites of the organization.
The following 11 new Standard Logs under Stream and Viva Engage workloads are Generally Available.
Workload
Operation
Description
Stream
streaminvokegettranscript
A transcript was extracted from Microsoft Stream.
streaminvokechannelview
This event tracks when a user views a channel in Microsoft Stream.
streaminvokegettexttrack
Accessing or retrieving text tracks (such as captions or subtitles) associated with a video in Microsoft Stream.
streaminvokegetvideo
Video content was invoked on Microsoft Stream.
streaminvokegroupview
A group was viewed on Microsoft Stream.
Viva Engage (Yammer)
threadviewed
User views a thread on Viva Engage.
threadaccessfailure
User failed to access a thread on Viva Engage.
messageupdated
User updates a message in Viva Engage.
fileaccessfailure
User failed to access a file in Viva Engage.
messagecreation
User creates a message in Viva Engage.
groupaccessfailure
User failed to access a group in Viva Engage.
Premium insights available for Audit (Premium) users
Audit (Premium) license holders will continue to get longer default retention, broader access to export data, higher bandwidth API access, and logs enriched by Microsoft’s AI-powered intelligent insights. If your organization has users with an Audit (Premium) license, they will generate the following logs with additional data described in the Premium Insight column below.
Workload
Operation
Premium Insight
Exchange
mailitemsaccessed
SensitivityLabel
Teams
meetingparticipantdetail
IsJoinedFromLobby
messageslisted
AppAccessContext
messageupdated
ParticipantInfo, AppAccessContext
chatretrieved
AppAccessContext
messageread
AppAccessContext
messagehostedcontentread
AppAccessContext
subscribedtomessages
AppAccessContext
messagehostedcontentslisted
AppAccessContext
chatcreated
AppAccessContext
chatupdated
AppAccessContext
messagecreatednotification
AppAccessContext
messagedeletednotification
AppAccessContext
messageupdatednotification
AppAccessContext
Enable Exchange Mailbox Logging
The Exchange MailItemsAccessed and Send logs are enabled by default unless the mailbox’s DefaultAuditSet setting was modified. To ensure these new standard logs are generated, an admin may need to ensure the appropriate mailbox settings are enabled.
The following command can be used to check if a mailbox is currently using the default audit settings:
Get-Mailbox -Identity <MailboxIdentity>
The DefaultAuditSet property returned by the Get-Mailbox cmdlet; a mailbox using the defaults will show the following result:
DefaultAuditSet : { Owner, Admin, Delegate }
If any of those values are missing, the mailbox is not using the default audit settings.
If any changes were previously made to the default mailbox settings for a Standard user, an update must be made to enable the new standard Exchange logs for each mailbox. To ensure the new standard Exchange logs MailItemsAccessed and Send are stored, admins will either need to make sure Audit mailboxes are configured to the default settings or add the new standard logs to each mailbox. The following changes can be made in Exchange Online PowerShell.
Option 1: Reset each mailbox to the default settings
Any previous customizations, like auditing of MailboxLogin, will be reset once the mailbox is using the default settings. The following command will re-enable the default audit settings for the mailbox:
Set-Mailbox -Identity <MailboxIdentity> -DefaultAuditSet Admin,Delegate,Owner
Option 2: Add the new standard logs to each mailbox
If you would prefer to keep the customizations for each mailbox, the following Set-Mailbox command will add the new standard logs to each mailbox. This command will add (only) the new Standard logs for each mailbox, retaining any existing customization, but any future changes to the defaults will need to be added at that point:
Set-Mailbox -Identity <MailboxIdentity> -AuditOwner {@Add=”MailItemsAccessed”,”Send” } -AuditAdmin {@Add=”MailItemsAccessed”,”Send”} -AuditDelegate {@Add=”MailItemsAccessed”}
Enable Mailboxes for all Standard Users
Every standard user mailbox should have AuditEnabled set to true to ensure all audit records are uploaded to Purview Audit. This step is not necessary for any users with an Audit Premium license assigned. Please note that this Set-Mailbox command must be run for every Standard license user regardless of its current value to correctly enable their mailbox to upload the new standard logs to Purview Audit.
The following command will set AuditEnabled to true.
Set-Mailbox -Identity <MailboxIdentity> -AuditEnabled $true
More information regarding the setup instructions for these commands and information regarding permissions can be found here. Detailed information regarding activating these new logs for Audit Standard users will be added in a future update to the Microsoft Purview Audit public documentation.
We are pleased to share today’s cloud logging update as a continuation of the thoughtful conversations we’ve had with our security experts, customers, and influential authorities like CISA. Please visit the Public roadmap to get the latest information on updates coming to Microsoft Purview Audit.
Microsoft Tech Community – Latest Blogs –Read More
Announcing public preview of Bicep templates support for Microsoft Graph
v:* {behavior:url(#default#VML);}
o:* {behavior:url(#default#VML);}
w:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
Dan Kershaw
Normal
Dan Kershaw
3
6436
2024-05-15T17:40:00Z
2024-05-15T17:43:00Z
1
786
4484
37
10
5260
16.00
Clean
Clean
false
false
false
false
EN-GB
X-NONE
<w:LidThemeComplexscript>X-NONE</w:LidThemeComplexscript>
We’re thrilled to announce that Bicep templates for Microsoft Graph resources will be in public preview starting May 21st. Bicep templates bring declarative infrastructure-as-code (IaC) capabilities to Microsoft Graph resources. This new capability will initially be available for core Microsoft Entra ID resources.
Bicep templates for Microsoft Graph resources allow you to define the tenant infrastructure you want to deploy, such as groups or applications, in a file, then use the file throughout the development lifecycle to repeatedly deploy your infrastructure. The file uses the Bicep language, a domain-specific language (DSL), that uses declarative syntax to deploy resources typically used in DevOps and infrastructure-as-code solutions.
What problems does this solve?
Azure Resource Manager or Bicep templates allow you to declare Microsoft Azure resources in files and deploy those resources into your infrastructure. Configuring and managing your Azure services and infrastructure often includes managing Microsoft Entra ID resources, like applications and groups. Until now, you had to orchestrate your deployments between two mechanisms using ARM or Bicep template files for Azure resources and Microsoft Graph PowerShell for Microsoft Entra ID resources.
Now, with the Microsoft Graph Bicep release, you can declare the Microsoft Entra ID resources in the same Bicep files as your Azure resources, making configurations easier to define, and deployments more reliable and repeatable.
Let’s look at how this works and then we’ll run through an example.
The Microsoft Graph Bicep extension
To provide support for Bicep templates for Microsoft Graph resources, we have released the new Microsoft Graph Bicep extension that allows you to author, deploy, and manage supported Microsoft Graph resources (initially Microsoft Entra ID resources) in Bicep template files either on their own, or alongside Azure resources.
Authoring experience
You get the same first-class authoring experience of the Bicep Extension for VS Code when you use it to create your Microsoft Graph resource types in Bicep files. The editor provides rich type-safety, IntelliSense, and syntax validation.
You can also create Bicep files in Visual Studio with the Bicep extension for Visual Studio.
Deploying Bicep files
Once you have authored your Bicep file, you can deploy it using familiar tools such as Azure PowerShell and Azure CLI. When the deployment request is made to the Azure Resource Manager the deployments engine orchestrates the deployment of interdependent resources so they’re created in the correct order, including the Microsoft Graph resources.
The following image shows a Bicep template file where the Microsoft Graph group creation is dependent on the managed identity resource, as it is being added as a group member. The deployments engine first sends the managed identity request to the Resource Manager, which routes it to the Microsoft.ManagedIdentity resource provider. Next, the deployments engine sees that Microsoft.Graph/groups is an extensible resource, so it knows to route this resource request to the Microsoft Graph Bicep extension. The Microsoft Graph Bicep extension then translates the groups resource request into a request to Microsoft Graph.
Scenario: Using managed identities with security groups and app roles
Managed identities can be assigned to security groups and Microsoft Entra ID app roles as an authorization strategy. Using security groups can simplify management by reducing the number of role assignments.
However, this configuration isn’t possible using a Bicep or Resource Manager template. With Microsoft Graph Bicep extension, this limitation is removed. Rather than assigning and managing multiple Microsoft Azure role assignments, role assignments can be managed via a security group through a single Bicep file.
In the example above, a security group can be created and referenced, whose members can be managed identities. With Bicep templates for Microsoft Graph resources, declaring Microsoft Graph and Microsoft Azure resources together in the same Bicep files, enables new and simplifies existing deployment scenarios, bringing reliable and repeatable deployments.
Learn more
Bicep templates for Microsoft Graph resources documentation
Try out the create and deploy your first Bicep file with Microsoft Graph resources quickstart
Microsoft Tech Community – Latest Blogs –Read More
SMS MESSAGES PLUS TEXT PROBLEMS
When i try to send a text message, with Skype it does not work and i have credits in my account can someone help please thanks
When i try to send a text message, with Skype it does not work and i have credits in my account can someone help please thanks Read More
Microsoft power bi not opening
i have Microsoft power bi app installed at my laptop but it is not opening and throwing this below error.
error parsing
c:\windowsMicrosoft.NETFramework64v4.0.30319configmachine.config
parserreturned error 0x80004005
the type initializer for ‘system.net.servicepointManager’ threw an exception
how to resolve it?
i have Microsoft power bi app installed at my laptop but it is not opening and throwing this below error.error parsingc:\windowsMicrosoft.NETFramework64v4.0.30319configmachine.configparserreturned error 0x80004005the type initializer for ‘system.net.servicepointManager’ threw an exceptionhow to resolve it? Read More
Custom Grammar Model?
I’ve been experimenting with using Sharepoint data as the base for Azure AI Search and Co-Pilot studio and so far stuck with chatbot assistants.
I then had an idea which I don’t know if it’s possible – our company has lengthy writing guidelines (things like bullet point formatting, capitalization, etc.). Can I create a custom Co-Pilot model using this information, and then use it within Microsoft Word to suggest corrections as a user creates a document?
Thank you!
I’ve been experimenting with using Sharepoint data as the base for Azure AI Search and Co-Pilot studio and so far stuck with chatbot assistants. I then had an idea which I don’t know if it’s possible – our company has lengthy writing guidelines (things like bullet point formatting, capitalization, etc.). Can I create a custom Co-Pilot model using this information, and then use it within Microsoft Word to suggest corrections as a user creates a document? Thank you! Read More
linking 2 work books
I am trying to link 2 different workbooks. I am trying to link one work book with my equipment labels to my check list of equipment labels. so when I put in a number in my check list it will turn the cell green if the number matches with my equipment labels and turn red if it does not match
I am trying to link 2 different workbooks. I am trying to link one work book with my equipment labels to my check list of equipment labels. so when I put in a number in my check list it will turn the cell green if the number matches with my equipment labels and turn red if it does not match Read More
Policy assignment question
Hi. I have a question about the most efficient way to assign intune security policies for Defender for endpoint. This customer has intune joined Windows 10 devices and also Azure VMs with a combination of Windows Server OSs and Windows 10 workstations they use as SERVERS that are Intune MDE joined.
My question is what’s the best way to handle the assignments for policies. I created two antivirus policies one for workstations and another one for servers. For the the servers, I can’t do dynamic assignment to target server OS only because they also use workstations with Windows 10 as servers. And for the workstations policy I can’t do All Devices or Windows 10 only because of their Windows 10 “servers”.
I was thinking going manually assigned for the servers policy. And for the workstations policy use All Devices but create an exclude group that contains the servers and windows 10 “servers”, but I’m not sure this is the best option. I was also thinking if I should leave the Azure VMs alone, and don’t turn on the MDE tenant option and manage polices with gpo for those.
Any feedback would be much appreciated. TIA
Hi. I have a question about the most efficient way to assign intune security policies for Defender for endpoint. This customer has intune joined Windows 10 devices and also Azure VMs with a combination of Windows Server OSs and Windows 10 workstations they use as SERVERS that are Intune MDE joined. My question is what’s the best way to handle the assignments for policies. I created two antivirus policies one for workstations and another one for servers. For the the servers, I can’t do dynamic assignment to target server OS only because they also use workstations with Windows 10 as servers. And for the workstations policy I can’t do All Devices or Windows 10 only because of their Windows 10 “servers”. I was thinking going manually assigned for the servers policy. And for the workstations policy use All Devices but create an exclude group that contains the servers and windows 10 “servers”, but I’m not sure this is the best option. I was also thinking if I should leave the Azure VMs alone, and don’t turn on the MDE tenant option and manage polices with gpo for those. Any feedback would be much appreciated. TIA Read More
Security review for Microsoft Edge version 125
We are pleased to announce the security review for Microsoft Edge, version 125!
We have reviewed the new settings in Microsoft Edge version 125 and determined that there are no additional security settings that require enforcement. The Microsoft Edge version 117 security baseline continues to be our recommended configuration which can be downloaded from the Microsoft Security Compliance Toolkit.
Microsoft Edge version 125 introduced 4 new computer settings and 4 new user settings. We have included a spreadsheet listing the new settings in the release to make it easier for you to find them.
One thing to note with this release we have added configurable settings for Copilot. Something to consider based on your organizations policy
As a friendly reminder, all available settings for Microsoft Edge are documented here, and all available settings for Microsoft Edge Update are documented here.
Please continue to give us feedback through the Security Baselines Discussion site or this post.
Microsoft Tech Community – Latest Blogs –Read More
Intune Update Ring settings not working as expected, what am I doing wrong?
I am hoping someone here can help me because I can’t seem to figure out what I am doing wrong.
I need to install software updates on a set of Windows PCs on the third Thursday of each month. After the updates have installed, I need the PCs to allow a 7-day grace period before a reboot is enforced. For some reason, even though I specify a 7-day grace period in the deadline settings, these machines keep rebooting the same day the updates install! Can someone please take a look at the settings I am using and tell me what I am doing wrong?
Thanks, and see attached screenshots…
I am hoping someone here can help me because I can’t seem to figure out what I am doing wrong. I need to install software updates on a set of Windows PCs on the third Thursday of each month. After the updates have installed, I need the PCs to allow a 7-day grace period before a reboot is enforced. For some reason, even though I specify a 7-day grace period in the deadline settings, these machines keep rebooting the same day the updates install! Can someone please take a look at the settings I am using and tell me what I am doing wrong?Thanks, and see attached screenshots… Read More
teams deleted new recoedings
Hi,
I teach multiple classes, and record them regularly using Microsoft Teams. Afterward, under the ‘chat’ function in the teams app there is a log of the meeting chat (who entered and exited) as well as the recording. However, now, after the class, the recording for this day is shown but all other recordings for the past weeks where deleted, I went to SharePoint and also there where only the last recording session.
how can i retrieve my recordings. Thanks
Hi, I teach multiple classes, and record them regularly using Microsoft Teams. Afterward, under the ‘chat’ function in the teams app there is a log of the meeting chat (who entered and exited) as well as the recording. However, now, after the class, the recording for this day is shown but all other recordings for the past weeks where deleted, I went to SharePoint and also there where only the last recording session.how can i retrieve my recordings. Thanks Read More
“We just need you to sign in, and then we’ll get you to your meeting” hell
If I never had to use Teams, I’d be a happy user. Unfortunately some companies prefer it for video calling.
So, say, I receive a meeting invite via email. I click it:
and pick “Join on the teams app”. Then this standalone app comes up:
It wants you to log in at the bottom. Mind you I just had this thing open and had already logged in.
OK, I click “Sign in” and then this GIF happens for about 2-3 minutes:
and then eventually this:
Clicking “Sign in” button repeats the cycle.
I’ve seen this error about 6 months ago when I was forced to use teams. So I’m wondering, how many Microsoft engineers does it take to fix this?
If I never had to use Teams, I’d be a happy user. Unfortunately some companies prefer it for video calling. So, say, I receive a meeting invite via email. I click it: and pick “Join on the teams app”. Then this standalone app comes up: It wants you to log in at the bottom. Mind you I just had this thing open and had already logged in. OK, I click “Sign in” and then this GIF happens for about 2-3 minutes: and then eventually this: Clicking “Sign in” button repeats the cycle. I’ve seen this error about 6 months ago when I was forced to use teams. So I’m wondering, how many Microsoft engineers does it take to fix this? Read More
EF Core : foreign key column with same name as existing navigation property
I want to use EF Core to map a legacy database. I cannot scaffold as there are hundreds of tables and I am only interested in very few and besides scaffolding generates names for the navigation properties which are not the ones I want. The situation is: I have a required many-to-one relationship linked by a column name that matches the name of the property that I want to give.
The code (simplified) is:
public class EntityProperty
{
public ControlType ControlType { get; set; }
}
public class ControlType
{
public List<EntityProperty> Properties { get; set; } = new List<EntityProperty>();
}
Nothing more is required, eg, I’m not using foreign key properties, just navigation.
The problem is, the foreign key column from the EntityProperties table to the ControlTypes is also called ControlType.
So, when I try to map it as:
builder.HasOne(x => x.ControlType)
.WithMany(x => x.Properties)
.IsRequired()
.HasForeignKey(“ControlType”);
I want to use EF Core to map a legacy database. I cannot scaffold as there are hundreds of tables and I am only interested in very few. The situation is: I have a required many-to-one relationship linked by a column name that matches the name of the property that I want to give.
The code (simplified) is:
public class EntityProperty
{
public ControlType ControlType { get; set; }
}
public class ControlType
{
public List<EntityProperty> Properties { get; set; } = new List<EntityProperty>();
}
The problem is, the foreign key column from the EntityProperties table to the ControlTypes is also called ControlType.
So, when I try to map it as:
builder.HasOne(x => x.ControlType)
.WithMany(x => x.Properties)
.IsRequired()
.HasForeignKey(“ControlType”);
I get the following exception:
InvalidOperationException: The property or navigation ‘ControlType’ cannot be added to the ‘EntityProperty’ type because a property or navigation with the same name already exists on the ‘EntityProperty’ type.’
The problem is with HasForeignKey, I guess it’s because I am adding a shadow property when a “physical” property already exists, but I what I really mean to say is to use a different column name to link the two entities: what I want is to be able to specify a “not standard” column name for the foreign key, which I am not able to. I do not have a foreign key property, only a navigation property, and I do not want to have one.
I want to use EF Core to map a legacy database. I cannot scaffold as there are hundreds of tables and I am only interested in very few and besides scaffolding generates names for the navigation properties which are not the ones I want. The situation is: I have a required many-to-one relationship linked by a column name that matches the name of the property that I want to give.The code (simplified) is: public class EntityProperty
{
public ControlType ControlType { get; set; }
}
public class ControlType
{
public List<EntityProperty> Properties { get; set; } = new List<EntityProperty>();
}Nothing more is required, eg, I’m not using foreign key properties, just navigation. The problem is, the foreign key column from the EntityProperties table to the ControlTypes is also called ControlType.So, when I try to map it as: builder.HasOne(x => x.ControlType)
.WithMany(x => x.Properties)
.IsRequired()
.HasForeignKey(“ControlType”); I want to use EF Core to map a legacy database. I cannot scaffold as there are hundreds of tables and I am only interested in very few. The situation is: I have a required many-to-one relationship linked by a column name that matches the name of the property that I want to give.The code (simplified) is:public class EntityProperty
{
public ControlType ControlType { get; set; }
}
public class ControlType
{
public List<EntityProperty> Properties { get; set; } = new List<EntityProperty>();
}The problem is, the foreign key column from the EntityProperties table to the ControlTypes is also called ControlType.So, when I try to map it as:builder.HasOne(x => x.ControlType)
.WithMany(x => x.Properties)
.IsRequired()
.HasForeignKey(“ControlType”);I get the following exception: InvalidOperationException: The property or navigation ‘ControlType’ cannot be added to the ‘EntityProperty’ type because a property or navigation with the same name already exists on the ‘EntityProperty’ type.’ The problem is with HasForeignKey, I guess it’s because I am adding a shadow property when a “physical” property already exists, but I what I really mean to say is to use a different column name to link the two entities: what I want is to be able to specify a “not standard” column name for the foreign key, which I am not able to. I do not have a foreign key property, only a navigation property, and I do not want to have one. Read More
Auto Labeling Policy
Currently running into an issue with auto labeling policy. I have created a label specifically to be only applied to about 20 or so users who have access to a confidential file on SharePoint site.
When creating the above policy, I get the following error in the attached screenshot. I do have access to this SharePoint site, and I am a SharePoint admin.
Has anyone run into this issue?
Currently running into an issue with auto labeling policy. I have created a label specifically to be only applied to about 20 or so users who have access to a confidential file on SharePoint site. When creating the above policy, I get the following error in the attached screenshot. I do have access to this SharePoint site, and I am a SharePoint admin. Has anyone run into this issue? Read More
Issue with SharePoint Online List Column Alignment in form body
Hi,
I’m using JSON to format the body of the list form by adding sections, and the issue that I’m experiencing is that the columns are not evenly top aligned when certain columns have long descriptions. As a result, the display of the list columns on the form is not lining up correctly. Is there a way around this?
Please help!
Hi,I’m using JSON to format the body of the list form by adding sections, and the issue that I’m experiencing is that the columns are not evenly top aligned when certain columns have long descriptions. As a result, the display of the list columns on the form is not lining up correctly. Is there a way around this? Please help! Read More
How do I save my screen snips on Windows 11 computer?
When I use the built-in screenshot feature (Windows key + Print Screen) or third-party screenshot tool, I’m able to capture the image I need, but when I try to save it, I’m not sure what file type or format I should use. I’ve tried saving it as a JPEG or PNG, but the image is not what I expected. It’s blurry, pixelated, or loses its original quality.
I’d like to find a way to save my screen snips in a high-quality format that allows me to easily edit and share them. Any suggestions?
Thank you.
When I use the built-in screenshot feature (Windows key + Print Screen) or third-party screenshot tool, I’m able to capture the image I need, but when I try to save it, I’m not sure what file type or format I should use. I’ve tried saving it as a JPEG or PNG, but the image is not what I expected. It’s blurry, pixelated, or loses its original quality. I’d like to find a way to save my screen snips in a high-quality format that allows me to easily edit and share them. Any suggestions?Thank you. Read More