Category: Microsoft
Category Archives: Microsoft
How do I add or sum until?
If my input is 20, I want to add back up a column sequential until I’ve reached >=20
Examples, if the column is
– 5, 10, & 12, I need 100% of the 5, 100% of the 10 & only 41.66% of the 12
– 10 & 10, I need 100% of each 10
– 5, 5, 5, 10, I need 100% of each 5 and 50% of the 10
I have looked at a nested if but it started to get complicated and difficult to read and debug.
Is there a good way to tackle this problem?
Thank you for your help.
If my input is 20, I want to add back up a column sequential until I’ve reached >=20Examples, if the column is – 5, 10, & 12, I need 100% of the 5, 100% of the 10 & only 41.66% of the 12- 10 & 10, I need 100% of each 10- 5, 5, 5, 10, I need 100% of each 5 and 50% of the 10I have looked at a nested if but it started to get complicated and difficult to read and debug.Is there a good way to tackle this problem?Thank you for your help. Read More
Add users in Bulk in a Teams Tags
Hi Guys,
Need your help in adding 180 members in a Teams tag in bulk.
I have 199 users in bulk in Teams Tags via Power Automate but for this next batch getting error that you have exceed daily limit. Kindly suggest, how can I add members in a Teams tags.
Hi Guys, Need your help in adding 180 members in a Teams tag in bulk. I have 199 users in bulk in Teams Tags via Power Automate but for this next batch getting error that you have exceed daily limit. Kindly suggest, how can I add members in a Teams tags. Read More
Custom Copilot and Atlassian integeration
Hi friends, please how can I create a custom copilot that connect to Atlassian Jira and Confluence as the data source ?
Hi friends, please how can I create a custom copilot that connect to Atlassian Jira and Confluence as the data source ? Read More
Cisco Meraki switch logs to Sentinel via AMA agent
As OMS agents are going to be expired. Do you have any KB or blogs which has steps to ingest Cisco meraki switch logs to sentinel via Linux server but with AMA agents installed.
As OMS agents are going to be expired. Do you have any KB or blogs which has steps to ingest Cisco meraki switch logs to sentinel via Linux server but with AMA agents installed. Read More
2024 June Cumulative Updates for Insiders
June 11, 2024—KB5039213 (OS Build 22000.3019) – Microsoft Support
This update addresses security issues for your Windows operating system.
This update affects Server Message Block (SMB) over Quick UDP Internet Connections (QUIC). It turns on the SMB over QUIC client certificate authentication feature. Admins can use it to restrict which clients can access SMB over QUIC servers.
June 11, 2024—KB5039213 (OS Build 22000.3019) – Microsoft Support This update addresses security issues for your Windows operating system. This update affects Server Message Block (SMB) over Quick UDP Internet Connections (QUIC). It turns on the SMB over QUIC client certificate authentication feature. Admins can use it to restrict which clients can access SMB over QUIC servers. Read More
Copy data from one sheet to another sheet
Hello everyone,
Previously my formula was working –
=CHOOSECOLS(FILTER(‘HL Final Progress Sheet’!$A$2:$O$998, (‘HL Final Progress Sheet’!$I$2:$I$998=”Ready To Ship”)+(‘HL Final Progress Sheet’!$I$2:$I$998=”Ready for P/U”), “”), 10, 9, 2, 11, 12, 13, 14, 15)
And now there is a requirement to add another column from HL Final Progress Sheet to Driver Work Board, so I change in the above formula –
=CHOOSECOLS(FILTER(‘HL Final Progress Sheet’!$A$2:$O$998, (‘HL Final Progress Sheet’!$I$2:$I$998=”Ready To Ship”)+(‘HL Final Progress Sheet’!$I$2:$I$998=”Ready for P/U”), “”), 10, 9, 1, 2, 11, 12, 13, 14, 15)
How to make it work(my sheet messed up after adding this new change.)
Hello everyone, Previously my formula was working – =CHOOSECOLS(FILTER(‘HL Final Progress Sheet’!$A$2:$O$998, (‘HL Final Progress Sheet’!$I$2:$I$998=”Ready To Ship”)+(‘HL Final Progress Sheet’!$I$2:$I$998=”Ready for P/U”), “”), 10, 9, 2, 11, 12, 13, 14, 15) And now there is a requirement to add another column from HL Final Progress Sheet to Driver Work Board, so I change in the above formula – =CHOOSECOLS(FILTER(‘HL Final Progress Sheet’!$A$2:$O$998, (‘HL Final Progress Sheet’!$I$2:$I$998=”Ready To Ship”)+(‘HL Final Progress Sheet’!$I$2:$I$998=”Ready for P/U”), “”), 10, 9, 1, 2, 11, 12, 13, 14, 15) How to make it work(my sheet messed up after adding this new change.) Read More
How to view the photos on my phone via Quick Access menu from Windows 11 left sidebar?
This feature doesn’t seem to be available when a Samsung Phone is connected. Any suggestions?
This feature doesn’t seem to be available when a Samsung Phone is connected. Any suggestions? Read More
Chart Series Label Format Issue
I have a chart with 1 series. I set the labels to have a format of 0.00%. When I run the preview or run the report, the output acts like the “.00” is a literal string to add to the number.
So, it displays “18.00%” instead of “18.31%”, for example.
Is this a bug, or do I have my format string wrong?
Thanks,
Gregg
I have a chart with 1 series. I set the labels to have a format of 0.00%. When I run the preview or run the report, the output acts like the “.00” is a literal string to add to the number. So, it displays “18.00%” instead of “18.31%”, for example. Is this a bug, or do I have my format string wrong? Thanks,Gregg Read More
Azure Modeling and Simulation Workbench Alliance enables innovation for semiconductor design
Earlier this year, Microsoft announced the public preview of the Azure Modeling and Simulation Workbench (Azure MSWB), a groundbreaking service on the Azure Cloud built to revolutionize collaborative development in semiconductor design. This new service leverages the performance, scalability and elasticity of Azure Compute and Azure NetApp Files along with decades of semiconductor experience from both Microsoft and its partners. Azure MSWB enables customers to easily and quickly deploy secure chambers, enabling collaboration scenarios ranging from joint debug, co-development and complex multi-vendor design flows.
Azure MSWB is production proven, creating the foundation of the secure cloud platform for the Department of Defense’s Rapid Assured Microelectronics Prototyping (RAMP) Program. Azure MSWB’s performance demonstrated the robustness and capabilities necessary for the DoD’s contractors to develop leading edge Microelectronics solutions using commercial tools while providing the required level of security and compliance for defense programs. To enable this transformation for the department of defense, Microsoft worked with their partners in the semiconductor industry to jointly develop the RAMP platform capability for the microelectronics community to successfully tape-out silicon programs. This partnership approach ensured that this new solution addressed the real-world requirements of advanced node semiconductor design.
To bring these capabilities to the broader semiconductor industry and help customers unlock the benefits of secure collaborative computing on the cloud, today, Microsoft is launching the Azure Modeling and Simulation Workbench Alliance Program. This program brings the key industry partners together and enables a robust ecosystem around Azure MSWB, facilitating an easily deployable partner-approved design environment where designers can not only create semiconductor products but also collaborate securely with their EDA vendors, IP providers, foundry partners, and design services providers.
Microsoft is proud to announce Cadence, Intel, NetApp, Siemens, and Synopsys as the initial members of the Azure Modeling and Simulation Workbench (Azure MSWB) Alliance Program. We look forward to collaborating with our Alliance Program members to enable their solutions on MSWB, and ensuring our customers have seamless access to support from both Microsoft and their tool/IP vendors. This collaboration is set to streamline the design process, reduce adoption barriers, enhance security, and foster innovation in the semiconductor industry.
Join us at the 61st Design Automation Conference in San Francisco, CA on June 24-26. At this event, you will have the opportunity to learn more about the alliance program as well as Azure MSWB, a powerful tool that will revolutionize the way we approach design and automation. We have a team ready to meet with you (request a 1:1 meeting here) and we also have an exciting lineup of presentations by our team as well as our Alliance members and partners, including a not-to-be-missed hands-on tutorial on Azure MSWB. We hope to see you there and we look forward to sharing this exciting development with you in person, however if you aren’t able to make the event, you can always sign up to stay up to date on our latest news and announcements here or request a virtual meeting here.
Exhibitor Forum, Level 1 Exhibit Hall
Monday, June 24, 10:30AM-11AM PDT
Secure Collaboration Across Enterprises on the Cloud
Prashant Varshney, Head of Product, Silicon Industry, Strategic Missions and Technologies, Microsoft
Azure Modeling and Simulation Hands-on Training, Level 2 Lobby
Tuesday, June 25, 10:15AM-1:15PM PDT
Setting Up a Secure, Turn-Key Cloud-Based Engineering Environment for Semiconductor Development, Collaboration and Debug with Azure Modeling and Simulation Workbench
Prashant Varshney, Head of Product, Silicon Industry, Strategic Missions and Technologies, Microsoft
Preetish Sinha, Silicon Industry, Strategic Missions and Technologies, Microsoft
Joe Tostenrude, Silicon Industry, Strategic Missions and Technologies, Microsoft
DAC Booth schedule
Monday
11:00AM
Optimizing Chip Design with Siemens EDA Cloud Solutions and Microsoft Azure
1:00PM
Soar to New Productivity Heights with Cloud
2:00PM
Synopsys Cloud and Azure: Unleashing the Power of AI and Cloud to Accelerate Your Chip Design
3:00PM
EDA in the Azure Cloud with NetApp
4:00PM
Secure Collaboration in Semiconductor Design
Tuesday
10:15AM
Is the Untapped Power of IP-driven methodologies in Azure your secret to a Competitive Advantage?
11:00AM
EDA in the Azure Cloud with NetApp
1:00PM
Secure Collaboration in Semiconductor Design
2:00PM
Ansys Semiconductor Products on Microsoft Azure
3:00PM
Intel Foundry and Microsoft Azure – Systems Foundry for the AI Era
4:00PM
Simulation Compute Optimization Across Cost, Time-To-Market, and Emissions
Wednesday
10:15AM
Secure Collaboration in Semiconductor Design
Microsoft Tech Community – Latest Blogs –Read More
Boost engagement with Copilot in Forms
We have been continuously enhancing Copilot’s capabilities over the past few months, focusing on everything from form creation to distribution, to make it your ultimate form creation assistant. This June, we enabled more capabilities for distributing forms, helping you boost audience engagement and increase response rates. Let’s explore the new capabilities together!
Rewrite the invitation message with Copilot
The invitation message is the first thing responders see when they receive a form. Crafting a compelling message is key to grabbing their attention and prompting a quick response. When your form is ready to go, Copilot will help you rewrite the default message, adding details like the form’s topic, estimated completion time, and due date.
Respondents will receive an email invitation in Outlook or a Teams message with the customized message. They can begin filling out the form by clicking “Start now”.
Follow up with non-responders
If you send out the form and don’t receive enough responses after some time, Copilot can help you draft reminder messages to prompt respondents to reply. It offers several options, allowing you to choose your favorite and send it with just one click.
Respondents will receive a nudge email with the personalized message in their inbox. With just one click, they can start filling out the form.
Please note that a Copilot for Microsoft 365 license is required to access Copilot in Forms. Discover more about Copilot for Microsoft 365 here.
Microsoft Tech Community – Latest Blogs –Read More
Teams Owners/Members from different Domains
Our team is made up of different people with different email addresses off of different domains. We have some members who we have added with different domains who we have been able to elevate from Guest to Owner/Member but some of the others we have not. I have checked the external settings in the admin panel and have access granted to all external domains. I have even tried specifically listing the domains but that also did not work. An example of the domains:
theamericanrealty.com (primary domain)
areuclasses.com (different domain but we are allowed to elevate to owner/member)
arpartners.us (different domain that will ONLY allow to be set as GUEST)
theamericanmortgagepartners.com (different domain but we are allowed to elevate to owner/member)
Any suggestions would be greatly appreciated.
I am using the online and desktop versions of teams and all of our domains and Microsoft accounts are handled through GoDaddy.
Our team is made up of different people with different email addresses off of different domains. We have some members who we have added with different domains who we have been able to elevate from Guest to Owner/Member but some of the others we have not. I have checked the external settings in the admin panel and have access granted to all external domains. I have even tried specifically listing the domains but that also did not work. An example of the domains: theamericanrealty.com (primary domain) areuclasses.com (different domain but we are allowed to elevate to owner/member)arpartners.us (different domain that will ONLY allow to be set as GUEST)theamericanmortgagepartners.com (different domain but we are allowed to elevate to owner/member) Any suggestions would be greatly appreciated. I am using the online and desktop versions of teams and all of our domains and Microsoft accounts are handled through GoDaddy. Read More
What do I need to hire in the MS Purview so that I also receive this confidentiality name Alex Revie
What do I need to hire in MS Purview to help this confidentiality name Alex Reviewit – Confidential: This content is proprietary information intended for internal users only. This content can be modified but cannot be copied and printed. Receive
What do I need to hire in MS Purview to help this confidentiality name Alex Reviewit – Confidential: This content is proprietary information intended for internal users only. This content can be modified but cannot be copied and printed. Receive Read More
SQLServer connection problem
Hi,
I made a program in c# .NET8.0 using EntityFrameworkCore to connect to an SQL Server. Everything work fines as long as I run the program from Visual Studio. Once compile and install on the computer (same computer I develop the program in VS) it won’t connect to the server.
I have added this code on a button to test the connection:
try
{
string? str = dbCtxt.Database.ProviderName;
bool cnx = dbCtxt.Database.CanConnect();
MessageBox.Show(“Provider: ” + str + “rnCan connect? ” + cnx, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.OpenConnection();
MessageBox.Show(“Connection opened”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.CloseConnection();
}
catch (Microsoft.Data.SqlClient.SqlException ex)
{
MessageBox.Show($”Microsoft.Data.SqlClient.SqlException occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
}
catch (DbUpdateException ex)
{
// Handle specific database update exception
MessageBox.Show($”DbUpdateException occurred: {ex.Message}”);
}
catch (DbException ex)
{
// Handle any other database exception
MessageBox.Show($”DbException occurred: {ex.Message}”);
}
catch (Exception ex)
{
// Catch any other exceptions
MessageBox.Show($”Exception occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
tbError.Text = ex.StackTrace;
}
finally
{
//Here just to make sure it passes through this point…
MessageBox.Show(“Finally”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
}
and I get this error message.
(Stack trace)
at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.<>c.<OpenConnection>b__22_0(DatabaseFacade database)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.<Execute>b__0(DbContext _, TState s)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.OpenConnection(DatabaseFacade databaseFacade)
at ****.frmMainMenu.btnFicheEmpAnnuel_Click(Object sender, RoutedEventArgs e) in C:Users….frmMainMenu.xaml.cs:line 99
I have tried multiple things, like changing the TargetPlatform from AnyCPU to x64, changing the Target OS Version, installing/deinstalling NuGET Microsoft.Data.SQLClient 5.2.1 … nothing works.
Anyone got a similar problem and solve it?
Regards
Hi,I made a program in c# .NET8.0 using EntityFrameworkCore to connect to an SQL Server. Everything work fines as long as I run the program from Visual Studio. Once compile and install on the computer (same computer I develop the program in VS) it won’t connect to the server.I have added this code on a button to test the connection: try
{
string? str = dbCtxt.Database.ProviderName;
bool cnx = dbCtxt.Database.CanConnect();
MessageBox.Show(“Provider: ” + str + “rnCan connect? ” + cnx, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.OpenConnection();
MessageBox.Show(“Connection opened”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.CloseConnection();
}
catch (Microsoft.Data.SqlClient.SqlException ex)
{
MessageBox.Show($”Microsoft.Data.SqlClient.SqlException occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
}
catch (DbUpdateException ex)
{
// Handle specific database update exception
MessageBox.Show($”DbUpdateException occurred: {ex.Message}”);
}
catch (DbException ex)
{
// Handle any other database exception
MessageBox.Show($”DbException occurred: {ex.Message}”);
}
catch (Exception ex)
{
// Catch any other exceptions
MessageBox.Show($”Exception occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
tbError.Text = ex.StackTrace;
}
finally
{
//Here just to make sure it passes through this point…
MessageBox.Show(“Finally”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
} and I get this error message.(Stack trace)at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.<>c.<OpenConnection>b__22_0(DatabaseFacade database)at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.<Execute>b__0(DbContext _, TState s)at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.OpenConnection(DatabaseFacade databaseFacade)at ****.frmMainMenu.btnFicheEmpAnnuel_Click(Object sender, RoutedEventArgs e) in C:Users….frmMainMenu.xaml.cs:line 99 I have tried multiple things, like changing the TargetPlatform from AnyCPU to x64, changing the Target OS Version, installing/deinstalling NuGET Microsoft.Data.SQLClient 5.2.1 … nothing works. Anyone got a similar problem and solve it?Regards Read More
What do I need to hire in MS Purview to make this confidentiality name Confidential View Only: This
What do I need to hire in MS Purview to make this confidentiality name Confidential View Only: This content is proprietary information intended for internal users only. This content cannot be modified. Receive
What do I need to hire in MS Purview to make this confidentiality name Confidential View Only: This content is proprietary information intended for internal users only. This content cannot be modified. Receive Read More
Two Taskbars resolution issue
I am getting two taskbars showing up on my monitor, but the screen edge stops before the edge of my screen, im also getting two mice cursors.
I am getting two taskbars showing up on my monitor, but the screen edge stops before the edge of my screen, im also getting two mice cursors. Read More
Soon no profile pictures in SPO User Profile Service anymore?
Anyone seen this yet?
We have Intranet solutions that use the LocalPeopleResults result source for search in combination with the classic user profile pictures hosted on https://[tenant]-my.sharepoint.com/User%20Photos.
Couldn’t find anything regarding this in the M365 Admin Center message feed, unfortunately.
Does anybody know how to handle this in the future?
Anyone seen this yet?We have Intranet solutions that use the LocalPeopleResults result source for search in combination with the classic user profile pictures hosted on https://[tenant]-my.sharepoint.com/User%20Photos.Couldn’t find anything regarding this in the M365 Admin Center message feed, unfortunately.Does anybody know how to handle this in the future? Read More
Copilot for Microsoft 365 – Restricting SharePoint Search
How can I restrict Copilot from using SharePoint search? Is there an option to disable?
How can I restrict Copilot from using SharePoint search? Is there an option to disable? Read More
request help adding an Excel condition
There are formulas in cells B, C, and D. I want the answer to be a blank when both B and C are blank. Currently the answer is #DIV/0!.
=IF(C7>0,D7/C7,D7/B7)
There are formulas in cells B, C, and D. I want the answer to be a blank when both B and C are blank. Currently the answer is #DIV/0!. =IF(C7>0,D7/C7,D7/B7) Read More
Help with best practices for how to protect formulas on table and still expand with new records?
I have several tables, one on each worksheet, that need to be able to expand whenever a user types in a new record (formulas/drop-downs copied to new records).
Apparently, Excel doesn’t allow protecting the worksheet while also allowing the table to expand as needed. Can anyone suggest the best way to protect the formulas in certain cells from being accidentally overwritten by users when they enter a new record? Again, the table must be able to expand. The only thing I can think of would be to use a set number of records on each table which already contain the cells needing protection, but that comes with its own issues. Any help is appreciated.
I’m using Excel 365. Developing the workbook in the desktop app and then posting to the Internet on a shared drive for users to access and enter data. I can’t use VBA or Macros for security reasons.
I have several tables, one on each worksheet, that need to be able to expand whenever a user types in a new record (formulas/drop-downs copied to new records). Apparently, Excel doesn’t allow protecting the worksheet while also allowing the table to expand as needed. Can anyone suggest the best way to protect the formulas in certain cells from being accidentally overwritten by users when they enter a new record? Again, the table must be able to expand. The only thing I can think of would be to use a set number of records on each table which already contain the cells needing protection, but that comes with its own issues. Any help is appreciated. I’m using Excel 365. Developing the workbook in the desktop app and then posting to the Internet on a shared drive for users to access and enter data. I can’t use VBA or Macros for security reasons. Read More
Passing form data that is defined in combobox defaultselecteditems
I have created a form that is connected to a Sharepoint list called: “Win”
The Sharepoint list holds a.o. a multiselect column called ‘Solution Category’
I have a multiselect combobox (cmbSolCat_1) that is part of this form.
– The combobox items list gets its data from an single column excel table called SolutionCat
– The headername of the table is called ‘Customer Solution’
The defaultselecteditems property of this combobox is defined as: ThisItem.’Solution Category’
– The datacard Update property is: ForAll(cmbSolCat_1.SelectedItems, {Value:’Customer Solution’})
All of the above works well if I select some of the items in the multiselect combobox.
If I would edit an existing entry, with multiple items selected, it would show me those items. If I now would submit my form with no changes, it will not pass the items that were listed from the defaultselected property. Instead, it will blank out all everything in that cell of the sharepoint list.
Appreciate your insight on how to pass on defaultselecteditems in a multiselect combobox.
I have created a form that is connected to a Sharepoint list called: “Win”The Sharepoint list holds a.o. a multiselect column called ‘Solution Category’ I have a multiselect combobox (cmbSolCat_1) that is part of this form.- The combobox items list gets its data from an single column excel table called SolutionCat- The headername of the table is called ‘Customer Solution’The defaultselecteditems property of this combobox is defined as: ThisItem.’Solution Category’- The datacard Update property is: ForAll(cmbSolCat_1.SelectedItems, {Value:’Customer Solution’}) All of the above works well if I select some of the items in the multiselect combobox. If I would edit an existing entry, with multiple items selected, it would show me those items. If I now would submit my form with no changes, it will not pass the items that were listed from the defaultselected property. Instead, it will blank out all everything in that cell of the sharepoint list. Appreciate your insight on how to pass on defaultselecteditems in a multiselect combobox. Read More