Mastering the Power Apps Search Function for Efficient Data Filtering

Are you familiar with how to effectively use the Search function in Power Apps? In this tutorial, Brian Knight demonstrates how to utilize the Search function to query data sources and retrieve only the specific data you need. Organizations today are increasingly migrating to the cloud, and Microsoft Azure stands out as a leading platform… Read More

Discover the Powerful Multilingual Feature in Power Apps You Didn’t Know About

In this insightful video, Andrew Perez and Brian Knight reveal an incredible multilingual capability within Power Apps that can transform your app development process. Learn how to effortlessly translate your Power Apps into various languages—including Spanish and Arabic—whether you’re working with model-driven or canvas apps. This tutorial will guide you through enabling translations to ensure… Read More

Overview of Visual Studio 2019 Business Intelligence Design Tool Extensions

Microsoft recently launched Visual Studio 2019, bringing some changes to how Business Intelligence (BI) design tools are installed and managed. In this article, Bob Rubocki explains the updated process for installing the BI Designer tools, which were previously part of SQL Server Data Tools (SSDT), and how these changes affect BI developers. Visual Studio 2019… Read More

Four Powerful Yet Underused Power FX Formulas You Should Know

In this article, Nate Halliwell dives into some highly effective but often overlooked Power FX formulas that can elevate your Canvas app development. Whether you’re a beginner or an experienced maker, adding these formulas—IFERROR, SUBSTITUTE, COALESCE, and SWITCH—to your Power FX toolkit will greatly improve your app’s functionality and user experience. Creating a smooth and… Read More

Mastering the Sum Function and Collections in Power Apps: From Basic to Advanced Techniques

As a former Algebra and Algebra 2 instructor, I frequently worked with summing numbers—something we often overlook in Power Apps. Summing numerical values isn’t just essential for math teachers, Power BI analysts, or Excel users; it’s equally powerful within Power Apps to enhance your app’s data handling and interactivity. Step-by-Step Guide to Summing a Column… Read More

Essential Guide to Building a Date Table for Data Models and Warehouses

Creating a date table is a common need when designing data warehouses or building data models in tools like Excel’s Power Pivot or SQL Server Analysis Services. A well-structured date table allows you to efficiently analyze and aggregate data across various time periods. We recommend a method using a Common Table Expression (CTE) to generate… Read More

Mastering Advanced Filtering Techniques in Power Apps with Multiple Dropdowns

In my previous blog and video tutorial, I showed how to filter gallery records using a single dropdown control linked to a distinct column in your data source. This simple yet effective method helps users narrow down the displayed data easily. If you missed it, check out the video below. Mastering Advanced Filtering in Power… Read More

Simplifying Record Filtering in Power Apps

During numerous Power Apps training sessions, one of the most frequently asked questions is whether Power Apps supports filtering the records that end-users can see. The straightforward answer is yes! However, the filtering options are extensive and varied. You can implement security filters to restrict data access, allow users to select their own filters within… Read More

How to Send SMS Messages Using Power Apps

Text messaging continues to be one of the most reliable and engaging forms of communication for businesses. For nearly a decade, SMS has delivered higher open and response rates compared to other digital channels. In today’s fast-paced mobile-first world, organizations are now seeking ways to leverage text communication within their existing Microsoft Power Platform solutions.… Read More

Essential Testing Types in Data-Centric Development

Testing has long been recognized as a fundamental pillar of quality assurance in software development. It ensures that code behaves according to specifications, maintains expected functionality after changes, and prevents new code from disrupting existing features. Proper testing also verifies that the software manages various inputs correctly, including exceptions and invalid data. However, in the… Read More

Comprehensive Guide to Managed Metadata in SharePoint

In a detailed instructional video, Jonathon Silva from our site explores the powerful features of managed metadata columns in SharePoint. Silva highlights how managed metadata improves data organization and user experience compared to standard choice columns. He provides a clear, step-by-step walkthrough on setting up and using managed metadata columns effectively within your SharePoint environment.… Read More

How to Automatically Refresh Power Apps Data Sources Using a Timer

Power Apps makes it simple to refresh your data sources manually by clicking a refresh button. But what if you want your app to update data automatically at set intervals? In this tutorial, Brian Knight explains how to configure Power Apps to refresh data sources on a timer, ideal for apps that need real-time or… Read More

Understanding Collections in PowerApps: A Beginner’s Guide

Are you familiar with using collections in PowerApps? Collections act as in-memory tables that you can store temporarily within your app. They are highly versatile and essential for managing data offline, manipulating datasets, or batching updates to your primary data source like SQL Server. In this tutorial, we’ll explore how to create, manage, and utilize… Read More

Step-by-Step Guide to Uploading and Querying a CSV File in Databricks

Welcome to another installment in our Azure Every Day series focusing on Databricks. If you’re new to Databricks and want to learn how to upload and query CSV files efficiently, this guide is perfect for you. For a more in-depth walkthrough, be sure to check out the video linked at the end. Before diving into… Read More

What Is Databricks Community Edition? A Beginner-Friendly Guide

If you’re exploring data science or big data analytics, chances are you’ve come across Databricks. Built on Apache Spark, Databricks is a high-performance, user-friendly platform that supports collaboration between data engineers, data scientists, and analysts. For those wanting to explore it without cost, Databricks Community Edition offers the perfect opportunity. Explore the Power of Databricks… Read More