PowerApps

The PowerApps Distinct function helps to remove duplicate values from a given dataset or column and returns only the unique values. This can be useful when you want to present a list of unique items to users or when you need to perform calculations or analysis based on distinct values. PowerApps Distinct Function Syntax Input […]

You want to know, how to convert a text to number in PowerApps? Use the Value Function like this: If this is all you need to know, have a nice day! The rest of the article describes, how to convert text to number for different international number formats, which will texts work and which won’t

List of all user attributes you can retrieve with PowerApps. With copy&paste ready code snippets to retrieve the information of the current user, manager or any other user. PowerApps User Function The User function provides access to the following user information for the currently logged in user: Full name Email Image Syntax Return Value For

The PowerApps ForAll function confused me in the beginning. Coming from a programming background I was expecting something like a classic for loop. But ForAll is a little different! The most important aspects I needed to understand: ForAll is not a classic for loop Iike in JavaScript, C# or Java ForAll is a function with

The PowerApps coalesce function is one of the less common functions. One reason for this might be, that you can do everything that the coalesce function does with if statements. So why learn it all? The function helps you to write less code which is more elegant. For instance, the following If statement can be

There are two scenarios where you might want to refresh a data source: The structure of the data source has changed For instance there is a new column, a data type has changed, names have changed or column has been deleted. We’ll show you how to refresh your PowerApp data source, so you can work

I wanted to understand how to work with dates in PowerApps. So I challenged myself to try out all PowerApps date functions. I wanted to have an overview of what can be achieved and how it can be achieved. In this post you find short explanations of every date related function in PowerApps. I always

PowerApps IsEmpty and IsBlank were very confusing to me when I started with PowerApps. I was used to use the terms blank and empty with different meanings from my progamming background. This article should clarify the differences and explain when to use which function. Before we go into details. If there should be one lesson

PowerApps in operator and exactin operator are used to check whether a collection contains an item or not. The expression evaluates to a boolean value (true or false). Left to the operator is the searched item and right to the operator is the collection where the item is potentially contained. The only difference between the

As soon as you offer the first delete function, you might want a ‘Are you sure?’ popup. This guide shows you how to create a modal confirmation dialog with PowerApps. We won’t do a pretty dialog. This is an example to teach the approach. Feel free to design the dialog to your needs. Done. Start