Posts

How to Copy/Duplicate a Table and Columns in a Dataverse Environment

-
Image
What If you need to do either of these things, then this article is for you: Create a copy of a table in the same environment as the original table Create a copy of a table but want a different prefix against custom column names Why In most circumstances, if you need to duplicate a dataverse table, I would suggest to bundle it inside a solution, and migrate the solution to another environment.   However, in the scenario where you need the duplicate table to be inside the same environment, here's a quick method that requires no manual creation of columns! How Short answer : Install  XRMToolBox , inside XRMToolBox, install and utilise the Clone Field Definitions Plugin  from the Tool Library. Pre-Tasks In order to clone a table with a new PREFIX value for the columns you first need to do the following: Create a new PUBLISHER with the new prefix you would like Create a new TABLE where you will be cloning all the fields. Tasks Download & Install  XRMToolBox On the 'Start Page T
Post a Comment
Read more

Free Responsive Power App Template w/ Side Navigation

-
Image
I wanted a simple template for building out responsive canvas apps with a side navigation so here it is, free to use for everyone: Find here:   https://github.com/BR-E20/Power-Platform-Solutions Solution Name: ResponsiveAppTemplate_1_0_0_1.zip  Large/Extra Large screens Medium Screens Small Screens / Phones
Post a Comment
Read more

SVG Icons for Power Apps - Find any icon you'll ever need

-
Image
Reference Material How to put SVG code in an image object:  https://www.matthewdevaney.com/svg-images-in-power-apps/#How-Do-I-Add-SVG-Icons-To-Power-Apps Figma - Microsoft Office Icons: https://www.figma.com/community/file/1109502320071552607 Figma - 1600 free icons: https://www.figma.com/community/file/886554014393250663/Free-Icon-Pack-1600%2B-icons Figma - Adobe Icons: https://www.figma.com/community/file/834829738797323395/Adobe-Icons   Steps Step 1: Search figma for icons (some examples above) Step 2: Copy icon as SVG Step 3: Paste SVG code in notepad and Replace all " with ' Step 4: Paste into image object in Canvas app "data:image/svg+xml;utf8, "&EncodeUrl(" SVG CODE YOU ADJUSTED IN NOTEPAD ")
Post a Comment
Read more

Power Platform: Managing Environment Variables in 'Managed Solutions'

-
Image
What Environment Variables are a great way to manage your solutions as they pass through DEV/TEST/PROD environments.  They save having to manually update flows/apps during each change and test iteration. However there is a gotcha to understand when you're planning your next migration or app update. More on Environment Variables | Microsoft Learn Why The two issues I faced using Environment Variables were due to the ' Current Value '. Issue #1 : If you don't want the value you used in DEV to push through to TEST/PROD, you need to remove the 'Current Value' from your solution BEFORE exporting it. If this is not done, and you're migrating as a  managed  solution, the 'Current Value' will flow through to your TEST environment, and cannot be changed because the solution is locked down. When a single sentence in an MS Learn article can cause so much pain... Issue #2 : If you're like me and you realised this AFTER you'd already imported into another
Post a Comment
Read more

Power Automate: Dynamically retrieve SharePoint Online Document Library 'Drive ID'

-
Image
Thought I'd add a fancy AI-generated blog header from Microsoft Designer while we're here ! Problem Had a Power Automate Flow that would grab a document from a document library and PDF it.   Needed to make the 'Document Library' field dynamic as the workflow was moving between DEV/TEST/PROD environments inside a Managed Solution  Putting the Name of the document library in that field was not working. How What you need to input into that field, is what's called the 'Drive ID' of the document library.  Which is not immediately available without making a HTTP Call.  So do this to get the drive ID of the specific library you're after: Code for each step Filter Array FROM value:  body('Send_an_HTTP_request_to_SharePoint_-_Get_Library_Metadata')['body']['value'] Filter Array Advanced Code : equals(item()?['name'], 'NAME OF DOCUMENT LIBRARY') Document Library Field Code : first(body('Filter_array_-_Get_DOCX_DriveID
Post a Comment
Read more

Useful Power Automate Expressions and Tips

-
Image
Wanted to provide a few Power Automate tips and tricks when using expressions and also when using Dataverse Connections. Replace semi-colons with commas  Useful when working with Choice Fields replace(outputs('Get_a_row_from_Dataverse Table')?['body/ChoiceField'],';',',')   If field is empty, show NA Useful when populating an email/document with values and you don't want the fields to have blank values. if(empty(outputs('Get_a_row_from_Dataverse Table')?['body/ChoiceField']),'N/A',outputs('body/ChoiceField'])   If a boolean value is true, show YES Useful for making the wording inside emails/documents make more sense to a human! if(outputs('Get_a_row_from_Dataverse Table')?['body/BooleanField'],'Yes','No')   If a boolean is true different method for certain scenarios if(equals(outputs('Get_a_row_from_Dataverse Table')?['body/BooleanField'],true),'Ye
Post a Comment
Read more

Keep up to date on the latest Power Platform Updates

-
Image
Want a morning news feed focussed on Power Platform updates, without getting bogged down with all the various other updates Microsoft send out? Wait no more.  Presenting, the MS Teams channel with Power Updates. How? All you need is: RSS URLs to each of Microsoft's Power Platform Blogs (provided below) A MS Teams Channel to post to 5 Flows (I promise, it's easier than it sounds) Details Solution Build a solution to store your flows together.  You need one flow for each RSS flow. Flow x 5 Each Flow only has two steps! Steps expanded: The RSS Feed URL's: Power Apps: https://powerapps.microsoft.com/en-us/blog/feed/ Flow: https://flow.microsoft.com/en-us/blog/feed/ Power BI: https://powerbi.microsoft.com/en-us/blog/feed/ Power Pages: https://powerpages.microsoft.com/en-us/blog/feed/ Power Virtual Agents: https://powervirtualagents.microsoft.com/en-us/blog/feed/ Adaptive Card code The hardest part is the Adaptive Card code, you can build a customised card yourself here:  https:/
Post a Comment
Read more