• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Blog

Blog

Power Platform Requests – Base Request Capacity

17th December 2020 by Joe Gill

Something that is causing a lot of confusion in the Power Platform community at the moment is trying to figure out the impact of request limits. Particularly for organizations with "legacy" Dynamic CRM instances that load data from back end systems into Dataverse on a regular basis. Many of these integration processes were built long before Dynamics CRM transitioned to the … [Read more...] about Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

26th November 2020 by Joe Gill

Power Automate Desktop

In a recent blog post I showed how you can use the Form Processing capabilities in AI Builder to extract the details of invoices received as email attachments. In this post, I am going to expand on this and take this invoice information and use a UI Flow to submit the invoice details to a legacy application. UI Flows provide RPA, Robotic Processing, Automation, capabilities to … [Read more...] about Power Automate Desktop – UI Flow

Synapse Link for Dataverse – Metadata

5th July 2022 by Joe Gill

I previously wrote a couple of blog posts (post1 and post2) suggesting two different ways to access your Dataverse metadata in Synapse. Both of these techniques are now redundant as Microsoft announced in May 2022 that the Dataverse metadata is now available directly in Synapse. Your Synapse serverless pool now contains additional external tables with the metadata. Your queries … [Read more...] about Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 by Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

I previously did a post that demonstrated how you can use Power Automate Desktop to extract text from a PDF. At the time you were not able to extract tables from a PDF. In Feb 2022 Microsoft announced that they added that capability to PAD so I thought I might give it a quick whirl. To use it simply drag the Extract Table from PDF action to the designer providing the source of … [Read more...] about Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

25th April 2022 by Joe Gill

Many organizations require that personal data in non-production Dataverse environments is anonymized. This may be company policy or a legal requirement such as GDPR which governs the collection and processing of personal information in the European Union. Here is a quick tip on how to use the Bulk Data Updater for XrmToolBox to anonymize Dataverse data. In case you are not … [Read more...] about Dataverse Anonymization

Dataverse Metadata in Synapse

17th January 2022 by Joe Gill

Datavseres Metadata - Azure Synapse

Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here When you configure Synapse Link for Dataverse it exports your Dataverse data into a Synapse data lake as CSV files. A database with external tables is created automatically in the Serverless SQL pool providing access to the data in the CSV … [Read more...] about Dataverse Metadata in Synapse

Synapse Link for Dataverse – Option Sets

22nd December 2021 by Joe Gill

Azure Synapse Link for Dataverse Tables

Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here On November 23 Microsft announced that DES (Data Export Services) will be deprecated and will reach end of life in November 2022. Microsoft is recommending that customers use Azure Synapse Link for Dataverse instead. DES has been around for a … [Read more...] about Synapse Link for Dataverse – Option Sets

Custom Pages – Multiple Screens

29th November 2021 by Joe Gill

The introduction of custom pages within model-driven apps is the start of the long-awaited convergence of model-driven apps and canvas apps. Adding a custom page to your model-driven app gives you complete control over how the user interface looks and behaves. Coupled with the ability to connect to multiple data sources you can now create a single Power App with massive … [Read more...] about Custom Pages – Multiple Screens

Power Apps Automated Testing with Playwright

23rd September 2021 by Joe Gill

Playwright is an open-source web testing library developed by Microsoft that can be used for testing modern web apps. You can use Playwright to create test scripts for your Power Apps and use these to run automated tests. Some of the benefits of using Playwright are  it supports the three major browser engines  Chromium, WebKit and Firefox.  auto-wait for elements to be … [Read more...] about Power Apps Automated Testing with Playwright

Power Automate Desktop – Document Automation

9th June 2021 by Joe Gill

At Ignite this year Microsoft announced that anybody running Windows 10 can now use Power Automate Desktop for free. Power Automate Desktop empowers users to automate repetitive tasks they run on their Windows desktops. In this post I wanted to demonstrate some of its extensive capabilities by using Power Automate Desktop for Document Automation extracting the contents of … [Read more...] about Power Automate Desktop – Document Automation

Identity Reader – AI Builder

29th March 2021 by Joe Gill

On Friday Microsoft announced the addition of the ID Reader model to AI Builder. I thought I might give it a quick go and I must admit I was pretty impressed. It is incredible some of the AI capabilities in the Power Platform that you can leverage without any coding skills. This prebuilt model allows you to extract identity information from passports and also US driving … [Read more...] about Identity Reader – AI Builder

MB-600 – Solution Architect – Supportability

28th December 2020 by Joe Gill

I recently did the Microsoft MB-600 exam which is the final exam to qualify as Dynamics 365 + Power Platform Solution Architect Expert which is a bit of a mouthful. I think the title reflects the fact that being a Solution Architect is transitioning from being based on Dynamics 365 to the Power Platform. I would expect the certification title will change to "Power Platform … [Read more...] about MB-600 – Solution Architect – Supportability

Next Page »

Primary Sidebar

Explore by Category

.NET AI Azure Community Dataverse Dynamics 365 Integration Logic Apps Office 365 Power Apps Power Automate Power Platform Power Virtual Agents Project Service Automation SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

extract table from pdf and write as csv file using Power Automate Desktop

Extract Tables from a PDF using Power Automate Desktop

23rd May 2022 By Joe Gill

Dataverse Anonymization

25th April 2022 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Synapse Link for Dataverse – Metadata

Extract Tables from a PDF using Power Automate Desktop

Dataverse Anonymization

Dataverse Metadata in Synapse

© 2022 · Joe Gill