Category: Microsoft
Category Archives: Microsoft
Trying to create Subsite
I have just signed up to 365 Basic Plan and trying to create a Sharepoint Subsite but seemingly nothing I’ve tried has worked.
I’m the only user set up so have full permission as owner and I can’t see any option under Site creation to enable subsite permissions. I’ve also tried unselecting the Create a shared library from OneDrive.
I have just signed up to 365 Basic Plan and trying to create a Sharepoint Subsite but seemingly nothing I’ve tried has worked. I’m the only user set up so have full permission as owner and I can’t see any option under Site creation to enable subsite permissions. I’ve also tried unselecting the Create a shared library from OneDrive. Read More
List Hyperlink active based on value
Hi All,
I have a hyperlink column which need to get active only when display text is “Yes”. The two other option “No” and “Not Required” when entered should not create a hyperlink. Below is the code which gives me result accurately with all formatting but don’t want hyperlink for “No” and “Not Required”. Any help appreciated.
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“children”: [
{
“elmType”: “a”,
“style”: {
“box-sizing”: “border-box”,
“padding”: “4px 8px 5px 8px”,
“overflow”: “hidden”,
“text-overflow”: “ellipsis”,
“display”: “flex”,
“border-radius”: “16px”,
“height”: “24px”,
“align-items”: “center”,
“white-space”: “nowrap”,
“margin”: “4px 4px 4px 4px”
},
“txtContent”: “@currentField.desc”,
“attributes”: {
“href”: “@currentField”,
“class”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“Yes”
]
},
“sp-css-backgroundColor-BgGreen sp-css-borderColor-WhiteFont sp-field-fontSizeSmall sp-css-color-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“No”
]
},
“sp-css-backgroundColor-BgRed sp-css-borderColor-WhiteFont sp-field-fontSizeSmall sp-css-color-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“Not Required”
]
},
“sp-css-backgroundColor-BgGold sp-field-fontSizeSmall sp-css-color-GoldFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“”
]
},
“”,
“sp-field-borderAllRegular sp-field-borderAllSolid sp-css-borderColor-neutralSecondary”
]
}
]
}
]
}
]
}
}
}
]
}
Hi All, I have a hyperlink column which need to get active only when display text is “Yes”. The two other option “No” and “Not Required” when entered should not create a hyperlink. Below is the code which gives me result accurately with all formatting but don’t want hyperlink for “No” and “Not Required”. Any help appreciated. {
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“children”: [
{
“elmType”: “a”,
“style”: {
“box-sizing”: “border-box”,
“padding”: “4px 8px 5px 8px”,
“overflow”: “hidden”,
“text-overflow”: “ellipsis”,
“display”: “flex”,
“border-radius”: “16px”,
“height”: “24px”,
“align-items”: “center”,
“white-space”: “nowrap”,
“margin”: “4px 4px 4px 4px”
},
“txtContent”: “@currentField.desc”,
“attributes”: {
“href”: “@currentField”,
“class”: {
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“Yes”
]
},
“sp-css-backgroundColor-BgGreen sp-css-borderColor-WhiteFont sp-field-fontSizeSmall sp-css-color-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“No”
]
},
“sp-css-backgroundColor-BgRed sp-css-borderColor-WhiteFont sp-field-fontSizeSmall sp-css-color-WhiteFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“Not Required”
]
},
“sp-css-backgroundColor-BgGold sp-field-fontSizeSmall sp-css-color-GoldFont”,
{
“operator”: “:”,
“operands”: [
{
“operator”: “==”,
“operands”: [
“@currentField.desc”,
“”
]
},
“”,
“sp-field-borderAllRegular sp-field-borderAllSolid sp-css-borderColor-neutralSecondary”
]
}
]
}
]
}
]
}
}
}
]
} Read More
M365 Copilot causing msedgewebview2.exe to crash in AVD
M365 Copilot causing msedgewebview2.exe to crash in AVD.
Fault: Unkown Hard Error in WebView 2.
I am after specifics on how to analyse this issue, as if this does happen then AVD needs to be rebooted.
– What Troubleshooting Steps are posible
M365 Copilot causing msedgewebview2.exe to crash in AVD. Fault: Unkown Hard Error in WebView 2. I am after specifics on how to analyse this issue, as if this does happen then AVD needs to be rebooted. – What Troubleshooting Steps are posible Read More
discount if I already have a Microsoft Defender for Endpoint license
Hi, I am looking to explore the Microsoft Defender for Endpoint server license vs Defender for servers plan 2 licensing.
We do have existing licenses available for Microsoft Defender for Endpoint server licenses and we would like to make use of this license in azure to avoid double payment of licenses.
Can someone help me understand how does this credit process work? i know starting point is raising a ticket with MS. Can we get the credit if we have only spare licenses? what if i have licenses being used on onboarded servers still can i request credit?
Also what is the easiest way to way to see how many Microsoft Defender for Endpoint servers license are in use right now?
Hi, I am looking to explore the Microsoft Defender for Endpoint server license vs Defender for servers plan 2 licensing.We do have existing licenses available for Microsoft Defender for Endpoint server licenses and we would like to make use of this license in azure to avoid double payment of licenses. Can someone help me understand how does this credit process work? i know starting point is raising a ticket with MS. Can we get the credit if we have only spare licenses? what if i have licenses being used on onboarded servers still can i request credit? Also what is the easiest way to way to see how many Microsoft Defender for Endpoint servers license are in use right now? Read More
Monthly news – August 2024
Microsoft Defender XDR
Monthly news
August 2024 Edition
This is our monthly “What’s new” blog post, summarizing product updates and various new assets we released over the past month across our Defender products. In this edition, we are looking at all the goodness from July 2024. Defender for Cloud has it’s own Monthly News post, have a look at their blog space.
Legend:
Product videos
Webcast (recordings)
Docs on Microsoft
Blogs on Microsoft
GitHub
External
Improvements
Previews / Announcements
Unified Security Operations Platform: Microsoft Defender XDR & Microsoft Sentinel
(GA) The Microsoft unified security operations platform in the Microsoft Defender portal is generally available. This release brings together the full capabilities of Microsoft Sentinel, Microsoft Defender XDR, and Microsoft Copilot in Microsoft Defender. For more information, see the following resources:
Blog post: General availability of the Microsoft unified security operations platform
Ninja Show episode: Unified Security Operations Platform GA launch
Documentation: Microsoft Sentinel in the Microsoft Defender portal
Documentation: Connect Microsoft Sentinel to Microsoft Defender XDR
Documentation: Microsoft Copilot in Microsoft Defender
(Preview) You can now customize columns in the Incidents and Alerts queues in the Microsoft Defender portal. You can add, remove, reorder columns to display the information you need. For more information, see how to customize columns in the incident queue and alert queue.
(GA) Filtering Defender for Cloud alerts by the associated alert subscription ID in the Incidents and Alerts queues is now generally available. For more information, see Defender for Cloud in Defender XDR.
Incidents with alerts where a compromised device communicated with an operational technology (OT) device are now visible in the Microsoft Defender portal through the Defender for IoT license and Defender for Endpoint’s device discovery capabilities. Using Defender for Endpoint data, Defender XDR automatically correlates these new OT alerts to incidents to provide a comprehensive attack story. To filter related incidents, see Prioritize incidents in the Microsoft Defender portal.
Blog: Make OT security a core part of your SOC strategy with Microsoft Defender XDR
(Preview) Critical assets are now part of the tags in the incident and alert queues. When a critical asset is involved in an incident or alert, the critical asset tag is displayed in the queues. For more information, see incident tags and the alert queue.
(Preview) Incidents are now arranged according to the latest automatic or manual updates made to an incident. Read about the last update time column in the incident queue.
Learning hub resources have moved from the Microsoft Defender portal to learn.microsoft.com. Access Microsoft Defender XDR Ninja training, learning paths, training modules and more. Browse the list of learning paths, and filter by product, role, level, and subject.
(GA) The UrlClickEvents table in advanced hunting is now generally available. Use this table to get information about Safe Links clicks from email messages, Microsoft Teams, and Office 365 apps in supported desktop, mobile, and web apps.
(GA) You can now release or move email messages from quarantine back to the user’s inbox directly from Take actions in advanced hunting and in custom detections. This allows security operators to manage false positives more efficiently and without losing context.
Microsoft Security Exposure Management
Microsoft Security Exposure Management is a security solution that provides a unified view of security posture across company assets and workloads. Security Exposure Management enriches asset information with security context that helps you to proactively manage attack surfaces, protect critical assets, and explore and mitigate exposure risk. Security Exposure Management is currently in public preview. Check out our documentation to learn more.
Microsoft Defender for IoT
Incidents with alerts where a compromised device communicated with an operational technology (OT) device are now visible in the Microsoft Defender portal through the Defender for IoT license and Defender for Endpoint’s device discovery capabilities. Using Defender for Endpoint data, Defender XDR automatically correlates these new OT alerts to incidents to provide a comprehensive attack story. To filter related incidents, see Prioritize incidents in the Microsoft Defender portal.
Blog: Make OT security a core part of your SOC strategy with Microsoft Defender XDR
Microsoft Defender for Endpoint
Reduce friction and protect faster with simplified Android onboarding. We’re excited to announce that a simplified onboarding experience in Defender for Endpoint on Android devices is now available in public preview. Read more here.
Microsoft Defender for Cloud Apps
(Preview) In-browser protection for macOS users and newly supported policies.
Edge browser users from macOS, scoped to session policies, are now protected with in-browser protection.
Learn more in our documentation.
(Preview) Configure and embed a custom support URL in Block pages.
Customize the Defender for Cloud Apps block experience for apps that are blocked using Cloud Discovery. Learn more in our documentation.
(GA) Filtering Defender for Cloud alerts by the associated alert subscription ID in the Incidents and Alerts queues is now generally available. For more information, see Defender for Cloud in Defender XDR.
Microsoft Defender for Office 365
Bulk Senders Insight: Optimizing Bulk Email Management for Enterprises. We’re excited to introduce Bulk Senders Insight – a sophisticated simulation tool designed to empower admins in fine-tuning bulk email policies. This tool offers real-time simulations that help identify the optimal BCL and identify potential FPs and FNs based on user preferences across your tenant. This feature will be rolling out to your tenants from August. Watch for a Message Center post about this.
Announcing quarantine release integration in Defender for Office 365 hunting experience!! This enhancement allows Security Operators to address false positives more efficiently and with greater flexibility.
Announcing Defender for Office 365 API’s for retrieving threat data and remediating emails. These new Defender for Office 365 API’s enable security teams to leverage threat information and response capabilities of Defender for Office 365 inside automation and security orchestration tools of their choice.
(GA) The UrlClickEvents table in advanced hunting is now generally available. Use this table to get information about Safe Links clicks from email messages, Microsoft Teams, and Office 365 apps in supported desktop, mobile, and web apps.
(GA) You can now release or move email messages from quarantine back to the user’s inbox directly from Take actions in advanced hunting and in custom detections. This allows security operators to manage false positives more efficiently and without losing context.
Tenant Allow/Block List in Microsoft 365 GCC, GCC High, DoD and and Office 365 operated by 21Vianet environments: The Tenant Allow/Block List is now available in these environments. They are on parity with the WW commercial experiences. Learn more in our documentation.
45 days after last used date: The value Remove allow entry after > 45 days after last used date is now the default on new allow entries from submissions and existing allow entries in the Tenant Allow/Block List. Learn more in our documentation.
Microsoft Defender Vulnerability Management
Guidance for handling “regreSSHion” (CVE-2024-6387) using Microsoft Security capabilities.
Using Export API with Defender Vulnerability Management. Defender Vulnerability Management provides an export API that allows programmatic access to vulnerability data. The API can be used to automate vulnerability management tasks, integrate vulnerability data with other security tools, and generate custom reports and dashboards. In this blog, we share guidance and best practices for using Defender Vulnerability Management Export API.
Microsoft Security Blogs
Mitigating Skeleton Key, a new type of generative AI jailbreak technique
Microsoft recently discovered a new type of generative AI jailbreak method called Skeleton Key that could impact the implementations of some large and small language models. This new method has the potential to subvert either the built-in model safety or platform safety systems and produce any content.
Onyx Sleet uses array of malware to gather intelligence for North Korea
On July 25, 2024, the United States Department of Justice (DOJ) indicted an individual linked to the North Korean threat actor that Microsoft tracks as Onyx Sleet. Microsoft Threat Intelligence collaborated with the Federal Bureau of Investigation (FBI) in tracking activity associated with Onyx Sleet. We will continue to closely monitor Onyx Sleet’s activity to assess changes following the indictment.
Vulnerabilities in PanelView Plus devices could lead to remote code execution
Microsoft discovered and responsibly disclosed two vulnerabilities in Rockwell’s PanelView Plus that could be remotely exploited by unauthenticated attackers, allowing them to perform remote code execution (RCE) and denial-of-service (DoS). PanelView Plus devices are graphic terminals, which are known as human machine interface (HMI) and are used in the industrial space.
Ransomware operators exploit ESXi hypervisor vulnerability for mass encryption
Microsoft Security researchers have observed a vulnerability used by various ransomware operators to get full administrative access to domain-joined ESXi hypervisors and encrypt the virtual machines running on them. The vulnerability involves creating a group called “ESX Admins” in Active Directory and adding an attacker-controlled user account to this group.
Microsoft Tech Community – Latest Blogs –Read More
Global Administrator Issue
Please be advised that the verification process for your IWE request could not be completed.
The service request will be closed since Microsoft is not able to intervene in any internal dispute.
Thank you for contacting the Microsoft 365 Data Protection Team.
Is there any other Solution for this because the global admin not sharing passwords with the company and asking for extra money
***Need help in this matter***
Please be advised that the verification process for your IWE request could not be completed. The service request will be closed since Microsoft is not able to intervene in any internal dispute. Thank you for contacting the Microsoft 365 Data Protection Team. Is there any other Solution for this because the global admin not sharing passwords with the company and asking for extra money ***Need help in this matter*** Read More
VLookup formula into IF sum
Hi,
I am trying to make a formula for the below:
If text in column D is “No”, calculate in column F =IF(E19>TODAY(),”Overdue”,””)
Does anyone know how to integrate a Vlookup into the IF sum?
Thanks.
Hi, I am trying to make a formula for the below: If text in column D is “No”, calculate in column F =IF(E19>TODAY(),”Overdue”,””) Does anyone know how to integrate a Vlookup into the IF sum? Thanks. Read More
Blocking USB slots in Intune
Dear Reader,
because of security reasons, I want to block all the USB slots of our clients.
On different websides I was told to go to Intunes – Devices – Windows – Configuration and create a new “GPO” policy by choosing an administrative template called “prevent installation of devices not described….” and include the user group. In a second step I need to exclude all the hardware I do not want to be blocked, like keyboard, mouse….
But after all that doesn´t seem to work.
After waiting a few hours, in hope the test client would drag the “GPO”, I could still use my own USB Stick. (Btw: is there a way to synchronise instead of waiting? Like the old gpupdate /force in cmd? and without the “synchronise” in the company portal?)
After that fail, I did the same in Endpoint security and that works fine. All the USB slots are locked.
So was it just a wrong infromation to do it with a configuration profile?
Where is the difference between configuration profile and endpoint security?
In a next step I want to lock down USB in booting the PC as well. Is that possible?
Thanks a lot for any hint.
Have a nice day.
Hilmar
Dear Reader, because of security reasons, I want to block all the USB slots of our clients.On different websides I was told to go to Intunes – Devices – Windows – Configuration and create a new “GPO” policy by choosing an administrative template called “prevent installation of devices not described….” and include the user group. In a second step I need to exclude all the hardware I do not want to be blocked, like keyboard, mouse…. But after all that doesn´t seem to work.After waiting a few hours, in hope the test client would drag the “GPO”, I could still use my own USB Stick. (Btw: is there a way to synchronise instead of waiting? Like the old gpupdate /force in cmd? and without the “synchronise” in the company portal?) After that fail, I did the same in Endpoint security and that works fine. All the USB slots are locked. So was it just a wrong infromation to do it with a configuration profile? Where is the difference between configuration profile and endpoint security? In a next step I want to lock down USB in booting the PC as well. Is that possible? Thanks a lot for any hint. Have a nice day. Hilmar Read More
Urgent Request for Assistance: Overcoming Verification Challenges in AI Cloud Partner Program
Hello Community,
I am reaching out as urgently seeking guidance or insights from those familiar with the challenges of the AI Cloud Partner Program or anyone who can offer assistance. We are currently handling two domains:
main domain (A): Our actively managed Sales Intelligence SaaS.email domain (B): Previously active service, now pivoted to main domain and used internally.
Over the past month, we have faced significant hurdles in the verification process of the AI Cloud Partner Program, despite rigorously following all outlined steps from Microsoft and various community resources. Here’s what we have undertaken:
Contact Information: We transitioned from using generic email addresses like contact@ or marketing@ to personal accounts after learning they could lead to application rejections.
Documentation Submission: Initially, we provided receipts as Namecheap does not issue invoices. After realizing that only invoices were acceptable, we ceased submitting receipts.
Domain Hosting and Privacy: We meticulously matched the contact profile details—company name, address, contact information—down to case sensitivity on our email domain (B), which we host directly. Furthermore, we disabled privacy features in WHOIS to expose my personal information, prioritizing compliance over privacy.
Support Interaction: We are actively engaging with the partner support through three ongoing support tickets, attempting to resolve our issues. Separately, we reached out to Microsoft’s Partner Twitter handle but have not received a response.
Parallel Certification Attempt: Our application to the ISV Success program was stopped because our account showed “multiple failed attempts,” according to their system. This has blocked us from proceeding with our Account Verification.
Despite these efforts, we are still awaiting a final decision from the AI Cloud Partner Program, now well beyond the initial promise of 3-5 business days, extending over ten days.
The documentation requirements for the ISV Success are identical to those of the AI Cloud Partner Program, heightening our concern as both are crucial for our business operations, which are currently under severe strain.
We are in dire need of a more personalized response to understand possible missteps or further required actions. The generic responses from the partner center have been unhelpful and frustrating.
Does anyone have any insights or can offer assistance on how to move forward in this situation? Has anyone else faced similar verification challenges?
Thank you in advance for your support and guidance.
Hello Community, I am reaching out as urgently seeking guidance or insights from those familiar with the challenges of the AI Cloud Partner Program or anyone who can offer assistance. We are currently handling two domains:main domain (A): Our actively managed Sales Intelligence SaaS.email domain (B): Previously active service, now pivoted to main domain and used internally. Over the past month, we have faced significant hurdles in the verification process of the AI Cloud Partner Program, despite rigorously following all outlined steps from Microsoft and various community resources. Here’s what we have undertaken:Contact Information: We transitioned from using generic email addresses like contact@ or marketing@ to personal accounts after learning they could lead to application rejections.Documentation Submission: Initially, we provided receipts as Namecheap does not issue invoices. After realizing that only invoices were acceptable, we ceased submitting receipts.Domain Hosting and Privacy: We meticulously matched the contact profile details—company name, address, contact information—down to case sensitivity on our email domain (B), which we host directly. Furthermore, we disabled privacy features in WHOIS to expose my personal information, prioritizing compliance over privacy.Support Interaction: We are actively engaging with the partner support through three ongoing support tickets, attempting to resolve our issues. Separately, we reached out to Microsoft’s Partner Twitter handle but have not received a response.Parallel Certification Attempt: Our application to the ISV Success program was stopped because our account showed “multiple failed attempts,” according to their system. This has blocked us from proceeding with our Account Verification.Despite these efforts, we are still awaiting a final decision from the AI Cloud Partner Program, now well beyond the initial promise of 3-5 business days, extending over ten days.The documentation requirements for the ISV Success are identical to those of the AI Cloud Partner Program, heightening our concern as both are crucial for our business operations, which are currently under severe strain. We are in dire need of a more personalized response to understand possible missteps or further required actions. The generic responses from the partner center have been unhelpful and frustrating.Does anyone have any insights or can offer assistance on how to move forward in this situation? Has anyone else faced similar verification challenges?Thank you in advance for your support and guidance. Read More
How to find our TPIN ID
How to find our Microsoft partner TPIN id.
Raised ticket from partner portal but they have responded its out of their scope.
How to find our Microsoft partner TPIN id. Raised ticket from partner portal but they have responded its out of their scope. Read More
Send Message as User/Bot Using Graph API Based on User’s Email Existence in Microsoft Teams Channel
If a user’s email exists in the teams channel, the message should be sent as a reply from that user.If the user’s email doesn’t exist in the channel, the message should be sent from a bot or a service account.
Here is a rough outline of what I’m trying to accomplish:
Check if the email exists in the teams channel.If it does, send the message as the user.If it doesn’t, send the message as a bot or service account.
I’m working on a project that involves sending messages to a Microsoft Teams channel using the Microsoft Graph API. I have a specific requirement where:If a user’s email exists in the teams channel, the message should be sent as a reply from that user.If the user’s email doesn’t exist in the channel, the message should be sent from a bot or a service account.I’m using user’s token for authentication. Is there any way to achieve this conditional sending of messages using the Microsoft Graph API?Here is a rough outline of what I’m trying to accomplish:Check if the email exists in the teams channel.If it does, send the message as the user.If it doesn’t, send the message as a bot or service account.Any guidance or examples on how to implement this would be greatly appreciated. Thank you! Read More
Is there any power point certification exams & courses or excel certification exams & courses
Hi,
We are a learning partners from India.
Our few of clients inquiring us for powerpoint certification exams & courses and also excel certification exams & courses.
Kindly advise us on the same.
Thanks and regards
Hi, We are a learning partners from India. Our few of clients inquiring us for powerpoint certification exams & courses and also excel certification exams & courses. Kindly advise us on the same. Thanks and regards Read More
please help again
I am making a function and when I try to add the next argument the entire code goes white and the colouring on the writing to show the cell is referenced by colour coding
=IF(AND($L$5=3,$M$5=2,H5<2),4,IF(AND($L$5=3,$M$5=1,H5<2),2,IF(AND(G10=”left”,H5>0,G5=0,F5=0),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,F5<>H5,I5>0,I5<>H5),H5,IF(AND(H5>0,G5=0,F5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,H5<>F5,I5>0,I5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,F5=G5,I5>0,I5<>H5),I5,IF(AND(G10=”left”,H5>0,G5=0,F5>0,I5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,G5<>F5,H5=I5),H5+I5,IF(AND(G10=”right”,H5>0,I5=H5,G5>0,G5<>F5),G5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=0,F5=H5),H5+F5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=H5),G5+H5,IF(AND(G10=”right”,H5=0,I5>0,G5>0,G5=F5,G5<>I5),G5+F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,F5>0,F5<>G5),F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,G5=F5),0,IF(AND(G10=”right”,H5=0,I5>0,G5>0,F5>0,F5<>G5,I5=G5),F5,IF(AND(G10=”up”,H5>0,H6=H5),H5+H6,IF(AND(G10=”up”,H5>0,H6=0,H7=H5),H5+H7,IF(AND(G10=”up”,H5>0,H6=0,H7=0,H8=H5),H5+H8,IF(AND(G10=”up”,H5=0,H6>0,H6<>H7,H7=0,H6=H8),H6+H8,IF(AND(G10=”up”,H5=0,H6>0,H7<>H6,H7<>0),H6,IF(AND(G10=”up”,H5=0,H6>0,H6=H7),H6+H7,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7=H8),H7+H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”up”,H5=0,H6=0,H7=0,H8>0),H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”down”,H5>0,H6=0),0,IF(AND(G10=”down”,H5>0,H6>0,H6=H5),0,IF(AND(G10=”down”,H5>0,H6>0,H5<>H6,H7=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H5<>H6,H7<>H8,H8=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8=H7),0,IF(AND(H5>0,H6>0,H7>0,H8>0,H8<>H7,H7=H6),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8<>H7,H7<>H6,H5=H6),0,IF(AND(G10=”right”,I5=0,H5>0,G5>0,F5<>G5,F5>0),G5,IF(AND(G10=”left”,H5>0,I5>0,G5>0,
I am making a function and when I try to add the next argument the entire code goes white and the colouring on the writing to show the cell is referenced by colour coding=IF(AND($L$5=3,$M$5=2,H5<2),4,IF(AND($L$5=3,$M$5=1,H5<2),2,IF(AND(G10=”left”,H5>0,G5=0,F5=0),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,F5<>H5,I5>0,I5<>H5),H5,IF(AND(H5>0,G5=0,F5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,H5<>F5,I5>0,I5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,F5=G5,I5>0,I5<>H5),I5,IF(AND(G10=”left”,H5>0,G5=0,F5>0,I5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,G5<>F5,H5=I5),H5+I5,IF(AND(G10=”right”,H5>0,I5=H5,G5>0,G5<>F5),G5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=0,F5=H5),H5+F5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=H5),G5+H5,IF(AND(G10=”right”,H5=0,I5>0,G5>0,G5=F5,G5<>I5),G5+F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,F5>0,F5<>G5),F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,G5=F5),0,IF(AND(G10=”right”,H5=0,I5>0,G5>0,F5>0,F5<>G5,I5=G5),F5,IF(AND(G10=”up”,H5>0,H6=H5),H5+H6,IF(AND(G10=”up”,H5>0,H6=0,H7=H5),H5+H7,IF(AND(G10=”up”,H5>0,H6=0,H7=0,H8=H5),H5+H8,IF(AND(G10=”up”,H5=0,H6>0,H6<>H7,H7=0,H6=H8),H6+H8,IF(AND(G10=”up”,H5=0,H6>0,H7<>H6,H7<>0),H6,IF(AND(G10=”up”,H5=0,H6>0,H6=H7),H6+H7,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7=H8),H7+H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”up”,H5=0,H6=0,H7=0,H8>0),H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”down”,H5>0,H6=0),0,IF(AND(G10=”down”,H5>0,H6>0,H6=H5),0,IF(AND(G10=”down”,H5>0,H6>0,H5<>H6,H7=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H5<>H6,H7<>H8,H8=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8=H7),0,IF(AND(H5>0,H6>0,H7>0,H8>0,H8<>H7,H7=H6),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8<>H7,H7<>H6,H5=H6),0,IF(AND(G10=”right”,I5=0,H5>0,G5>0,F5<>G5,F5>0),G5,IF(AND(G10=”left”,H5>0,I5>0,G5>0, Read More
Which partner role to use making a business apps claim in Partner Center?
We have a government customer with an enterprise agreement. We’ve worked with them for a couple of years as their systems integrator deploying Dynamics 365 Customer Service, Power Apps and Power Pages.
We’re trying to make a customer claim in Partner Center.
On the Incentives | Customer claims screen, I’m confused about the partner roles:
Build intent – AdvisorPartner activitiesUsage recognition – Non-IncentivizedInfluenced Revenue recognition – Non-Incentivized
The guidance page on Learn doesn’t make any sense to me.
Can anyone explain it like I’m an 8th grader new to Microsoft partnership?
All we want is revenue recognition, usage recognition, partner points, solution designtions, incentives, awards, margin, rebates, and a healthy and happy life.
How can I figure out which role to choose to achieve these goals?
We have a government customer with an enterprise agreement. We’ve worked with them for a couple of years as their systems integrator deploying Dynamics 365 Customer Service, Power Apps and Power Pages.We’re trying to make a customer claim in Partner Center. On the Incentives | Customer claims screen, I’m confused about the partner roles:Build intent – AdvisorPartner activitiesUsage recognition – Non-IncentivizedInfluenced Revenue recognition – Non-IncentivizedThe guidance page on Learn doesn’t make any sense to me. Can anyone explain it like I’m an 8th grader new to Microsoft partnership? All we want is revenue recognition, usage recognition, partner points, solution designtions, incentives, awards, margin, rebates, and a healthy and happy life. How can I figure out which role to choose to achieve these goals? Read More
Errors in Events viewer
These errors(event id 16) keeps happening in 6 months. And every time it happens, my PC restart. Sometimes when my PC hiberate, it still happened.
These errors(event id 16) keeps happening in 6 months. And every time it happens, my PC restart. Sometimes when my PC hiberate, it still happened. Read More
Summing values based on certain time?
Is it possible WITHOUT using VBA to sum values if it’s not a certain time on the clock (the live computer clock). For example, if before 6pm sum values and if after 6pm don’t. I’d assume you have to use the now() function in someway to do this.
Ex
50
50
50
If before 6pm it should be 150. If after 6pm it should be 0. The time will change/update since its based on the current time (not a value listed on a spreadsheet).
Thanks!
Is it possible WITHOUT using VBA to sum values if it’s not a certain time on the clock (the live computer clock). For example, if before 6pm sum values and if after 6pm don’t. I’d assume you have to use the now() function in someway to do this. Ex505050 If before 6pm it should be 150. If after 6pm it should be 0. The time will change/update since its based on the current time (not a value listed on a spreadsheet). Thanks! Read More
Microsoft teams developer API in Node JS
Hi I am new to Microsoft teams community.I want a little help regarding MS Account.I am using Azure Account on my personal mail (I don’t have work mail) to use for Microsoft Graph API to authenticate my app in azure portal.The Authentication is successfull using Oauth flow.But when i access other API endpoints such as to get the teams that the user has joined or channels It says that i should have office ms licence.In Microsoft Graph API does some endpoints need WORK Account(ms office account) for accessiong these Endpoints.If so do i buy the microsoft 365 license.
Hi I am new to Microsoft teams community.I want a little help regarding MS Account.I am using Azure Account on my personal mail (I don’t have work mail) to use for Microsoft Graph API to authenticate my app in azure portal.The Authentication is successfull using Oauth flow.But when i access other API endpoints such as to get the teams that the user has joined or channels It says that i should have office ms licence.In Microsoft Graph API does some endpoints need WORK Account(ms office account) for accessiong these Endpoints.If so do i buy the microsoft 365 license. Read More
Work tracking ability
Hi,
I am curious, if its possible to track the working time and tasks with Copilot, so that it recoginezes how long I am working on a document (in general all changes are documented with time, thus this data could be extracted for this) and registeres these time in an e.g. excel sheet as working time on a day incl. stateing the document and at best even recognizes, for which customers this document was created. If I work on different documents for different customers on one day, I expect Copilot to document all these documents with the time for a customer and for the relevant day. At best, whenever I am not working on a document, it would be nice, if Copilot could ask what task I am performing and document this too – in Case of Teams Meeting, the time should be also documented and related to the customer and working day.
Contrary to usual employees, I want to controll myself with Copilot in detail with regard to the time I spend on different things/tasks and document them, to help me with the time tracking incl. detailed information, for the purpose of charging customers for the work done on basis of the measured working time. Also this would be very helpful to increase efficacy of work and maybe identify time thieves.
Unfortunately, I haven’t yet found a time tracking tool that is convenient for me and ideally records the working hours for tasks from the planner. In general you always have to manually specify the tasks done (which is actually already given in the planner, but I need to repeat it) and I find that a bit annoying. If working on several documents in a block, often the entire working time is recorded, but it can’t be broken down into the times required for the individual documents afterwards. Finally the working time recorded should be compared with the planned working time in the planner and gives me an information, how much time is left acc. to the planner to perfom a task.
I have great hopes, that Copilot could help in recording the working times and tasks as simply as possible (i.e. automatically when editing a document), but at the same time in detail. Is that a conceivable idea and can Copilot cover such task?
Thank you very much in advance for any thoughts about this.
Hi, I am curious, if its possible to track the working time and tasks with Copilot, so that it recoginezes how long I am working on a document (in general all changes are documented with time, thus this data could be extracted for this) and registeres these time in an e.g. excel sheet as working time on a day incl. stateing the document and at best even recognizes, for which customers this document was created. If I work on different documents for different customers on one day, I expect Copilot to document all these documents with the time for a customer and for the relevant day. At best, whenever I am not working on a document, it would be nice, if Copilot could ask what task I am performing and document this too – in Case of Teams Meeting, the time should be also documented and related to the customer and working day. Contrary to usual employees, I want to controll myself with Copilot in detail with regard to the time I spend on different things/tasks and document them, to help me with the time tracking incl. detailed information, for the purpose of charging customers for the work done on basis of the measured working time. Also this would be very helpful to increase efficacy of work and maybe identify time thieves. Unfortunately, I haven’t yet found a time tracking tool that is convenient for me and ideally records the working hours for tasks from the planner. In general you always have to manually specify the tasks done (which is actually already given in the planner, but I need to repeat it) and I find that a bit annoying. If working on several documents in a block, often the entire working time is recorded, but it can’t be broken down into the times required for the individual documents afterwards. Finally the working time recorded should be compared with the planned working time in the planner and gives me an information, how much time is left acc. to the planner to perfom a task. I have great hopes, that Copilot could help in recording the working times and tasks as simply as possible (i.e. automatically when editing a document), but at the same time in detail. Is that a conceivable idea and can Copilot cover such task? Thank you very much in advance for any thoughts about this. Read More
Scheduling Assistant Issue
Any updates to this? https://support.microsoft.com/en-us/office/error-when-opening-calendar-events-in-a-room-mailbox-from-scheduling-assistant-029a434c-0b2e-4b73-9680-7273c3a4dd2b
Weird thing is that some has this issue and some do not. Do we have a fix for this?
Thanks.
Any updates to this? https://support.microsoft.com/en-us/office/error-when-opening-calendar-events-in-a-room-mailbox-from-scheduling-assistant-029a434c-0b2e-4b73-9680-7273c3a4dd2b Weird thing is that some has this issue and some do not. Do we have a fix for this? Thanks. Read More
