image.jpg

Adding a decimal count to your Power Automate Flow (Float/Increment variable)

I’ve explained how to count in a variable, but how do you count in a decimal? I had a usecase, where we wanted to create a version number metadata field. We could of course use an integer, count using increment, and upload to the field, however that only does ‘major’ counts i.e 1.0 to 2.0 to 3.0 etc. How do I count in minor, decimals, from 0.1 to 0.2 to 03 or even 0.

New options for Gen AI and Bing AI Search

UsecaseYou’re trying to use Generative AI features in Copilot Studio, however it says it’s not supported. How do you fix this? Enable the settings for your environmentYou need to be a Power Platform admin for this. Go to the Power Platform admin center CLick on your environment. On the lower right corner, enable these 2 settings: The 2 new options you need to enable as PP admin for your environment Now you can use GenAI in your Copilot Studio bot!

How to use the PDF Viewer, to view PDF's in a Model Driven app from an attachment column

UsecaseMy PDF viewer works in the canvas app, but not when I embed it Show image 0/0 in MDA The beginningI had a need, to display a pdf from a Dataverse attachment column in a Model driven app form. I had looked at many different PCF Components (which are totally awesome, you should really check them out!) However these only work on Notes with attachments. My dataverse table/solution uses a files column.

Calling a Power Automate Cloud flow, from Power Pages forms (!) using Javascript

Calling a Power Automate flow from a dataverse form, in a Power Page formSounds easy right? Trust me it’s not, but I hope this helps. I have had tremendous help from my colleague Laurens Hoogendoorn, who is completely awesome and helps me run with javascript (see what I did there) before learning how to crawl or walk. LOL. Laurens, you are the best! So, let me start at the beginning.

How to use regex in Power Automate Cloud flows

I had a client scenario, where I needed to grab a 6-digit number from an incoming email subject. It wont always be in the same place, and also possibly not be the only digits. So I couldnt use trim, length or other that I could think off. Unfortunately, or luckily, depending on how you look at it, my dear friend Cat Schneider introduced me to regex When you know you know, regex isnt easy.

How to use parameters in an embedded Power BI link

My scenario:This is an addition to my earlier blog, and with a few more parameters you can use. Credits go to https://community.fabric.microsoft.com/t5/Service/All-possible-Power-BI-Service-embed-URL-parameters/m-p/3053763 but I did want to share as well. I’m struggeling to fit a canvas app with a powerbi tile that has an embedded report into a teams app (gotta love it) and my report wont fully fit. I’m trying to find the magic combo of these parameters.

How to embed a Power BI report into a Canvas app, and hide the nav & filter

Step 1 - Embed a Power BI report into a canvas appI dont know about you, but it took me a while to figure out why I couldnt add my report into a Power BI tile in a canvas app. I knew I did it before, but of course didnt blog about it, so I forgot (lol) It’s actually really easy, and doesnt require you to reupload your pbix, add to tiles or others.

Filter on date column with random years on Sharepoint

UsecaseYou have a sharepoint list with birthdays, on a date column, but dont know how to filter on them to show the last few days or upcoming few days if someone has (had) their birthday. I couldnt figure out how to do this, and then a colleague of mine Remco Bruijstens (thank you!) suggested this method, and after testing it worked. Kudos to him, and I wanted to share with you how to accomplish this.

How do I automatically have a GUID in my field?

UsecaseI am creating a Model driven app, with a Virtual Table connected to SQL. In my SQL DB I have an external primary key field. How do I get an automatic GUID? The PowerFX code GUID() is not supported on the form. So I tried to do something on the ribbon, set the field, With({I:Last(Werknems).TransactionID},Notify( I, NotificationType.Information)); Patch( Werknems, Defaults(Werknems), //Row, {TransactionID:GUID() } ) However, since my field is mandatory, and it tries to save before it runs this (of course) it was saying the field wasnt filled in.

Virtual Tables - ALM variables announcement & Power Pages

MPPC 2023 - Getting to announce brand new features!As some of you may have noticed during my MPPC session, I’ve been honored to work together with 2 absolute rockstars within Microsoft, to fact check my Virtual Table information, and to get amazing new announcements out there! Pranita Padalwar Senior Product Manager for Power Pages, very generously provided information I could share for Power Pages which is so amazing I cannot wait to show you here!

How to get a PowerBI report in an adaptive card (the hard way) - Update!

UsecaseYou want to show a report in Microsoft Teams, or when someone requests a sales overview of 2022, a card appears with that report in it. You can also of course set up Powerbi alerts as a trigger. Right now, natively, dynamic reports do not work in cards. However, at MPPC they did announce this is possibly coming! For now though, here is a way to make this possible.

Custom document link sharing with Sharepoint and Power Automate

UsecaseYou need to share a file from sharepoint to an external user, in an automated process. No manual ‘create link’ actions needed on the sharepoint site. You can then email this link to your external client. Default on Power automate for a sharing link for sharepoint, is to set the Link Scope to either: Anyone with the link (including anonymous) People in your organization This explains how you can use the ‘people with existing access’ sharing type.

Calling a number in Teams from a Canvas app

How do I call someone in Teams, from a canvas app?I have a use case, where someone wants to press a button or phone icon, and that teams calls a specific person, how do I do this? There are a few ways to call someone: To a defined global, context, or environment variable Specific persons Pre-defined phone number Use the Launch command to launch a website that in turn launches MS Teams

Sending an email from a Model Driven App on a command bar button

What is the command bar?The command bar is the ribbon on top of your Powerapp. How do I edit this? Go into edit mode for your Model Driven App Right click on your table, Edit the Command Bar This opens the Command bar editor What are the 4 areas? Main Form - This is the one I’m focusing on right now Main Grid Subgrid View Associated View Reference materialScott Durow created this and it has been adopted by Microsoft ever since.

Setting conditions on the visible property - Canvas App

Setting conditions on the visible property - Canvas AppHow can I hide my items/control based on conditions? You can of course use an IF statement, or Switch, and work from there. True - shows the item False - hides the item But how can I do this dynamically?You can use Environment Variables. These can be changed when you move between environments (for ALM purposes) Set an environment variable in your solution, add the desired persons email address(es) and refresh your datasources in the Canvas app.

Connecting to Virtual Tables in PowerBI

Connecting to Virtual Tables in PowerBIWhen I wanted to connect to the virtual table, my first instinct was to use the Dataverse connector since they are virtual tables, on Dataverse. Opening up PowerBI, connecting to Dataverse, there were no virtual tables visible. Of course, the work around would be to connect to the source directly, but I did want to see if I could make it work. Virtual tables are only available in PowerBI through the Common Data Service (Legacy) connector.

Dynamic content not displaying my action

I came across this today and wanted to share. I couldnt figure out why my output from the teams adaptive card was not an option to select in my Compose (no body or anything available). 😭

You have an action in your flow, for example a teams adaptive card, and want to use the output somewhere. Whether thats in a compose, set variable, update row, doesnt matter. What you try and do, it wont show.

Quick tip! Using QuickChart.IO with dynamic values (Canvas app edition)

(This is lengthy for a quick tip, whoops, scroll all the way down to quickly check the fix) First of all, FULL credit goes to Pen Warner who graciously shared his QuickchartIO code with me that he used for his app. His app is awesome, check that out here. He’s on Twitter here: @p3nf0ld His Blog I was trying to do dynamic data into a quickchart.IO code, which I learned how to do in Kristine’s video here Go check her out as well, she’s awesome!