Category: Microsoft
Category Archives: Microsoft
Summing all previous numbers with criteria
Hi again,
Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. Tried using TAKE function
Ex
2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-09
50 100 30 75 90
Output all summed previous numbers as a horizontal spilled range that are equal to 2024-11-18
Output:
2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-09
50 n/a n/a 125 n/a
If it could also display n/a or 0 as a value that would be great (e.g changeable between both). Thanks
Hi again, Looking to sum all previous numbers based on criteria. Need output to be a horizontal spilled range.. Example below. Tried using TAKE function Ex2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-0950 100 30 75 90 Output all summed previous numbers as a horizontal spilled range that are equal to 2024-11-18Output:2024-11-18 2024-05-12 2024-10-09 2024-11-18 2024-10-0950 n/a n/a 125 n/a If it could also display n/a or 0 as a value that would be great (e.g changeable between both). Thanks Read More
Virtual Appointment
When you schedule a meeting using virtual appointment meeting type, it only allows 8 external guests to be invited. Is there a way to add more without just forwarding them the invite after? Does it affect the meeting at all if more than 8 external participants show up?
When you schedule a meeting using virtual appointment meeting type, it only allows 8 external guests to be invited. Is there a way to add more without just forwarding them the invite after? Does it affect the meeting at all if more than 8 external participants show up? Read More
Show Last Record
Hello experts,
I need to show the last record in another column of this data set based on 2 criteria.
The criteria is I need to show the last record of [MTM] based on the MAX of [Valuation Date] but based on a grouping of [Trade Ref #].
I have attached the file with some comments of what I need.
Let me know if its not clear.
thank you very much.
Hello experts, I need to show the last record in another column of this data set based on 2 criteria.The criteria is I need to show the last record of [MTM] based on the MAX of [Valuation Date] but based on a grouping of [Trade Ref #]. I have attached the file with some comments of what I need. Let me know if its not clear. thank you very much. Read More
How to start an Azure User Group
Hey there!
May I know how can I start a Microsoft Tech Community in my region or Azure User Group?
A guide will be appreciated.
Hey there! May I know how can I start a Microsoft Tech Community in my region or Azure User Group? A guide will be appreciated. Read More
Issue with “Edit with Paint 3D” Functionality
I have recently encountered an issue with Paint 3D. When I try to edit a picture using Paint 3D by right-clicking on the photo and selecting “Edit with Paint 3D,” I am unexpectedly prompted to choose an app to open the file instead of Paint 3D launching directly.
Has anyone else experienced this problem, or does anyone have any insights on why this might be happening and how to resolve it?
Thank you for your assistance!
I have recently encountered an issue with Paint 3D. When I try to edit a picture using Paint 3D by right-clicking on the photo and selecting “Edit with Paint 3D,” I am unexpectedly prompted to choose an app to open the file instead of Paint 3D launching directly.Has anyone else experienced this problem, or does anyone have any insights on why this might be happening and how to resolve it?Thank you for your assistance! Read More
SharePoint Online – Large List | REST API Issue
Hi,
I have a list which has around 28K items. We have a dashboard displaying data from this list. By default, we are fetching data for the past 120 days, and it perfectly worked fine.
Today, we have around 13K items created on the same list by mistake. Now the dashboard is not working and it is giving this error “The attempted operation is prohibited because it exceeds the list view threshold”.
The following steps are taken as of now.
deleted 13k items from the process listdeleted from the recycle bin ( primary and secondary)
I’m still facing the same error.
Can you please let me know if anyone has come across this kind of issue & let me know any solution?
Thanks in advance.
Hi, I have a list which has around 28K items. We have a dashboard displaying data from this list. By default, we are fetching data for the past 120 days, and it perfectly worked fine. Today, we have around 13K items created on the same list by mistake. Now the dashboard is not working and it is giving this error “The attempted operation is prohibited because it exceeds the list view threshold”. The following steps are taken as of now.deleted 13k items from the process listdeleted from the recycle bin ( primary and secondary)I’m still facing the same error. Can you please let me know if anyone has come across this kind of issue & let me know any solution? Thanks in advance. Read More
Upcoming Event in Dallas & Virtual: Copilot, Your Everyday AI Companion, June 27
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – Hybrid
You’re invited to join us in-person or virtually!
IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are!
Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas!
Join us online or in-person (lunch included) in Dallas at the Microsoft office –
7000 State Highway 161
Irving, TX 75039
11:30am-1:00pm CST
Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days!
I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities.
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – HybridYou’re invited to join us in-person or virtually! IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are! Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas! Join us online or in-person (lunch included) in Dallas at the Microsoft office – 7000 State Highway 161Irving, TX 7503911:30am-1:00pm CST Register Here > Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days! I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities. Read More
Index Match to get Avg. price of a period
Hello All,
Hope you are doing well.
May I ask for a little help from you, actually I have daywise sales units in upper table of the attached sheet and price per unit in the second table, there is a dropdown in cell AH2 & AI2 where units sold appears in within a date range.
Pls help me to get the avg. price of that units sold of the same date range in column AJ row no 12 to 17.
Requesting you to pls help me in this, will wait for your reply.
Thanks & Regards,
Subhasis
Hello All, Hope you are doing well.May I ask for a little help from you, actually I have daywise sales units in upper table of the attached sheet and price per unit in the second table, there is a dropdown in cell AH2 & AI2 where units sold appears in within a date range.Pls help me to get the avg. price of that units sold of the same date range in column AJ row no 12 to 17.Requesting you to pls help me in this, will wait for your reply. Thanks & Regards,Subhasis Read More
Dallas IAMCP Chapter Meeting – Copilot & AI, June 27 HYBRID!
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – Hybrid
You’re invited to join us in-person or virtually!
IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are!
Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas!
Join us online or in-person (lunch included) in Dallas at the Microsoft office –
7000 State Highway 161
Irving, TX 75039
11:30am-1:00pm CST
Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days!
I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities.
Dallas IAMCP Chapter Meeting, “Your everyday AI companion” June 27 – HybridYou’re invited to join us in-person or virtually! IAMCP (International Association of Microsoft Channel Partners) TOLA Chapter (Texas, Oklahoma, Louisiana, Arkansas) rotates monthly and hosts chapter meetings in Austin, Houston and Dallas. All meetings are hybrid and anyone is welcome to attend, no matter where you are! Our June meeting will continue the conversation last month in Austin, about Copilot for Microsoft 365. Have you been using Copilot & AI? How has it impacted your business since then? How have your clients responded? Let’s dig in and share ideas! Join us online or in-person (lunch included) in Dallas at the Microsoft office – 7000 State Highway 161Irving, TX 7503911:30am-1:00pm CST Register Here > Not a member of IAMCP? You can attend for $30 or, as a new member, join for $1 for your first 90 days! I myself have been a member of IAMCP for about 2+ years and I’m the Secretary of the Houston chapter. There are plenty of other virtual meetings every month covering all topics concerning partners. It’s a great way to understand the ecosystem, how to gain designations and credentials, and find partner to partner opportunities. Read More
How to perform unattended uninstall for SQL Server Express
Recently, I received a question about unattended uninstall for SQL Server Express edition. This article describes how to perform this task.
We need to take in consideration before to proceed
User that performs the process must be a local administrator with permissions to log on as a service. You can review more information about required permissions here.
If the machine has the minimum required amount of physical memory, increase the size of the page file to two times the amount of physical memory. Insufficient virtual memory can result in an incomplete removal of SQL Server.
On a system with multiple instances of SQL Server, the SQL Server browser service is uninstalled only once the last instance of SQL Server is removed. The SQL Server Browser service can be removed manually from Programs and Features in the Control Panel.
Uninstalling SQL Server deletes tempdb data files that were added during the install process. Files with tempdb_mssql_*.ndf name pattern are deleted if they exist in the system database directory.
Backup your databases.
Uninstall process
Open Command Prompt with admin rights
Navigate to the below directory
C:Program FilesMicrosoft SQL Server160Setup BootstrapMyInstanceName
Please note that 160 version is the major build version of SQL Server.
C:>cd C:Program FilesMicrosoft SQL Server160Setup BootstrapSQL2022
Run the below command
C:Program FilesMicrosoft SQL Server160Setup BootstrapSQL2022>setup.exe /Q /ACTION=uninstall /INSTANCENAME=SQLEXPRESS /FEATURES=SQLENGINE
For more information on uninstall options, see
Hope this helps!
Idalia – SQL Server CSS
Microsoft Tech Community – Latest Blogs –Read More
Azure Sphere version 24.06 is now available
Azure Sphere OS version 24.06 is now available in the Retail feed. This release includes a bug fix in the Azure Sphere OS only; it does not include an updated SDK. If your devices are connected to the internet, they will receive the updated OS from the cloud.
Fixed bugs and common vulnerabilities in the 24.06 release
The 24.06 release includes updates to mitigate against the following Common Vulnerabilities and Exposure (CVE):
CVE-2023-52160
For self-help technical inquiries, please visit Microsoft Q&A or Stack Overflow. If you require technical support and have a support plan, please submit a support ticket in Microsoft Azure Support or work with your Microsoft Technical Account Manager. If you would like to purchase a support plan, please explore the Azure support plans.
Microsoft Tech Community – Latest Blogs –Read More
Sharepoint user profile no longer pops up on user columns in lists
Our Employee Directory is a SharePoint list in gallery format with some custom JSON formatting. After our tenant has switched to the new List format (with the views tabbed across the top) our “person” column no longer shows the Sharepoint user profile card (attached a screenshot of it, in case I am calling it the wrong thing)… which is where all of the contact information is. The SharePoint user profile cards pop up fine on the “person” web parts used in page content.
I’ve tried resetting to the default view in case something changed related to my JSON… and tried another list on a different site on the same tenant… but that doesn’t help either.
Is anyone else having this problem? Anyone know how to fix it?
Our Employee Directory is a SharePoint list in gallery format with some custom JSON formatting. After our tenant has switched to the new List format (with the views tabbed across the top) our “person” column no longer shows the Sharepoint user profile card (attached a screenshot of it, in case I am calling it the wrong thing)… which is where all of the contact information is. The SharePoint user profile cards pop up fine on the “person” web parts used in page content. I’ve tried resetting to the default view in case something changed related to my JSON… and tried another list on a different site on the same tenant… but that doesn’t help either. Is anyone else having this problem? Anyone know how to fix it? Read More
Exchange Room Resource Name Change
We have Room resources on Exchange online which were migrated from on-premise exchange server, last year we completely migrated the on-premise exchange to EXO, now when we had to change the names of these room resources due to some relocations of the meeting rooms, we had to rename it from the on-premise ad since it is syncd.
I have just renamed the AD object property(display name, SMTP etc), and once it is syncd via AAD, now could see the new name from the EXO but when we use Get-Mailbox -Identity via Exchange online powershell its still showing up the old name, is there any other on-premise ad attribute which needs to be changed?
We have Room resources on Exchange online which were migrated from on-premise exchange server, last year we completely migrated the on-premise exchange to EXO, now when we had to change the names of these room resources due to some relocations of the meeting rooms, we had to rename it from the on-premise ad since it is syncd.I have just renamed the AD object property(display name, SMTP etc), and once it is syncd via AAD, now could see the new name from the EXO but when we use Get-Mailbox -Identity via Exchange online powershell its still showing up the old name, is there any other on-premise ad attribute which needs to be changed? Read More
Intune deletes some native apps like camera on enroll
Dear experts.
Can anyone help with, why Intune deletes some native apps like Camera, when I enroll the android phone?
It does not happen on Samsung but yes in Umidigi, and not in all models.
I would like to avoid it or be able to choose which apps delete and which no.
Thanks in advance.
Dear experts.Can anyone help with, why Intune deletes some native apps like Camera, when I enroll the android phone?It does not happen on Samsung but yes in Umidigi, and not in all models.I would like to avoid it or be able to choose which apps delete and which no.Thanks in advance. Read More
KB5038575 Bluescreen of Death after restart
When installing KB5038575 last week, I get the bluescreen of death after restart. The only way to boot my device again is to go into Windows Safe Mode->Advanced options->Uninstall Updates. Tried to install this KB 3x and same issue. See screenshots below.
Anyone have this same issue or is my device special? 😀
When installing KB5038575 last week, I get the bluescreen of death after restart. The only way to boot my device again is to go into Windows Safe Mode->Advanced options->Uninstall Updates. Tried to install this KB 3x and same issue. See screenshots below. Anyone have this same issue or is my device special? 😀 Read More
Win32 App Not Showing in Company Portal for Entra-Registered Devices Managed by Intune
Most of our firm uses corporate-owned, entra-joined devices managed by Intune. Win32 apps show up in the company portal app list just fine, but we have a couple of BYOD devices set up as Entra-Registered. Those devices only show the Office App in the store and none of our Win32 apps.
I have already examined the IME logs and saw nothing of note. From everything I see online, it appears that deploying Win32 apps to Entra-Registered devices should be possible so long as they are enrolled in Intune.
Most of our firm uses corporate-owned, entra-joined devices managed by Intune. Win32 apps show up in the company portal app list just fine, but we have a couple of BYOD devices set up as Entra-Registered. Those devices only show the Office App in the store and none of our Win32 apps. I have already examined the IME logs and saw nothing of note. From everything I see online, it appears that deploying Win32 apps to Entra-Registered devices should be possible so long as they are enrolled in Intune. Read More
Access 365 Table Attachment Entry Keeps Disappearing
Hi
I have a local Company table that contains one attachment column called Logo.
Initially I setup the Logo Image directly in the table using the Attachment Management feature of Access.
So far so good.
On the Company form the Logo field displays correctly.
But when I click on the Company table the attachment is showing paperclip(0) ?
The Attachment Management feature of Access no longer works for the table?
If I try to access the Logo on a different for it cannot find it?
Originally the Company table was in my Backend database and because of this I took the Company table out of the Backend Database and created a local Company Table.
Did not resolve my problem.
I get the impression that Access 365 does not work with attachments.
Regards
Melvyn Shepherd
HiI have a local Company table that contains one attachment column called Logo.Initially I setup the Logo Image directly in the table using the Attachment Management feature of Access.So far so good.On the Company form the Logo field displays correctly.But when I click on the Company table the attachment is showing paperclip(0) ?The Attachment Management feature of Access no longer works for the table?If I try to access the Logo on a different for it cannot find it?Originally the Company table was in my Backend database and because of this I took the Company table out of the Backend Database and created a local Company Table.Did not resolve my problem.I get the impression that Access 365 does not work with attachments.RegardsMelvyn Shepherd Read More
building charts
I’m trying to build a chart from data that will be updated monthly. Is there any way to build it so that the chart will automatically update when I update/add data?
I’m trying to build a chart from data that will be updated monthly. Is there any way to build it so that the chart will automatically update when I update/add data? Read More
Discover Free Software Resources for Enhanced Learning on Microsoft Learn
Hello, Microsoft Learn Community,
As many of us are diving deep into Microsoft technologies and expanding our skills, having access to the right tools and software can significantly enhance our learning experience. I wanted to share a resource that I found incredibly useful.
I’ve come across a website that offers a variety of software tools available for free download. These tools can be particularly beneficial for those of us involved in studying and practicing various Microsoft technologies, such as Azure, Microsoft 365, and other development tools.
Crackeialivre provides:
Development Tools: Access to IDEs, code editors, and other development resources.Productivity Software: Tools to improve workflow and project management.Educational Software: Resources specifically tailored for learning and certification preparation.
Some popular downloads include Lista IPTV 2024, Photoshop Portable PT-BR, and CapCut Pro PC. These tools can serve as great supplementary resources to the courses and modules on Microsoft Learn.
You can check out the available software here. All downloads are completely free and can serve as great supplementary resources to the courses and modules on Microsoft Learn.
I hope this resource is as helpful to you as it has been to me. Feel free to explore and let me know if you find any particular tools that stand out or if you have other recommendations to share!
Happy Learning!
Hello, Microsoft Learn Community, As many of us are diving deep into Microsoft technologies and expanding our skills, having access to the right tools and software can significantly enhance our learning experience. I wanted to share a resource that I found incredibly useful.I’ve come across a website that offers a variety of software tools available for free download. These tools can be particularly beneficial for those of us involved in studying and practicing various Microsoft technologies, such as Azure, Microsoft 365, and other development tools.Crackeialivre provides:Development Tools: Access to IDEs, code editors, and other development resources.Productivity Software: Tools to improve workflow and project management.Educational Software: Resources specifically tailored for learning and certification preparation.Some popular downloads include Lista IPTV 2024, Photoshop Portable PT-BR, and CapCut Pro PC. These tools can serve as great supplementary resources to the courses and modules on Microsoft Learn.You can check out the available software here. All downloads are completely free and can serve as great supplementary resources to the courses and modules on Microsoft Learn. I hope this resource is as helpful to you as it has been to me. Feel free to explore and let me know if you find any particular tools that stand out or if you have other recommendations to share! Happy Learning! Read More
Hear how Qumolo partners with Microsoft Azure to unlock on-prem data for AI Apps in the cloud
Check out this new video on Microsoft Azure’s YouTube Channel, highlighting how Qumulo partners with Microsoft Azure to unlock on-prem data for AI Apps in the cloud.
Qumulo’s CTO Kiran Bahgeshpur explains how Qumulo’s partnership with Microsoft allows them to seamlessly offer innovative data storage solutions to their customers. Qumulo is built on Microsoft Azure and offers data storage, management and curation services that enable scalability, performance, and economics to power any file-based enterprise workload in the cloud.
Check out this new video on Microsoft Azure’s YouTube Channel, highlighting how Qumulo partners with Microsoft Azure to unlock on-prem data for AI Apps in the cloud.
Qumulo’s CTO Kiran Bahgeshpur explains how Qumulo’s partnership with Microsoft allows them to seamlessly offer innovative data storage solutions to their customers. Qumulo is built on Microsoft Azure and offers data storage, management and curation services that enable scalability, performance, and economics to power any file-based enterprise workload in the cloud.
Read More