Recent Discussions
Can Agent 365–registered 3rd-party agents be invoked outside MS 365 clients and still track usage?
Hello, The documentation describes how to register a third-party agent with the Microsoft Agent 365 platform (for example an agent hosted on Google Cloud Run) in order to benefit from capabilities such as observability, governance, security, and centralized management. Does this mean that users must access these agents through Microsoft 365 entry points (such as Copilot Chat, Teams, or other Microsoft clients) in order for those capabilities to apply? Or can the same registered agent also be invoked and interacted with from third-party clients or external services (for example applications running in GCP) while still benefiting from Agent 365 features like observability, governance and/or security? What if third party agent is registered to Agent 365, but it doesn't use EntraID? It's what observability, governance and/or security will be available then? Thank you.
Formula for Complex Matrices
Hi Microsoft Community Hub, I am excited to share a new method I have developed for solving matrices with complex numbers. As many of you know, handling complex matrix operations in environments like Excel or during manual computation often requires separating real and imaginary parts, which increases complexity and the margin for error. I have conceptualized the formula which streamlines this process by providing a more direct approach. This is a dynamic formula and this formula works for any dimension of matrix (see the screenshot below). =IFERROR( BYROW(TRANSPOSE(WRAPROWS(LET( mat, A2:J11, coef, L2:L11, re, MAP(mat, LAMBDA(a, IMREAL(a))), im, MAP(mat, LAMBDA(a, IMAGINARY(a))), MMULT(MINVERSE(HSTACK(VSTACK(re, im), VSTACK(-im, re))), VSTACK(MAP(coef, LAMBDA(a, IMREAL(a))), MAP(coef, LAMBDA(a, IMAGINARY(a)))))), ROWS(A2:J11))), LAMBDA(a, COMPLEX(TAKE(a,, 1), TAKE(a,, -1)))), "Singular Matrix") Linkedin GitHub I hope this solution helps someone. Best regards, IlirUOBO Agents vs. Execute-as-User Agents: What Will Agent 365 provide?
It was mentioned during the AMA session that agents from the Microsoft ecosystem (Copilot Studio, Foundry, SharePoint) will be automatically onboarded into Agent 365. However, today many of these agents execute as users, and some may continue to operate this way indefinitely. In other words, they may never receive their own Entra ID agent identity and may never run using an On-Behalf-Of (OBO) model. This raises an important question around observability, governance, and security. If these agents do not have their own identity and continue to execute under user credentials, what capabilities will Agent 365 provide for them in terms of monitoring, governance, and security controls? TL;DR: It is still unclear what observability and governance features will be available for non-OBO agents - both within Agent 365 itself and through standard platform administration tools. A clear comparison between OBO agents and non-OBO agents in terms of visibility, governance, and security capabilities would be extremely helpful. Thank youCreating weekly calendar template that has overlapping positions
Hi, I have a software for individuals to sign up for shifts, but it is visually hard to see where there are open areas that need to be filled. I need help creating a calendar from this software download that I can update each week. It would have to be much like an hourly scheduler view to easily see when someone is coming on and off shift. But also laid out from Sun-Saturday. There is 3-4 "slots" for each day. It would be great if they could be color coded as well. Slot 1 needs to be anyone that is "AEMT" in the position column, Slot 2 can be anyone listed as "EMT" or "EMR" (caveat to this would be that slot 2 could also be AEMT if there is already an AEMT in slot 1 for the same time slot. Slot 3 is for driver or ride along (or the other 3 positions if there is one listed in the other slots), and possibly 4th slot would just be overflow in case there were 4 people signed up which does not happen very often. Is there anyone who can help me with designing this? Below is what the software generates when converting to excel
Could Agent 365 end up being just central observability platform without needing per user licenses?
Since Agent 365 allows bringing in both first-party and third-party agents, I’m curious about the identity and licensing model. If an agent is not using an Entra Agent Identity, will it still appear in Agent 365 observability or governance? In other words, could organizations use Agent 365 mainly for central visibility, monitoring, and governance of agents, even if those agents don’t have their own identities? And if that’s the case, does it mean companies could avoid needing a per-user Agent 365 license for every employee interacting with the agent? In summary if a company doesn't need OBO features, just central visibility, can they still benefit from Agent 365?Agent 365 - can it be used just as a Governance platform for non-OBO agents?
It was mentioned that Agent 365 will allow to combine first-party, partner and third-party agents. Does this mean organizations could use the platform mainly for central visibility and governance of agents, but not necessarily for agent identities, effectively avoiding the need to pay a per-user license for everyone interacting with the agent?Using the Microsoft 365 Connector for Claude
The Microsoft 365 Connector for Claude allows Claude to access SharePoint and OneDrive files, emails, and Teams chats and meetings. The connector is now available to all users, including the free tier for Claude. Installing the connector creates two Entra ID enterprise apps (MCP server and client) and channels Graph requests to Microsoft 365 to fetch information for processing by Claude. Is that a good thing? https://office365itpros.com/2026/04/08/microsoft-365-connector-for-claude/
Office Script - Bug in .map()?
Hi, I'm pretty sure this is a bug, but maybe I'm doing something silly when constructing the formula? I'm trying to set formulas down a column in a table, from an array called test1. The test1 array is created using .map() from an original array (file_names) that uses .getTexts from another column in the same table. The dimensions of target_range (another column in the same table) match those of test1 array. The test1 array is appropriately 2D (i.e. [[formula1],[formula2]...[formulaN]]. The test1 array is correct when inspected in console.log() (in all cases, including when an equals sign is used.....explained more below). The problem is that trying to use .setFormulas, is only using the first value from test1 for every cell in target_range, not each respective element from test1. After a massively frustrating amount of time, I've traced the problem solely to this (as far as I can tell): The presence of an equals sign in the .map() when using string interpolation to create the formula. This code correctly writes the text of the formula into each cell of target_range, using each respective value from write_array with appropriate interpolation: let file_names: string[][] = rng_file_names.getTexts(); let test1: string[][] = file_names.map( row => [`\"${row}\"&\"TestString\"`] ); target_range.setFormulas(test1); If you try to do exactly the same, but try turning it into a formula by including the equals sign at the start of the interpolated string inside the array returned by the .map(), it will only write the first value of test1 into all cells of target_range: let file_names: string[][] = rng_file_names.getTexts(); let test1: string[][] = file_names.map( row => [`=\"${row}\"&\"TestString\"`] ); target_range.setFormulas(test1); I'm pretty sure this is a bug, but if someone can point if I'm doing something stupid, it would be appreciated!
PCLaw Cloud Hosting: Secure and Flexible Legal Practice Management in the Cloud
Cloud hosting for PCLaw is transforming how law firms handle billing, accounting, and case management by moving traditional server-based systems into a secure, accessible cloud environment. Instead of relying on in-house servers, firms can run PCLaw on remote infrastructure and access it anytime, from anywhere. Traditionally, PCLaw operates as a desktop-based application that requires dedicated servers and ongoing IT maintenance. With cloud hosting, the same software is delivered through a virtual desktop or private cloud, eliminating the need for hardware management while preserving full functionality. This allows legal professionals to work seamlessly across devices, whether in the office, at home, or on the go. One of the biggest advantages of PCLaw cloud hosting is improved accessibility and mobility. Attorneys and staff can securely access client data, billing systems, and case files without relying on complex VPN setups. Cloud environments also enhance collaboration, enabling multiple users to work on the same data in real time. Security is another major benefit. Cloud-hosted PCLaw environments use encrypted connections, secure data centers, and automated backups to protect sensitive legal information. This reduces the risk of data loss due to hardware failure or cyber threats while ensuring compliance with industry standards. Additionally, cloud hosting reduces IT burden and costs. Service providers handle updates, maintenance, and support, allowing law firms to focus on client services instead of infrastructure management. It also offers predictable monthly pricing, making budgeting easier. Scalability further enhances its appeal, as firms can easily add users or resources as they grow without investing in new hardware. For law firms seeking a modern, reliable solution, Apps4Rent offers secure PCLaw cloud hosting with expert support, high performance, and flexible plans designed to meet the evolving needs of legal professionals.
2 spacing after every full stop of a sentence
Hi, I believe the old norm is to have two spacing after the end of a sentence before starting a new sentence. But nowadays many people are using only one spacing. I need to try to make it a consistent way to follow. Is there an easy way to scan through all the document and make sure changes are applied to follow at least one norm.
Spellcheck Not Working for Some Words?
I have a workbook with misspelled names like Tangirs, Manilla, Aisa, Santigo. These are places. Spellcheck caught Tangiers but missed Manila, Asia, and Santiago. Any idea on what's going on and how I can prevent this? These words seem obvious. Full Name Region and Sub-Region Bonita Sykes North America - New York Cairo Pemberton Aisa - Manilla Chante Devlin Africa - Tangier Erica Prince Europe - Santigo Florrie Greenaway North America - Chicago Frederic Holman Europe - LondonExcel Macros Spreadsheets Not Loading
I've spent some time with Microsoft Support (almost 3 hours, including uninstalling my MS 365 and reinstalling it), but I'm having an issue with my Excel Macro spreadsheets not loading at all. This is what I get each time. Also having an issue with non-Macro spreadsheets that I'm unable to use the Bold, Italic, and Underline functions (get the spinning wheel and then Excel Not Responding), as well as not able to use the Format function (get the same spinning wheel and then Excel Not Responding). I've been using these same Excel Macro Spreadsheets for over 15 years. Please help!
Losing borders in transition from Excel 97 to 2024 Pro Plus
I have a handy appointments calendar (.xls) that has used Excel 97 on a Windows 7 laptop for a long time. I want to run this on my latest laptop that has Excel 2024 Pro Plus on Windows 11. When I open this now, many of the cell borders, most of which are involved with conditional formatting, are either present when they should be absent or absent when they should be present. The calendar is useless as opened. I have worked to reformat the cells, but it has taken me hours to get from January to April and some aspects are still problematic, albeit acceptable. The conditional formatting process is very different between the two versions. Is there some trick to getting newer versions of Excel to properly recognize formatting from older versions? I created this calendar in Excel 97 very easily many years ago. I am not sure I could duplicate it, even from scratch, using Excel 2024.There seems to be a bug in the WORD Index.
Hello, I'm writing a document with an index. There are several Latin based names that require symbols, most notably a small e with an acute accent. The problem name is "Vélez." It will not index correctly putting a separate line for each entry. In troubleshooting the problem, I find that if I replace the symbol "é" with "e," it works okay. Interestingly, the name "Frémont" works okay too. Any ideas?
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- 6 MIN READThe Microsoft 365 Community Conference is back in Orlando, April 21–23, 2026, and it’s once again the place to learn, connect, and go deep on what’s next for Microsoft 365. Earlier this month, we c...Apr 08, 2026
- AI-powered community agents help communities speed up answers and reduce repetitive work for admins.Apr 07, 2026
