Power BI

The diverse collection of data connectors in PowerApps is impressive. There are over 250 different connectors available, not only from the Microsoft ecosystem but across the entire internet. You ca…

We've been helping lots of folk recently to build Flow's which extract SharePoint list item attachments and perform some form of processing, typically to convert to a single PDF document and share with a third party, or add to a records repository. The following tutorial is built around a very si...

As the number of users, apps and flows in a tenant grows, it can be hard to manage what connections are being used by which apps and flows. Use the PowerShell scripts below, which are built with the PowerApps and Flow Administration module, to discover which PowerApps and Flows use specific features like custom connectors/APIs, … Continue reading “PowerShell scripts to discover PowerApps and Flows with specific features”

Learn how to upgrade your previous version Common Data Service (CDS) database along with any canvas apps and flows that depend on it to the new CDS for Apps database. Or, delete your previous version CDS database and create a new empty CDS for Apps database.

Some big news! Or at least much bigger news. Canvas app SaveData and LoadData functions are now only limited by the amount of available app memory and local storage on a device. The previous limit of a few megabytes no longer applies. This is a huge improvement that will increase the stability of any app that … Continue reading “SaveData and LoadData Unleashed”

<p>The team has been busy the last month shipping new features and fixes for you. You can view the weekly release information here https://aka.ms/PAWeeklyReleaseNotes . Che…

<p>You’ve been through this before: you create a useful group of controls like a header. Then you copy and paste it on each screen of your app where it&#8217;s needed. But if you w…

In 2006 I applied to work at Microsoft, in their Dublin, Ireland office. I was offered a job and moved immediately to Ireland from Finland. On my first day I was handed a respectable pile of paper by

Microsoft® PowerApps & Flow are the Microsoft replacement to InfoPath & SharePoint Designer. Okay, that is a bit unfair to PowerApps & Flow, as both products address everything that users disliked abo…

When a new response is submitted, start an approval process. If approved, record the response as a new item in a SharePoint list.

<p>It&#8217;s now possible to distribute flow templates inside of your organization by sharing copies of flows. Once you have sent out a flow, your colleagues can create it from their email,…

Within PowerApps you can send data to PowerApps using the Ask in PowerApps in dynamic content. This quite quickly means that you end up with a lot of parameters when you want to pass a lot of data to …

Recently the PowerApps team released a new feature in preview – Components. I was really looking forward to the availability of this feature. An excellent reason to share my experience trying…

Within PowerApps there is an experimental feature that could be quite useful. Note that you shouldn't use this in a production app unless you don't mind being disturbed while you are on holiday. Formu…

The new “Populate a Microsoft Word template” action in Flow that was released last week got me thinking: apart from the obvious mail-merge applications, this could be used to build reports in Word! He…

Within PowerApps there are many expressions, all these expressions are nicely listed in alphabetical order. This can be useful if you know what you are looking for but if you don’t know what …

Canviz is excited to be part of the growing PowerApps community and we're doing our part to help foster it's growth. Learn more about our contributions.

The new Word Online (Business) connector lets you work with Word files in document libraries supported by Microsoft Graph to generate files from templates and create PDF versions of files.

<p>For regular readers of this blog, you may recall a blog post by Carlos Figueira on working with SQL server time values. In it, Carlos used the Mid, Find, Substitute, and other functions…

<p>We are excited to launch the public preview of the Data Gateway feature on the Power platform admin center; This feature provides tenant admins with visibility into all On-premises data gatew…

<p>For the last few months we have been rolling out new features for Canvas apps when connected to the Common Data Service for Apps: One-to-Many relationships Option sets Many-to-Many relationsh…

<p>A lot of you would have come across a scenario where you want to bulk update records. Maybe you are taking some images and want to upload them all at once. Or you want to flip the flags withi…

In my previous blog , I explained how to filter active and inactive records based on value selected...

Introduction to reusable components for canvas apps

Microsoft führt in PowerApps die Möglichkeit ein, eigene ‚Komponenten‘ zu definieren und diese über App-Grenzen hinweg wiederzuverwenden.

Sum, Min, Max, and Average functions in Canvas apps are aggregate functions that can reduce a large amount of data down to a single value. For example, Average could be used to find the average age of a class of students using Average( Students, Age ). These functions can also be used with the Filter function … Continue reading “Delegation of Aggregate functions for CDS”

<p>This week we have improvements to the Microsoft Flow and PowerApps connectors for Microsoft Planner and Office 365 Outlook, as well as two new connectors: <a href="https://flow.micros…

There’s a new wizard based, easy user interface for column conditional formatting in SharePoint Online!! That means you don’t have to know JSON code in order to do some conditional formatting on your …