AI-powered intranet solution built on SharePoint - Fresh Intranet - SharePoint Partner Showcase
We are excited to start a new blog post series focused on the different partner offerings around SharePoint in Microsoft 365. In this first post, we focus on Advania’s Fresh Intranet – an AI powered intranet solution built natively on Microsoft SharePoint.Getting Started with SharePoint Online for Collaboration
In today’s fast-paced world of hybrid work and remote teams, organizations need reliable platforms that promote communication, transparency, and productivity. SharePoint Online, the cloud-based version of Microsoft’s SharePoint platform, is one of the most powerful tools for this purpose. It enables teams to create centralized spaces for file sharing, project management, document collaboration, and intranet communication. In this guide, we’ll explore how to get started with SharePoint Online for collaboration — from understanding its core benefits to setting up your first team site, managing permissions, and adopting best practices to ensure long-term success. https://dellenny.com/getting-started-with-sharepoint-online-for-collaboration/
Unified Company Calendar for Mixed Microsoft 365 and Non-365 Users – 2025
Seeking a Shared Calendar Solution for Mixed Microsoft 365 and Non-365 Users I’m working on a solution to create a shared company calendar that everyone in our organization can view, while keeping editing permissions limited to a few selected individuals. The challenge: Some of our team members do not use Microsoft 365, and I’d like them to still be able to subscribe to or view the calendar and receive updates. Ideally, this should work without requiring full Microsoft accounts. I initially considered using an ICS-based calendar, but it seems Microsoft 365 Group calendars don’t support sharing via ICS links. I also explored creating a Group calendar as suggested in other threads, but ran into issues making it accessible to external users or those without 365 accounts. For context, I’m a Global Admin, so I have full access to configure settings in the Microsoft 365 Admin Center and Exchange if needed. We’re a small business, and our main goal is to have a centralized calendar for vacation schedules and company-wide events. It should be simple to access and maintain, with a focus on collaboration and accessibility across the board. What I’m looking for: A calendar that’s viewable by all, including non-M365 users Editable only by a few delegated team members Compatible with Microsoft 365, but not dependent on it for basic access Any tools, workarounds, or best practices that have worked for others in similar hybrid environmentsUsing the SharePoint Site Attestation Policy
The site attestation policy is designed to require site owners to make a positive statement that the settings of their site, including its current membership, are accurate. The idea is that requiring site owners to attest that their site is still needed will force people to decide whether sites are still in active use and should be kept online. If not, the policy can move the sites into Microsoft 365 Archive. https://office365itpros.com/2025/10/30/site-attestation-policy/Query failure in Windows 11
Hi I just had a new computer at work, and changed from windows 10 to windows 11. I have a query, which compare 2 tables, and add rows in table2 that dont exits in table1. This has been working for years, but now it, only sometimes, double all the rows. INSERT INTO MPS Columns from Table2 (Access linked to sharepoint) SELECT MPS2. Columns from table1 FROM MPS2 WHERE not exists (Select 1 from MPS WHERE MPS.[MPSid] = MPS2.[MPSid]); It compares a unik field MPSid It doubles the rows sometimes, and the MPSid is the same, in the doubled rows Has something changed, or is there a workaround? Best Regards TonyLeveraging SharePoint for Performance Tracking Monitoring Team and Project Progress
SharePoint is more than a document management system; it’s a comprehensive platform that facilitates real-time tracking and collaboration. Here’s why it excels in performance tracking: https://dellenny.com/leveraging-sharepoint-for-performance-tracking-monitoring-team-and-project-progress/
Office 365 Business Premium + GoDaddy Hosting
Hi, Does office 365 + godaddy give you office 365 app hosting? I was hoping to have a public sharepoint, delve, and yammer website connected to different subdomains e.g. http://www.mydomain.com, blog.mydomain.com, social.mydomain.com etc. What apps on office 365 are linked to godaddy hosting? Or is it just completely separate hosting that has no link to office 365 apps and just bundles email support? Also what is the discount offered to office 365 subscribers on godaddy? Ideally I would to have Windows unlimited website hosting. Thanks, JebbCreate PowerApps Application with On-premises SQL Server
PowerApps is a one of the powerful low code applications from Microsoft, which helps to develop millions of applications within a minute. Only platform which allows technical and non-technical to implement application with their requirements. Power platforms can be developed to receive data from different data sources like Excel, SQL server, share point resources and data from different cloud storages like Google, OneDrive, etc. Considering OnPrem data sources we do traditional coding to connect the application with the data source. But here we have a possibility to develop a PowerApps and receive data from On Prem SQL server. In this article I will show you how to connect OnPrem SQL to PowerApps. Pre-Requites 1) OnPrem SQL Server 2) PowerApps Subscription 3) On-Premises Data Gateway 4) Internet Connection On-Premises Data gateway for Power Apps On-Premises gateway is a bridge which provides most secure communication in between local sources to cloud applications. To know and learn more about On-Premises data gate way: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/gateway-reference SQL Server on Windows 10 Machine I have SQL database installed on my Windows 10 machine, which is a local machine with the active internet connection. If you are new to SQL server installation and configure, I have shared some other posts which will show you how to install and configure SQL server 2022 in your test environment. Download SQL Server 2022: https://info.microsoft.com/ww-landing-sql-server-2022.html?culture=en-us&country=us To Confirm your Installed Version: SELECT @@VERSION I have created a table named Demo Data and inserted some sample data Let’s configure the On-Premises Data Gateway To Download the On-Premises Data Gateway for PowerApps please download the Gateway from below link — https://powerapps.microsoft.com/en-us/downloads/. Once it’s downloaded install it to the local machine, it will take some time to install. When installation succeed it will prompt a dialog box to enter the Microsoft account details. Use the same account which you used to create PowerApps. In the next step create a Gateway with the valid security and recovery key. Here I named my gateway as DEMOPOWERAPPS Create Configure button to apply the configurations and close the dialog box, now it’s done. Now it’s time to build the app in PowerApps Go to PowerApps portal to make the app — make.powerapps.com I am going to create the PowerApps with SQL data source Click the SQL and add the New Connection and select the connection source as SQL database (SQL Server). In the authentication type select SQL Server Authentication from the drop-down list. In the source selection pane select Connect using on-premises data gateway as data source for SQL server SQL Server Name — Windows 10 Local PC Name SQL Database Name- POWERAPPSDEMO Username- demouser Password-[Your SQL User Password Here] In the bottom you need to select the installed gateway, here it will show the gateways you installed with the Microsoft account which you used to create the PowerApps. Here my installed DEMOPOWERAPPS gateway is listed and it’s showing, if your gateway is not listed, please refresh the gateway list. Once you select the correct gateway click create to link the data source to PowerApps. It will show the available tables once the gateway connection is succeeded, here my table DemoData is showing. I am going to use the DemoData table to connect with PowerApps. In case in the same database if you want to change or create new table you can either create it from here or choose different one. Click connect to link the On Prem database with PowerApps, It’s done and app is automatically created now. Without doing any additional changes in the app I will see the preview of the app to check to see whether it’s communicating correctly with the SQL database available at my laptop. The data which I entered manually using SQL commands are appearing here, it means it’s perfectly connected with the on prem SQL database. By adding an edit form in the PowerApps you can be able to insert the data from PowerApps to On Prem SQL Server. Just try this by yourself and let me know if you have any issues in connect On Prem SQL server to Power apps. Happy Coding!!
