Conditional formatting in SharePoint lists using JSON
I have my conditional formatting working if I only refer to one number. As can be seen in the image below if the cell I want to format has the number "1" in it the formatting works. I would like the same formatting to work if for example the number was less than "2" or between 3 and 5. I've tried several options with starting with "=if...", but it either breaks the conditional formatting or doesn't make a change. I have been able to find an example that matches the attributes. Full disclosure the conditional formatting continues so I can apply different colors to other individual numbers. I'm hoping the if I resolve on the set of numbers the others will follow the same framework.
OneDrive/SharePoint permission problem
Hello, the problem is that we have a user which wants to share file(s) with another user. If he shares the file and he gives him permissions for read and write the he is still not allowed to open it, even if he askes for permissions an those will be granted it still does not work. This works (or does not work) with several files, but not with all. If those files ares shared with other users it works instantly. We have another user with this problems, the only thing they have in common is, that both were deactivated over a period of I think 5-6 months or even longer. It is not with every file, and it does not matter if those files were uploaded in SharePoint or OneDrive and it does not really matter who uploaded it. If I e.g. downloads a file which does NOT work and I upload it again it works. I am not sure if I described it properly, but this problem only appears for 2 users which were disabled and unlicensed for a longer period of time. Is the only way to fix this to delete the account and create a new one, so that a whole new User ID is created and nothing is related to the old user or is there a proper way to handle it, because to delete the account and create a new one is more or less the last thing I want to do. Thanks in advanceHow to Design a Future-Proof SharePoint Information Architecture
A future-proof SharePoint Information Architecture balances business needs, user experience, and technical scalability. In this blog, we’ll explore what future-proofing really means, common pitfalls to avoid, and step-by-step technical guidance to design an IA that stands the test of time. https://dellenny.com/how-to-design-a-future-proof-sharepoint-information-architecture/
Teams, SharePoint, Viva Engage - which to use for dept comms?
I lead a 300‑person department, and I’m looking for guidance on the best Microsoft tool(s) to improve employee engagement and awareness across our organization. Right now, most of our communication happens in Microsoft Teams (channel posts, group chats), but we have dozens of channels and each group has its own space, which makes it hard to share department‑wide news, cascade annual strategic initiatives, report monthly progress, and celebrate wins or employee recognition. We don’t currently have any SharePoint sites built out, and we’re not using Viva Engage or communities. For those who’ve tackled similar challenges: Which Microsoft tools or combinations have worked best for broad communication, engagement, and consistent messaging across a large department? I’d love to hear what’s been effective for you. Thanks in advance for any insights!Quickly add approval workflows to any list or library in Microsoft 365
Leverage the power and simplicity of lightweight approvals on any list or library with a few simple clicks! SharePoint and Teams seamlessly integrate across files, lists, loops, and pages. And now, we’re excited to release the latest integration. SharePoint + the Teams Approvals app bringing you fast, easy approval-tracking business solutions – to any list or library. A single toggle gets you started: Create, approve, reject, and cancel – without leaving your content or the context of your conversations. Whether you need to approve a purchase order, a vacation request, project milestones, or a blog post, Approvals in lists and libraries help streamline the process and collaboration among your team members.Five things for IT administrators to know about agents built in SharePoint management
Every day, customers add over two billion files to SharePoint and create two million new SharePoint sites. Agents built in SharePoint unlock this vast knowledge by providing quick access to insights and knowledge, driving higher productivity and smarter business decisions. Even though it's only been a few months since general availability, it’s been amazing to talk to customers who are using agents in so many unique ways – from making safety information available quickly to front line workers to gaining new insights from digitized research records. I was inspired by the creativity of our SharePoint community in the recent SharePoint Hackathon – be sure to check out the finalists in the “Most Creative Use of agents built in SharePoint” category! Over the next several months, we’re excited to continue to invest in the user experience and response quality of agents built in SharePoint. Expect to see agents built in SharePoint in Copilot Chat, stronger integration with Teams, and deeper monitoring and analytics capabilities - all designed to help anyone get started quickly with AI on their content. With the growing usage of agents, robust governance is crucial to maintain data security, compliance, and optimal usage. Agents built in SharePoint have built-in governance controls to help organizations manage their creation, access, and usage effectively. Read on to discover best practices in managing agents built in SharePoint and how effective governance can enhance your organization's efficiency. Need more guidance? Microsoft Learn has all the details on agents built in SharePoint governance. Short on time? Check out this short video outlining agent built in SharePoint governance. How are agents built in SharePoint governed? Agents built in SharePoint are represented as .agent files in each site's document library or the Copilots folder. As such, site permissions define who can access or edit .agents on a particular site. The .agent file can be grounded to specific SharePoint sites, folders, and files and responds to inquiries based on the askers’ permissions. 1: A .agent is managed as a file with the ability to delete, copy, and control access Site permissions can be used to control both access to the knowledge of the agent and the agent itself. Microsoft Purview provides a scaled lens to help look at .agent activity across a tenant and multiple sites. Where to implement controls Who takes the action Actions to be taken SharePoint admin center Admins Limit access to a site with overshared content and further control accidental content discovery. Find more details in this article. License service plans Admins Edit service plans under the Microsoft 365 Copilot license to enable or block certain users from using Copilot experiences in OneDrive and SharePoint. Site permissions Site owners Set permissions on the SharePoint site to indicate who can access or create files, including agents, using site permissions. Limit site access to a specific group by setting up a Microsoft 365 group, setting the site as private (team sites only), and controlling group membership. Agent picker Site owners Designate specific agents on a site as ‘approved’ via the agent picker. Approved agents always appear in the top section of the agent picker. See how it’s done in this article. .agent file permissions Site members with edit permissions Set permissions on the .agent file to indicate who can access or edit the agent. How can admins monitor usage? Administrators have a few ways to monitor the usage of the agents that are created by their site owners and site members. Site owners and site members can check file statistics on any .agent file they have permissions to view, including views and unique viewers. To find files for a specific agent, they can search using the agent's name (e.g. *.agent). They will only see the agents they have permission to view. Learn more about viewing agent usage with File Statistics. As a site owner, you can also view popular files used on your sites via the site usage analytics page, including popular agent files as well as other content. Learn how to access site usage analytics. SharePoint and global admins can get a summary of the number of agents on sites created in a specified time period through the Tenant-wide usage report available in SharePoint Advanced Management. These reports will soon be visualized on the Agent Insights reports, but you can get started now with the Start-SPOCopilotAgentInsightsReport and Get-SPOCopilotAgentInsightsReport cmdlets. 2: Sample agent built in SharePoint report PowerShell output Compliance and global admins can see agent usage details, including which users interacted with the agent, as well as where and when the interaction took place using Purview .agent audit log. Audit records also include references to files, sites, or other resources that Copilot and AI applications accessed to generate responses to user prompts. 3: Sample audit log on Purview. It is our priority to deliver even richer analytics across Copilot Analytics dashboard (480726), Microsoft 365 Admin Center (480729), SharePoint Online (480725), and SharePoint Advanced Management (486861) in the coming months. What are the options for managing costs of agents built in SharePoint? Agents built in SharePoint can be utilized under two billing models, offering flexibility for your organization: Microsoft 365 Copilot licensed users: Creating, reasonable use, and sharing agents built in SharePoint are included as a feature within the Microsoft 365 Copilot license. Consumption-based pricing for non-Microsoft 365 Copilot users: For users without a Microsoft 365 Copilot license, consumption-based pricing enables the ability to only pay for the messages consumed. Starting April 1, 2025, the cost of an interaction with an agent built in SharePoint will be reduced and consume twelve (12) messages, so customers will be billed at $0.12 per interaction with agents built in SharePoint. Learn more about consumption-based pricing for agents built in SharePoint in this article. The two billing models are not mutually exclusive and can both be implemented in the same organization. Coming soon, for those leveraging the consumption-based option, organizations will be able to set up departmental billing and apply budget limits at a tenant level [Roadmap ID not yet available, check back here soon]. Departmental billing allows organizations to manage their costs effectively by providing the ability to create multiple billing policies that can be used for different departments. This enables better financial management and cost allocation across different areas within an organization. Budget allow organizations to set a maximum spending limit for the entire tenant, ensuring that the organization does not exceed its budget and avoids unexpected charges. In the meantime, learn more about monitoring consumption rates of agents built in SharePoint and creating budgets in Microsoft Cost Management in this article. More granular controls for SharePoint admins are being explored to provide greater flexibility at the site or department level for configuration based on specific use cases. Stay tuned to your message center for updates on future billing controls. How can admins disable agents built in SharePoint? As an admin, you’re familiar with using Restricted Content Discovery to protect SharePoint sites that have the highest risk of oversharing or require accurate permissions. Agents built in SharePoint follow this policy by removing the Copilot icon from the suite navigation bar and removing this site from being added as a knowledge source for all agents built in SharePoint. Users won’t have access to use the ready-made agent, create new agents on the site, or use that site’s content in any other agent built in SharePoint. Because agents built in SharePoint are a .agent file, removing a specific agent built in SharePoint is as simple as deleting the .agent file or changing its sharing permissions. Additionally, admins can use the SharePoint Online Management Shell command to manage trial access to agents built in SharePoint. What enhancements are coming? Right now, we’re focused on implementing more granular billing controls, advanced analytics, and further enhancing the collaboration experience with agents built in SharePoint. Here are some roadmap features to keep an eye out for: Monitoring and analytics Ability to view agent usage stats per site on source files citations (via SharePoint Online) - 480725 Ability to view agent usage statistics across all SharePoint sites (via Microsoft 365 Admin Center) - 480729 Ability to view agent insights for SharePoint Administrators (via SharePoint Advanced Management) - 486861 Ability to view agent analytics on Microsoft Viva Insights (Copilot Analytics Dashboard) - 480726 Billing Ability to set up departmental billing and apply budget limits – [Roadmap ID not yet available, check back here soon] Agents built in SharePoint in Teams Ability to use agents built in SharePoint in Teams mobile group chats and meetings – 481823 Ability to chat one-on-one with agents built in SharePoint in Teams chat - 481825 Ability to use agents built in SharePoint in Teams channels - 481822 Ability to add multiple agents built in SharePoint in Teams chats and meetings - 481826 Ability to access agents built in SharePoint from the Teams app store - 481824 Other capabilities Ability to use agents built in SharePoint in Copilot Chat – [Roadmap ID not yet available, check back here soon] Ability to manage agents built in SharePoint as shared apps in the Integrated apps section of the Microsoft 365 admin center - 487857 Ability to for site page authors to add agents built in SharePoint using an agent web part, enabling end users to interact with agents built in SharePoint directly from the site pages - 481512 Ability to allow files from OneDrive as a grounding source - 480728 In summary In introducing agents built in SharePoint, we aimed to solve the most fundamental, age-old business challenge: Get the right information to the right people at the right time to make the greatest impact on the customer. To fully leverage the value of these agents, consistent content management processes are essential for maintaining policy, security, and compliance. As you implement the best practices outlined here, please share your questions and feedback. We’re listening and committed to continuous improvement. Stay tuned for the exciting features we have on our roadmap! I look forward to sharing more information in the coming weeks on additional capabilities to help your organization surface, share, and act on content. Don't forget, agent built in SharePoint promotion ends June 30, 2025 An agent built in SharePoint promotion is currently available, which provides any organization with at least 50 Microsoft 365 Copilot licenses to receive 10,000 queries monthly for non-licensed users to consume. To read more about our limited time promotion, please refer to this blog. Explore deeper with MS Learn Optimizing content for Microsoft 365 Copilot and agents built in SharePoint Microsoft 365 Copilot - best practices with SharePoint Optimize SharePoint Content Retrieval in Your Agent Get ready for Microsoft 365 Copilot with SharePoint Advanced Management Billing Microsoft 365 pay-as-you-go pricing Get started with agents built in SharePoint Set up agents built in SharePoint for pay-as-you-go billing Governance controls Manage access to agents built in SharePoint Manage agents for Microsoft 365 Copilot Restrict SharePoint site access Restrict discovery of SharePoint sites and content Admin center site permissions reference Learn about data loss prevention Create and manage insider risk management policies Learn about Microsoft Purview | Microsoft Learn Trial access Manage trial access to agents built in SharePoint with PowerShell Analytics Monitor agent built in SharePoint UsageConsumption-based pricing for agents built in SharePoint
Learn more about the pay-as-you-go pricing model as it relates to SharePoint agents in Microsoft 365. Last month, we introduced consumption-based pricing for SharePoint agents. This new billing model offers greater flexibility for organizations looking to start using SharePoint agents. The pay-as-you-go (PAYGO) meter enables customers to pay only for the messages they consume, providing an alternative to a per user/per month license. This model is designed to accommodate varying usage patterns, making it ideal for businesses with fluctuating demands.SharePoint: Using agents, AI-powered authoring, and automation, for high impact content management
With over 2 billion files added and 2 million sites created per day, SharePoint is the world’s most powerful and flexible content management platform. SharePoint allows you to create stunning intranets, orchestrate powerful workflows and develop business-critical applications, while also powering a breadth of innovations across Microsoft 365 in Teams, OneDrive, and Copilot. The SharePoint event today showcased an exciting breadth of innovations across SharePoint. With these innovations, we believe SharePoint is the best platform for managing content for AI, and the best application for using AI to achieve high impact business outcomes. The innovations shown today span three key areas – Agents built in SharePoint: create and manage AI experts for your SharePoint content with just a few clicks. AI-powered authoring for stunning intranets: use AI to easily create beautiful looking intranet sites using the best of what the web has to offer. Automation for streamlining business workflows: automate critical content-based business processes with AI. Visit the new event microsite on adoption.microsoft.com | Access all new videos, adoption resources, hackathon details, and more: https://aka.ms/SharePointEvent/Adoption https://aka.ms/SharePointEvent/Adoption. Agents built in SharePoint: AI experts for every user At Microsoft Ignite 2024, we announced the general availability of agents built in SharePoint. These agents are tailored assistants scoped to specific SharePoint sites and content, becoming your subject matter experts working on behalf of a person, team, or organization to handle simple tasks or more complex business processes. Every SharePoint site now includes an agent grounded to that site’s data ready for immediate use. With just a few clicks users can easily create their own custom agents with specialized skills scoped to their specific SharePoint files and folders. And of course, agents adhere to existing SharePoint content permissions and governance polices, ensuring your data and content are used in a safe and secure manner. We see our customers using agents today for a range of scenarios such as onboarding, product support, planning and more. Amey is just one such customer who is using agents built in SharePoint to get the most out of their content and knowledge real estate on SharePoint. AI-powered authoring: Create and communicate with AI. Today you saw a range of capabilities that allow you to build SharePoint sites that look better than ever. With improvements like flexible layouts, design ideas, co-authoring, and Copilot throughout the experience, this represents a huge step forward for SharePoint’s UX capabilities. Creating high quality, engaging content on SharePoint has never been easier. Creating with Copilot With the new "create with Copilot" feature you can either use a prompt or use a selection of templates to create an engaging page, grounded in the content of your choosing, in minutes. This allows you to spend less time on the mechanics of creating the page and instead focus on the core message and content to maximize engagement and impact. Using Microsoft 365 Copilot in SharePoint to help create and design the sites you want with ease, and assistance. Design ideas: Augment creativity with AI. Design Ideas leverages your content and provides several professionally designed suggestions, automatically taking your content-specific requirements into account. You can easily invoke Design Ideas with just the click of a single button and in seconds, transform your sections into user-ready content. You can even use Design Ideas starting with blank sections or plain blocks of text! Design Ideas in the right pane of a SharePoint page showcasing different suggestions. Flexible sections: Build unconstrained For the longest time ever, SharePoint restricted you to building within the three columns framework. We heard your feedback - with Flexible sections, you now have access to all 12 columns on the SharePoint canvas! Move images, text, and all your other favorite web parts around with fine control, and freely resize them in an easy, intuitive manner. And with AI-based authoring features like Design Ideas, it allows you to take full advantage of Flexible sections to provide the best possible layout recommendations for your content. 12 column canvas with Flexible Sections on a SharePoint page. These innovations and more have been rolling out to customers over the past several months. See how customers such as Avanade are using these capabilities to create engaging and beautiful content, and how Takeda sees a future with the latest innovations. AI and automation for streamlining your work Billions of pieces of content are added to SharePoint each day relevant to both, small team collaborations, and broad company-wide initiatives. This puts SharePoint in the middle of business processes both big and small. From out of the box simple approvals and automation, to site, doclib, and list templates and all the way to Power Platform integration – Automation in SharePoint spans the continuum of business processes to get work done faster and at higher quality. As just one example, over 3 billion Power Automate flows run against SharePoint every week. In this next phase of innovation, we are excited to share more about how automation and AI integrate together. Enhance business processes with AI Autofill is one feature that enriches content by extracting and generating structured metadata at scale – increasing the value of your content real estate. Using a natural language prompt you can describe the metadata you need, easily classifying, extracting, or generating new content as metadata. This will automate the process of new and modified files, saving you time and enhancing your business processes. Price change updates As part of our commitment to make advanced AI accessible to everyone, we are also excited to announce that SharePoint Autofill pricing has adjusted from $0.05 per page to $0.005 per page starting in March 2025! Learn more about SharePoint pay-as-you-go services. Next steps We are excited to announce the next SharePoint Hackathon - and invite you, our customers, partners, and MVPs, to craft experiences using AI and the latest SharePoint features. See more details and register here! SharePoint Hackathon - Share your designs and engage with likeminded makers: https://aka.ms/SharePointHackathon. And finally, I personally invite you all to attend the Microsoft 365 Community Conference (May 6-8, 2025) in Las Vegas. We’re showcasing the latest news and best practices for SharePoint and M365 with leaders, product makers, partners, and MVPs. We can’t wait to hear more about how you put Microsoft 365 to work in your organization. Thank you! Learn more and explore! To skill up your SharePoint IQ even further – review the full event + AMA, visit our new microsite, register for the hackathon, watch our new, in-depth SharePoint learning series videos from our incredible product team members: "SharePoint: From concept to creation to impact + Live AMA" New SharePoint Event microsite on adoption.microsoft.com SharePoint Hackathon + upcoming webinar series YouTube playlist of all 17 new video assets (Main event, learning series, customer voices, and upcoming hackathon webinars) 5-part SharePoint learning series SharePoint customer stories: Amey, Takeda, and Avanade The trust and feedback from you all, the SharePoint community, developers, customers and MVPs have helped us evolve SharePoint to be the best content cloud solution in the world. Thank you! Related resources Getting started with SharePoint is a breeze! Check out the latest tutorial on building a SharePoint site. NEW agents built in SharePoint adoption guide (adoption.microsoft.com) Agents built in SharePoint (adoption.microsoft.com) Subscribe to the SharePoint community blog Add and upvote feature request: SharePoint Feedback PortalSMicrosoft 365 Community Conference: A Beacon for Builders, Innovators, and Icons of Intelligent Work
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 your career (and business) even further. With over 200 sessions, workshops, keynotes, and AMAs, you’ll learn directly from the experts and product-makers who are reimagining what’s possible in the workplace. Conference Details Join us in Las Vegas April 21-23. 2026 for the premier Microsoft 365 community event. We want to help you get the most out of the tools you use every day, so we’re bringing back the conference you know and love—with even more opportunities to learn, connect, and level up. Here’s what you can expect: Meet one-on-one with the people who create Microsoft products—ask questions, share feedback, and discover real-world solutions Explore Microsoft’s latest product updates and learn about what’s on the horizon Build and sharpen skills you can use immediately to be more productive, creative, and collaborative with the Microsoft tools you use every day Grow your network, dive deep, and have fun with the best community in tech How to Register Register today and get ready to transform the way you work. Save $150 with our exclusive customer code SAVE150. https://aka.ms/M365ConfWebsite Explore Sessions and Workshops There’s plenty of breadth—and depth—to the learning opportunities at the Microsoft 365 Community Conference. No matter your role or experience level, we've got something for everyone! https://aka.ms/M365ConfSessionsWebPage Meet the Speakers Our lineup of speakers includes some of the brightest minds behind the most powerful Microsoft innovations. You’ll hear from experts like: Jeff Teper | President, Collaborative Apps and Platforms Charles Lamanna | President, Business Apps and Agents Vasu Jakkal | Corporate Vice President, Microsoft Security Business Rohan Kumar | Corporate Vice President, Microsoft Security, Purview & Trust The Microsoft 365 Community Conference is more than an event. It’s the gateway to what’s next for your career, community, team, customers, and business—and for work itself. Claim your front-row seat to the future of work today!
