PowerApps Coalesce Function – Return non blank values from Shane Young

Coalesce replaces if(isblank()) and you only need to use this one for several checks and don’t need to nest it. You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Power Apps Combo Box DefaultSelectedItems from Shane Young

A great summary of how to deal with DefaultSelectedItems in a ComboBox and how to set them using a table/lookup or a manuel-created record. You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Power Apps SVG make your apps prettier and easier to use from Shane Young

Great demonstration on how to create beautiful animated “images” with SVG and a little code. I thought I would share this with you because maybe this is for one or the other. Personally I have an eye for it, but I’m more minimalist and the app has to work. You can see this video hereContinue reading “Power Apps SVG make your apps prettier and easier to use from Shane Young”

Power Apps Export data to Excel with Flow – Collections to CSV file from Shane Young

Pass a collection of PowerApps to PowerAutomate, then write that data to a CSV table and create a CSV file. This could still be quite helpful in one case or another. For example, if we want to compile different data and prepare it for an export/import, this is a good way. You can see thisContinue reading “Power Apps Export data to Excel with Flow – Collections to CSV file from Shane Young”

Power Apps Errors Function when using Patch and other data source changes from Shane Young

Very helpful guidance and explanation on how to create a simple error handling within the app. I particularly like the part where you create variable notifications. I’m a big fan of variables and don’t like the hardcoded stuff. You can see this video here on my blog because I have rated this video with 5Continue reading “Power Apps Errors Function when using Patch and other data source changes from Shane Young”

PowerApps Tracker App including Add row numbers to a gallery from Shane Young

With this formula you will save a lot of time and nerves. Because you can easily add the current row numbers to any collection (or via patch also data table). Watch this video. ForAll (XY, Collect (tempCollection, Last (FirstN( AddColumns ( DropColumns ( XY, row ), “row” , CountRows (tempCollection)+1), CountRows (tempCollection)+1)), ClearCollect(XY, tempCollection), ClearContinue reading “PowerApps Tracker App including Add row numbers to a gallery from Shane Young”

Power Apps Switch Function vs. the If function from Shane Young

What would I do without these features? I used to use nested IF functions because I didn’t know the switch function. But when is what is best? You can see this here. You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library.Continue reading “Power Apps Switch Function vs. the If function from Shane Young”

Power Apps Print directly to a printer with an API – PDFs, Labels, Barcodes, and more with Flow from Shane Young

Really great, what Shane Young shows. Printing from the PowerApp hasn’t been possible yet, but this workaround makes it possible. You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Power Apps change the app owner with PowerShell from Shane Young

Super tip to change the PowerApps Owner. Especially for apps that have been created by employees and are now used for the company. Thus, it does not matter whether the employee leaves the company -> The app thus remains owned by the company as owner. Update: u can also use PowerAutomate to change the appContinue reading “Power Apps change the app owner with PowerShell from Shane Young”

Power Apps Number Sequence function + ForAll, Concat, Date Times, and strings from Shane Young

The sequence function is explained with different examples. A must-know for all PowerAppers. 😉 Has been able to use this function several times in different scenarios and thus save a lot of time and nerves. You can see this video here on my blog because I have rated this video with 5 stars in myContinue reading “Power Apps Number Sequence function + ForAll, Concat, Date Times, and strings from Shane Young”