Видео

There is a lot of Buzz about Dataverse but I feel like the person pointing out that the Emperor has no clothes on! Have I got it wrong? Have I missed something? I'm putting this video out into the world to see if others agree with me, or if they can put me right and show me that Dataverse is great after all. TL;DW - A database that enforces/encourages bad practice (by lack of support/compliance...

The Refresh command is a blunt tool with some very undesirable behaviours that are slowing down your App. In this video I explain the issues with Refresh and show you an alternative method that gives more control and better performance than Refresh.

The Power Apps authoring experience has improved dramatically over the last few years - going from 'absolute torture' to 'really rather unpleasant' :) In this video I talk about the internal features and external tools I use to try to improve the authoring experience. Download links to tools mentioned in the video: Notepad download: notepad-plus-plus.org/downloads/v7.9.2/ PowerApps Review Tool ...

In this (somewhat mammoth) session I go through all the performance tips, techniques and tools to boost App performance that I've learned in 3 years of working with PowerApps. Primarily focusing on data-requests, these tips will show you how to measure and monitor App performance. CLARIFICATION: At the 53 minute mark, I state that there appears to be no difference in performance between First(F...

PowerApps is awesome... but not for everything. In this video I discuss the limitations of the platform to help you determine if PowerApps is an appropriate solution for your requirement. Please note, these are my OPINIONS (albeit based on a couple of years of working intensely with the platform) so feel free to disagree in the comments! Thanks and happy PowerApp-ing!

Want to make faster Power Apps? This is the intro to my new series of videos discussing and demonstrating how to identify bottlenecks in your Apps and make you Apps faster and more efficient. This Intro talks at some length about the concept of delegation as well as letting you know what we'll cover in up coming videos. Links to the other videos will be added to this description as I create and...

The Datacom (aka Mad Taco) submission for 'Those Dynamics Guys Global Hackathon 2019.

What happens when you trigger a Flow from a change in SQL Server? A quick video to explain what is happening 'under the hood' and some suggestions for better performance and pit falls to avoid.

In this video I show how to work offline or 'disconnected' by using local copies of data held in SharePoint, adding new records, editing and deleting existing records, and then synchronizing your changes back to SharePoint. I also demonstrate using SaveData and LoadData to persist data to a device so not data is lost if the device is turned off (or PowerApps is closed) before the user can sync....

This is the Business Card App I used at Christchurch Code Camp 2018 to demonstrate some advanced capabilities in PowerApps. The App takes an image of a Business Card and tries to automatically pick out details such as the name, title, company, email and website. The App shows an image of the business card and overlays selection boxes over each word, so the user can correct details simply by tap...

In this video I show how to build a PowerApp to take a photo, send it to Cognitive Services' Face API and display the analysis of each face including age, gender, emotion and hair colour. I use Flow to call the Face API via an HTTP action (the Face connector in Flow does not currently support all the features I wanted to use). Useful skills covered: * use of the camera control * passing images ...

In this video I show how I built the 'Celebrity Spotter' app in Part 1. Highlights include: * Using MediaServiceAutoTag to filter my SharePoint library image source to only photos of people * Using Flow to pass an image from SharePoint to Cognitive Services * Using the sample 'celebrities' domain model - remember you can train your own models, we're just using celebrities as an example * Using ...

In this session, learn how to get a caption and tags (with confidence scores) for an image taken using the Camera control in Power Apps. Use Flow to call the AnalyzeImage function of the ComputerVision API (currently not compatible directly in PowerApps) and return complex tabular data using the Request - Response action.

In this session, learn how to use Computer Vision (from Cognitive Services) from within #PowerApps to perform OCR on an image captured with the Camera control. If you don't have an endpoint/key for Computer Vision, check the start of Part 2 for instructions on getting these (for free!). This method uses Flow to connect PowerApps to Computer Vision.

Powerapps and Cognitive Services Part 2 - Captions and tags for images

Powerapps and Cognitive Services Part 1 - Demo of Vision Services

PowerApps - Playing to the Gallery. Video version of DWC NZ Presentation

PowerApps: Using PDFs and PDF Viewer with Azure SQL DB

PowerApps: Save images from Camera, Pen and Add Picture control to SQL and display in a Gallery

PowerApps: Storing Photos in SQL - Use varchar(max)

SharePoint/MS Access: Connect to lists and libraries for easier updates and bulk updates

How to: Build a complete time-sheet solution in Office 365 with no code (Flow, SharePoint, Excel)

PowerApps: Performance tips/tricks. Forms vs Patch, Delegation, SQL Views

MS Access Generic Search Form - Free Code!

PowerApps: SQL Server Views Now Supported

PowerApps Make data modifications from within a gallery

MS Access Form Resizer: Free code to make your form designs more responsive!

PowerApps: Code Reuse and Coding Efficiency Tips

PowerApps: Take a Photo, add metadata and upload to SharePoint Doc Library