The ask, update some JSON column formatting. Someone reworked a Microsoft sample snippet and added a clickable icon to their SharePoint Online document library, but the icon is visible for all library items. For their project, the icon needs to only be available for specific items, not all folders or file types. Figure 1 - … Continue reading Formulas: SharePoint Online | JSON Formatting – Conditional Column ‘Display’
JSON
SharePoint Online | Column Links to Power Apps: JSON for Prod + NonProd
The ask, suggest improvements to an earlier JSON snippet. A Power Platform maker wanted to easily navigate SharePoint Online (SPO) users to their Power Apps solution, so they opted to create a dynamic link using JSON list column formatting. The result, a clickable icon with the HREF path built using an array and the SPO … Continue reading SharePoint Online | Column Links to Power Apps: JSON for Prod + NonProd
SharePoint Online: JSON Column Formatting | Link to Power Apps
The ask, create a dynamic link from a SharePoint Online (SPO) document library, navigating end-users to a Power Apps canvas app. This app expects "deal_id" as a parameter, Param(), which would be the id of the library item. Is it possible? Yes. Is it complicated? No. SPO libraries, which inherit from lists, are relatively easy … Continue reading SharePoint Online: JSON Column Formatting | Link to Power Apps
SharePoint Online: JSON Formatting | Hide ‘Add shortcut to OneDrive’ Button
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
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
Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API - Part I used the Microsoft batch example as a guide, but their example created a folder in my [OneDrive for Business] account. Instead, I wanted to target a [SharePoint Online] site. And to specify which SPO site, the API requires the site ID... FYI, the Graph API site search … Continue reading Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API – Part I
Microsoft's Graph is a RESTful web API to interact with Office 365 services. Although still being developed, this currently includes CRUD operations for, but not limited to: SharePoint OnlineOneDrive for BusinessOutlookMicrosoft TeamsExcel Many of these REST requests are well documented with examples, but Microsoft examples won't address every scenario... Example: Use the Microsoft Graph Explorer … Continue reading Batching w/ Microsoft Graph API – Part I
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'); 