Power Query is Microsoft's data transformation and presentation engine. Thanks to it, services like Microsoft Power BI can focus on data visualization and let Power Query ETL the disparate data sources instead. Though, highlighting one often overlooked data source, Power Query can actually ETL data from PDFs. Similar to importing data from a CSV, select … Continue reading Power BI: Power Query | Import PDF Tables
Quotes
Power Query: Overview
The capabilities of the Power Platform wowed many organizations. Especially Power BI and its ability to extract, transform, and load (ETL) datasets from dozens of disparate data sources. At the same time, Microsoft Dataverse, the low-code data storage offering of the Power Platform, also supports ETL of disparate data sources. Though, this isn't unique to … Continue reading Power Query: Overview
OneDrive: Hidden List (SharePoint Home Cache List – Part II)
The series has finally reached a conclusion. The final list, SharePointHomeCacheList, had so many items that it was divided into two posts. Part I spotlighted 3 list items and Part II will cover two additional items... E.g., export of list object in PowerShell ISE. Get target items $api = "/sites/$($siteGuid)/lists/$($listGuid)/items" $api += "?expand=fields" $lst1 = … Continue reading OneDrive: Hidden List (SharePoint Home Cache List – Part II)
OneDrive: Hidden List (SharePoint Home Cache List)
Auditing [OneDrive for Business] sites with PowerShell and the Microsoft Graph API uncovered several hidden lists. The SharePointHomeCacheList is one of these lists, but it offers more information than the previously discussed lists. Continuing the trend of examination: Create script variables. [System.String] $endUserAccount = "charles@contoso.com" $endUserAccount = $endUserAccount.Replace("@", "_").Replace(".", "_") [System.String] $tenantName = "contoso" [System.String] … Continue reading OneDrive: Hidden List (SharePoint Home Cache List)
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
OneDrive: Hidden List (Recent Lists)
Another hidden list found, so onward to part 5 of the series... This might be a new-ish container, but it logs recently created [SharePoint Online] lists by a person so it gets audited: Create script variables. [System.String] $endUserAccount = "charles@contoso.com" $endUserAccount = $endUserAccount.Replace("@", "_").Replace(".", "_") [System.String] $tenantName = "contoso" [System.String] $requestAPI = "" [System.String] $siteGuid … Continue reading OneDrive: Hidden List (Recent Lists)
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 Apps: Cascading Columns (custom)
Cascading columns are important to many applications, but often require custom solutions. Although the functionality is available out-of-the-box in Power Apps, custom solutions are still fun to build... For the uninitiated, cascading columns are essentially dropdowns that control the available selections of the next dropdown: e.g., Dropdown #1 - US StatesDropdown #2 - US CitiesDropdown … Continue reading Power Apps: Cascading Columns (custom)
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 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!
SharePoint Sites: Naming Conventions
Because of a recent initiative, I need to rename my Showcase site to Product Showcase. SharePoint (SP) site names are dynamic so I can update this through the UI... The change is simple and the update is immediate. But my site URL doesn't reflect this change. Why? Because site URLs are static... ex., SharePoint Online … Continue reading SharePoint Sites: Naming Conventions
Thank you, Retention Policy!
End-users delete a lot of content. So many "accidental" deletions... Anyway, they can delete content and often enough, they delete the wrong file! *gasp* Note: Another lengthy post, but w/ pictures... Deleted files go to the Recycle bin. The process is routine at this point... SharePoint Online files can be restored from the site's Recycle … Continue reading Thank you, Retention Policy!
Ticketing System via SPO w/ MS Teams and Power Automate
ServiceNow is great at what it does and this is not a co-sign. But I do enjoy being able to email the system and it generate a ticket on my behalf. However, some people would rather not use ServiceNow. Maybe the UI isn't what they're looking for. Or maybe they would rather build something using … Continue reading Ticketing System via SPO w/ MS Teams and Power Automate
console.log('Charles'); 