SharePoint Online [SPO] is a modern, cloud-based service accessible from any modern browser. Emphasis on modern service and modern browser. Still, because of many legacy business processes, end-users flock to sync their SPO files the first chance they get. They ultimately achieve the same purpose, but there are actually two ways they can sync their … Continue reading SharePoint Online: JSON Formatting | Hide ‘Add shortcut to OneDrive’ Button
SharePoint Online
SharePoint: Access Issues | Authentication vs. Authorization
SharePoint access issues are sometimes tricky. Simplifying things though, access issues ultimately fall into two categories: authentication or authorization. Authentication asks a very simple question. Are they permitted/ allowed to access the content? If yes, then they can open SharePoint. Otherwise, they get an access denied screen. Figure 1 - Account not authorized, but able … Continue reading SharePoint: Access Issues | Authentication vs. Authorization
SharePoint: Prevent Folder Move
SharePoint is a collaboration platform that also encourages self-governance. Sure, the IT department could deploy and manage all things SharePoint, but that isn't always best. In an ideal, balanced partnership, IT would just handle the administrative tasks and empowered users would provision their own site collections, manage their own site access, and create their own … Continue reading SharePoint: Prevent Folder Move
SharePoint Online: Understanding | Document Sets
Likely an oversimplification, but document sets are essentially collections of files and folders bundled together with shared metadata. A holdover from earlier versions of SharePoint Server, document sets aren't enabled by default in SharePoint Online [SPO], but can be enabled as a feature at the site collection level: Figure 1 - SharePoint Online site collection … Continue reading SharePoint Online: Understanding | Document Sets
Power Platform: Data Sources | SQL Tables or SPO Lists
The Power Platform is Microsoft's collection of low-code, citizen developer solutions. Being low-code, makers don't need coding experience to build their apps, bots, automations, and/ or dashboards. Even so, makers still need to decide where their data should ultimately live. For most people, SQL is typically the go-to data storage consideration. And honestly, SQL isn't … Continue reading Power Platform: Data Sources | SQL Tables or SPO Lists
Power Apps: Canvas App | SubmitForm() + SPOItem [Attachments w/ Permissions]
SharePoint Online lists are flexible as Power Apps canvas app data sources. Not quite as popular as SQL, but app makers can use SPO lists like database tables. One major perk of leveraging SPO lists, they're created ready to handle item attachments without makers needing to configure Azure BLOB storage. Still, there is a permission … Continue reading Power Apps: Canvas App | SubmitForm() + SPOItem [Attachments w/ Permissions]
MS Lists: Customize w/ JSON
Cost-conscious businesses typically have narrow profit margins. And because of that, they're likely hesitant to purchase too many third-party app licenses for their employees. Luckily though, if their employees are already licensed for Microsoft 365, then a handful of tech-savvy business users could build many of these apps in-house using Microsoft Lists. As the name … Continue reading MS Lists: Customize w/ JSON
Graph API: SPO List Items + Batch Delete
As previously explored, batching is the preferred and more efficient approach to processing a large volume of API requests. For every request, there is a call to the Microsoft Graph API and the accompanying response. With that in mind, things add up quickly as dozens, if not hundreds, of API requests are made. Batching bundles … Continue reading Graph API: SPO List Items + Batch Delete
Graph API: SPO Move/ Copy Targets
Microsoft 365 has a large offering of services. To script and interact with many of them, the Microsoft Graph API utilizes a central endpoint, with dozens of REST APIs, to work with files, calendars, mail, etc. Although not currently as robust as some of the legacy on-prem PowerShell modules, the Graph resources and their APIs … Continue reading Graph API: SPO Move/ Copy Targets
MS Lists: Power Automate Connectors
Microsoft Lists are powerful. Especially when they're used to organize things like project tasks, support requests, product logs, etc. But regardless of the list's purpose, lists are created for either the individual or the group. If the individual, then the list is created in that person's [OneDrive for Business] site. Otherwise, the list is saved … Continue reading MS Lists: Power Automate Connectors
MS Lists: Mail Merge Data Source
Mail merge is still a thing. Why? Because after all these years, it continues to get the job done. But with more businesses using Microsoft Lists, can mail merge still do its job? The short answer, yes. However, Microsoft Word can't connect to Microsoft Lists directly. If we open the mail merge data source dropdown, … Continue reading MS Lists: Mail Merge Data Source
Power Automate: SharePoint ODATA Filters
Microsoft Lists is growing in popularity. As the solution is augmented using Power Automate, citizen developers should know that [SharePoint Online] is the backend of Lists. With this in mind, remember that List flows are built using SPO triggers and actions. As these lists grow in size, large datasets need to be queried and iterated … Continue reading Power Automate: SharePoint ODATA Filters
Power Automate: Copy Emails + Attachments to SPO
Closing out this story, the Power Automate flow built to copy Outlook emails to [SharePoint Online] should have copied the email attachments as well. Though not every email has attachments. Tweak the flow and check for attachments, then copy when necessary... Reviewing a previous flow run, examine an export of the tempObj variable. Take note … Continue reading Power Automate: Copy Emails + Attachments to SPO
Power Automate: Copy Emails to SPO
Once upon a time there was a very special user. This user was great at their job and worked with us for many years. Throughout the years, their job responsibilities required that they catalogue and archive legal records for the business. Unfortunately, soon enough, they were ready for new career opportunities. Now, they needed to … Continue reading Power Automate: Copy Emails to SPO
SharePoint: Modern Site Architecture (Hub v. Sub)
Microsoft is encouraging organizations to embrace Modern SharePoint. With this nudging, creating sub-sites is still supported, but largely frowned upon. Though Classic SharePoint welcomes sub-sites. Modern SharePoint, not so much. Instead, Microsoft now recommends creating all sites as their own site collection, then associating sites using hub linkage... To better conceptualize the hub idea, consider … Continue reading SharePoint: Modern Site Architecture (Hub v. Sub)
console.log('Charles'); 