[OneDrive for Business] sites are [SharePoint Online] site collections. Because of this, the ODfB sites have hidden lists which are discoverable using scripted solutions. Another of these hidden lists track user notifications. The Microsoft Graph API is again capable of querying the list and its items for reporting... E.g., list user notification types. To begin, … Continue reading OneDrive: Hidden List (Notifications)
Uncategorized
OneDrive: Hidden List (User Activity)
[OneDrive for Business] sites are [SharePoint Online] site collections. Because of this, ODfB sites have hidden lists which are discoverable using scripted solutions. One of these hidden lists is tasked with tracking user activity. The Microsoft Graph API is again helpful to query these hidden list records for reporting... E.g., instances of user comments. To … Continue reading OneDrive: Hidden List (User Activity)
OneDrive: Hidden List (Sharing Links)
[OneDrive for Business] accounts are essentially [SharePoint Online] site collections. Because of this, ODfB sites also have several hidden lists that are discoverable with scripted solutions. One hidden list is titled Sharing Links and it keeps a record of shared items. Though the Microsoft 365 Admin center has a nice OneDrive activity report, custom solutions … Continue reading OneDrive: Hidden List (Sharing Links)
Training Session: Graph API – OneDrive vs SharePoint
Microsoft has invested heavily into their Graph API which connects with the Office 365 services. The approach of old, CSOM, not so much as of late. But that makes sense considering the services are cloud-hosted. CSOM was perfect for solutions running on the application server, but [SharePoint Online] doesn't allow this. Going forward, the Graph … Continue reading Training Session: Graph API – OneDrive vs SharePoint
Power BI: Intersect w/ Netflix Viewing Data
Recap: Visuals were built in the previous Netflix Viewing Data blog, but no formulas. Still, presenting the year-to-year viewing counts in stacked bar charts was simple enough. And the drilldowns weren't bad... Note: The Netflix viewing history export only includes the first time something is viewed, not each time it is viewed. However, today I … Continue reading Power BI: Intersect w/ Netflix Viewing Data
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
Power Automate: Parse Strings
The Power Platform is a collective of Microsoft tools natively extensible across Azure. Bundled within this collective is Power Automate, a cloud-based tool facilitating the automation of business processes... Noteworthy, Power Automate is great for empowering everyone; including none developers. Yet, it can feel restrictive to seasoned developers because things are done differently. The parsing … Continue reading Power Automate: Parse Strings
Deleting Private Channels in Microsoft Teams!
Private channels have been available in Teams for several months now. As a result, plenty of people have created plenty of private channels. Some were created accidentally and some were created for testing purposes. Either way, I've been asked to delete several of these channels... Fun fact #1: Creating a private channel in Microsoft Teams … Continue reading Deleting Private Channels in Microsoft Teams!
Microsoft Graph API – Move SPO File
The Graph API has a learning curve, but is powerful. If you're working with Office 365, then the Microsoft Graph is definitely worth exploring. Note: You can test and work w/ the APIs via the Graph Explorer. https://developer.microsoft.com/en-us/graph/graph-explorer Task / Goal: Move a PowerPoint file from the "Marketing" folder in a source library to the … Continue reading Microsoft Graph API – Move SPO File
Power BI: Visualizations w/ Netflix Viewing Data
"Power BI is a business analytics service that delivers insights to enable fast, informed decisions." - Microsoft One third of the Microsoft Power Platform, Power BI quickly transforms data into rich visuals. If you were a fan of Power Query, Power Pivot, and Power View in Excel, then this should feel familiar... To recreate this … Continue reading Power BI: Visualizations w/ Netflix Viewing Data
Microsoft Ignite 2019 – Recap
Microsoft just hosted Ignite 2019 in Orlando, FL. This was my first year attending and there was more than enough content. It's impossible to recap it all because it was impossible for me see everything: 25,000+ attendees 1,000+ sessions 300+ sponsors 200+ hands-on experiences I mean WHOA! Microsoft mission:"Empower every person and every organization on … Continue reading Microsoft Ignite 2019 – Recap
SharePoint Online: External Sharing Audit (Option. II)
I recently wrote about external sharing in SPO. If you externally share content, then you may need to audit external accounts in your tenant. Note: Your tenant must allow external sharing. The Microsoft 365 Admin Center is your first resource to audit and report these external accounts. Secondly, you can use PowerShell to audit specified … Continue reading SharePoint Online: External Sharing Audit (Option. II)
Mental Health in Tech!
I recently attended Code Camp Atlanta 2019. If you didn't attend, then set a reminder to attend next year. Why? Because learning is essential, and $10 is almost free for a day of training...There were 30+ sessions. All speakers and organizers volunteered their time on a Saturday in service of the tech community. Topics covered … Continue reading Mental Health in Tech!
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'); 