The ask, rethink error email recipients of a Power Platform solution. The original maker needs to transfer ongoing support to the help desk and presently, if there's an issue, the cloud flows are designed to email the maker directly. Fortunately, the solution's data source is a series of SharePoint Online (SPO) lists, so there's at … Continue reading Power Platform: SPO Data Sources + Error Emails
Data Source
Microsoft Dataverse: Virtual Tables [ Pros ]
Unfortunately, Microsoft Dataverse isn't a data storage consideration for many Power Platform makers because their organizations are already using other data sources like SQL Server, Salesforce, SharePoint Online (SPO), etc. These other data sources are well-supported, but Dataverse is the foundation of the Power Platform, so there is native integration for it in Power BI, … Continue reading Microsoft Dataverse: Virtual Tables [ Pros ]
Power BI: Power Query | Import PDF Tables
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
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
Power Platform: Data Sources | SQL Tables or Dataverse Tables
The Power Platform is Microsoft's collective of no-code/ low-code solutions. To supplement this platform, Dataverse is Microsoft's secure, no-code/ low-code data storage solution. SQL Server is still a strong contender for data storage, but leveraging it requires some mastery of SQL. Dataverse, however, stores data in tables just like SQL, but doesn't require any proficiency … Continue reading Power Platform: Data Sources | SQL Tables or Dataverse Tables
Power Apps: Canvas Apps | Data Refresh – Manual v Timed
Canvas apps are Microsoft's low-code business apps of the Power Platform, capable of interacting with data from a variety of data sources. Keeping that in mind, app makers should design their apps with data refreshes in mind because after the initial app start, users are working with copies of the loaded data, not live data. … Continue reading Power Apps: Canvas Apps | Data Refresh – Manual v Timed
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
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 Forms: Bulk Copy/ Paste Options
For today's mission, a request came in to use a Microsoft Form to receive training log submissions. Every team member is responsible for submitting their logs and time is measured in quarter hour increments. The big ask? Can the dropdown values span from 0.25 to 40? Yes, but typing that many options is needlessly time … Continue reading MS Forms: Bulk Copy/ Paste Options
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
console.log('Charles'); 