In this article I will highlight 10 interesting PowerApps hacks/ workarounds/ troubleshoots that might help you in building canvas apps. This article is inspired by a couple of questions that I have been repetitively seeing on the community forums. Being documented at one place, it could be a good cheat sheet for all level of users (beginners/ mid/ pros) while building apps.
Sometimes, when we add data cards columns in form, then for better user interface we need to adjust its X and Y position which is very tedious task. Or, we can used snap column feature. but that didn`t so much helpful.
So, to solve this type of issue, there is a way.
Create a blank custom data card.
Create text input field within the new custom data card, you can create multiple fields based on your requirement and puts all in the same custom data card (you can set its width and height accordingly, as per your design). You can drag and set your UI on within that custom data card.
Now, on the field data card sets its 'Update' setting to textinput.text and the hide this field data card.
That is the simplest and best way to adjust your UI of the form.
In this article I will show you how to shoot a video in PowerApps. I will pass the data collected in a collection from a Camera control and a Microphone control from the canvas app to an Azure Storage blob via Flow. I will then use those to reference to an external API and finally create the video.
A button in PowerApps has a "OnSelect" property but no "OnDoubleSelect" property. So is it not possible to have a double-click event in PowerApps then? But it is possible, with a little bit of extra effort. This blog post shows you how to add double-click functionality to a button in PowerApps. At the end, a video is shown for a more visual explanation.
This is a continuation of the Business Card Scanner using Microsoft PowerApps vBlog I had recorded back in August, 2018. This blog walks you through step-by-step to build the key features you need. Majority of the explanation is done in the video, this blog provides formulas and links to helpful articles.
Not to long ago, Microsoft introduced the column type “Location” in SharePoint Online. This is a great addition for business solutions. From a PowerApps perspective, the usefulness is limited to showing data (Country/Region, State, City, Postal Code and Street).
So is it not possible at all to update a location field from PowerApps?
This blogs focuses on how to add defaults to a SharePoint Customized (or PowerApps) form. The list in this demo includes all the column types including managed metadata. The video walks you through the steps in detail, however, this blog contains all the functions incase you want to copy and paste
This blog focuses on the on offline capability of PowerApps. Here you'll see the key features you need to add to your PowerApp in order to take input when there is no internet connection available and automatically upload it to your data connection. This written blog explains the features and the formulas/expressions used. The video deep-dives in the entire process. A copy of this app is attached to this blog.
It is recommended to update or (re)publish your app every six month. Click here to go to the related webpage. To be honest, I do not know if this it true for SharePoint forms (I assume it is), but for apps it is recommended.
So how does one know which apps are not updated or (re)published in six months? Well, PowerShell to the rescue!
This article and accompanying video shows how with a little imagination, you can leverage recent managed metadata support in PowerApps in new and interesting ways for tagging content. Also learn some nice tricks around the use of canvas controls and relative positioning of controls
Easily create multiple column based filters on any gallery or data table, while adding additional choices for items like "-All-", "-Me-", "-Today-" without having additional checkboxes, logic or if statements to get lost in.
PowerApps is so much more than just a web based form and this blog will demonstrate that first hand. Here we are building a powerful tablet app where users can watch the planets of our Solar System revolve around the Sun. The app gives the users the option to filter out any of the planets they don't wish to see while they are still revolving.