[SharePoint Online] sites can use [Azure AD] security groups to manage user access and permissions. Noteworthy, these security groups can be applied directly to sites, lists, and/ or items. And every security group used on the SPO site is saved to the site member list. This member list roughly functions as a site cache and … Continue reading Azure AD: SharePoint Online User Cache
SPOLists
Power Automate: SPO Item Version Delta
[SharePoint Online] is a well known document management solution. Baked into this Microsoft solution is metadata and versioning. In simplest terms, metadata is document tagging. Versioning is an audit trail of document changes - including document properties... Figure 1 - Version history of a SPO list item. Working with SPO, Power Automate has an action … Continue reading Power Automate: SPO Item Version Delta
Microsoft 365: MS Lists v SPO Lists
Microsoft Lists has been released to the wild. Is this different than SharePoint Lists? Kind of, but not really... Microsoft has a history of surfacing elements of SharePoint and creating "new" standalone solutions. Though not direct successors, but... Power Automate replaced SharePoint Designer workflows. Microsoft Forms became a substitute for SharePoint Surveys. However, things are … Continue reading Microsoft 365: MS Lists v SPO Lists
Power Automate: Populate SPO User Claims
Power Automate is the workflow engine of the Power Platform. Essentially, "Flows" access data via connectors, then perform tasks using actions. Included is a connector for [SharePoint Online] and a few dozen actions. Some actions to highlight: Get itemsUpdate item SCENARIO Remote workers are submitting travel requests and corporate has delegated an approver per state. … Continue reading Power Automate: Populate SPO User Claims
Power Apps: SPO People Picker Properties
Migrating to [Azure Active Directory] has companies correcting their local [Active Directory] structures. Considering AD was so forgiving, best practices weren't always adhered to. But an enterprise offering like AAD enforces better practices. Silver lining, this is great for custom solutions because user properties are now more consistent... How it Started... I created an overly … Continue reading Power Apps: SPO People Picker Properties
Training: SharePoint – 5000 Item Limit Threshold
### What The 5,000 items list view threshold is a limit on the number of items displayed in a single SharePoint view. This is NOT a limit on how many total items a list or library can hold. ### Why This is a performance restriction. Larger database queries require more resources and more processing. This … Continue reading Training: SharePoint – 5000 Item Limit Threshold
Power Apps: Cascading Columns (OOB)
Unlike [out-of-the-box] features, custom solutions incur a bit of technical debt. Though, OOB features often come with some nuances and quirks to be wary of... Scenario, use cascading columns to: Select a region,Select a state,Select a city, andView a dynamic list of artists. Again, SQL tables are great, but [SharePoint Online] lists are easy to … Continue reading Power Apps: Cascading Columns (OOB)
Training Session: SPO App Names – Static vs Dynamic
[SharePoint Online] apps are essential to SPO sites. The Custom List is a common app, but the Document Library app is probably the most popular. There will always be a request to host documents. But these apps require some considerations... What are these considerations? App names! Keep in mind that SPO apps have static and … Continue reading Training Session: SPO App Names – Static vs Dynamic
SPList: Simple Column Formatting
SharePoint is good platform to build on, but it continues to impress me what can be done with minimal effort. My background is programming and programmers like to build custom solutions. However, Microsoft has built so much into SharePoint that I haven't had to build any large custom solutions for quite some time. Not that … Continue reading SPList: Simple Column Formatting
console.log('Charles'); 