Tag: power platform

  • Power Automate: Get Dataverse file URL (show file content)

    Today, let’s explore a unique need from a client of mine using a Power App, who want to view Dataverse file contents in new browser tabs via a URL. The goal is to avoid the need of users downloading from Dataverse and storing sensitive files locally before viewing it. While this is easily achieved through…

  • Dataverse: Setup Service Principal Access for Environment

    Today’s blog I’ll quickly show how to setup a Power Platform service principal account for Dataverse and use it with Power Automate flows. A service principal is a non-interactive “user account” that can perform tasks for Dataverse or other applications with elevated permissions and better security. The tutorial consists of four primary steps

  • Arctic Cloud Developer Challenge 2024 (Hackathon)

    In February 2023 – Thomas Sandsรธr reached out to me and asked if I would like to join the ACDC competition (Arctic Cloud Developer Challenge) and got me hooked in to the event. This was something that I have had in the back of my mind since and not been able to decide, but when…

  • Dataverse: Remove decimal format from numeric columns

    In a recent project, I had a use-case where the number formats for all tables needed to be displayed without any separators as default in order to prevent confusion for the users. This prompted me to create a guide for how to change the default formatting of the number columns. Note! this will change for…

  • Power Automate: Auto Create Excel Table Based On Dynamic Content (With Excel Automation Script)

    Learn how to efficiently retrieve the final index of utilized rows and columns within an Excel file, even in the absence of a table. This guide demonstrates the utilization of Power Automate in conjunction with Excel Automation Script to create a table based on the indexes being used in multiple sheets. By employing this flow,…

  • Automation Summit 2023 @ Microsoft, London

    ๐ŸŒŸ We had a Blast at the Automation Summit 2023 at Microsoft London! ๐Ÿš€ Last week, I attended the Automation Summit and it’s PL-200 & PL-400 crash courses hosted by the always so positive Raz Choudry and delivered by my man Arpit Shrivastava with that knowledge that I needed! Oh boy, was it an intense week, but a really fun…

  • Power Automate: Web Automation with Powershell + Azure Automation + Selenium DLL library

    In todays blog I want to show you guys how to web-scrape with Power Automate instead of PAD. This scenario suits for integration with simple Web UI navigations (where use cases could be ordering equipment online, as a part of an onboarding process). Why combine Power Automate with PowerShell and Selenium C# Library: Prerequisites: Setting…

  • Power Apps: Using Figma To Design Your Application

    When it comes to Power Apps, I’ve always been a fan of the Canvas Apps approach. It gives the space for creativity and the ability for a lot of customization. While Model-Driven Apps gives the developers and users a more streamlined user experience, I prefer the Canvas Apps route because of it’s expressive freedom, straight-forward…

  • Power Automate: Integrate ‘gpt-3.5-turbo’ Model And ‘GPT-4’ Model With Microsoft Teams

    Update: Included the GPT-4 Model header as I got the beta access a week after publishing the article, and it’s basically the same implementation. GPT-3.5-Turbo was released last week and added another arsenal for developers to work with OpenAI’s public API services. This week we’re going to have a look at how we can upgrade…

  • Power Automate: Make Your Flow Change Its Own Trigger Recurrence

    Making the flow change it’s own trigger value based on the Discord OAuth token lifecycle! Alright! Get ready for some recursive stuff! ๐Ÿ” In this one we’re going to make your own flow automatically update it’s own recurrence values, so that it can automate its own runtime schedules. Now I want you to follow along…