PowerApp Case Insensitive Search in ComboBox

If you wonder, why you can’t get the search box to lookup the values of the search term by ignoring the case you will have to find out, that you have to configure your datasource to allow this case insensitive filtering. I spend almost 1 hour to figure out the issue – anyhow – here […]

Power App Filter by Partial Text

When I tried to filter a column by a partial match I always revieced an error message. My first expression looked like: By using this expression I never got a match (e.g. CC in CCCUPJ) !!! After visiting a couple of forums and entries, the solution is as simple as this: You just have to […]

Add columns form other tables

If you wanna add columns from other tables to a collection within power apps, this can be achieved by usding the “AddColumns” function. Dependend of the datasource, this can get pretty slow – anyhow for “smaller” references this is an acceptable way of doing this. To add columns (Lookup) from mutliple references, you need to […]

Power App update all items of a gallery

Sometimes it’s needed that you update all items within a actual gallery view – e.g. archive all records: There are other options using the “Update” command – anyhow, as I only needed the items of the current gallery and the list is usually not longer than up to 10 details, this does the job!

Power App adding reference record with just created record id

Very often you have to create a record and fill with the fresh created record id reference tables like logs, events and others. To do so within the power apps, you need to be able to fetch the record(s) which have been created with the latest patch function and access this information. The simplest scenario […]

Power Flow SQL Table Modified Trigger

If you use Microsoft Power Flow for automatisation within your company, you might have the need of starting a workflow or task in case an SQL-Server table got updated. To use this trigger, you need to add a column to your table which has the type: rowversion. For further information, pls. take a look at […]

Record Manipulation to SQL Datasource

Looking at MS documentation, they always recommend to integrate the power apps with the CDM (common data model) – as this brings many benefits sometimes I have the need of direct query usage to work with the SQL Server. E.g. a EventLog Table that “only adds” records and never updates them! So to add a […]

Qlik Global Calendar

Having a well structured calender within your qlikview app allows you to build faster charts and reports. Speak to your internal customers about their report layouts and you’ll see that most people have a common sense on how to combine data over time. Below you will find a list of fields which we recommend to […]

Hash Identifiers

Sometimes it is needed to hash identifiers, as they shouldn’t be readable by users and sometimes the fact that datamodels are faster by joining over integers makes the use of the following function really helpful: This function makes use of a trick – as m-language doesn’t allow a direct hashing. It generates a unique compressed […]

Power BI Calender Script

In order to have a global calendar, that can be shared between multiple datasets – I use the following m-script: