image.jpg

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 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!

Setting restrictive security on a Word Template while leaving sections open (Restrictive editing)

Another Word tip, oh my…This explains how to set security on a Word document, restrict the editing, but allow forms to be filled out, and certain sections to be edited. For example, to add in attachments or images. It’s the most frustrating process, but I hope I can explain it clearly. If you find you cannot add a continuous break, but it does a page break, check out this article, or redo your document (that’s what I did)

Business Process Flow - How to automate moving through different stages

How to move stages automatically (BPF) using Power Automate (no http calls needed)Quick summary: You need to grab data from 3 different tables, link them using lookup columns, capture ID’s, and add in conditions and use Data operations to shape the data into usable steps. Then add in a switch depending on your stage names, and add final actions updating your BPF table. Sounds easy enough right?….. Beaker’s head on fire I hope this helps, and I tried explaining it clearly, please let me know in case of any questions, feedback, other methods etc.

How to repeat words in Microsoft Word (XML Mappings)

I know I usually only do Power Platform, but Microsoft Word is bound to be in your project needs someday, or combining with Power Automate, so I figured why not? Ever had the request to have certain words repeated, lets say in a header or footer? It can be anything, a date, name, product title, Business Unit etc etc. This can be achieved using XML Mapping in Microsoft Word. To get to the XML mapping, you must first have the Developer Tab activated.

Another quick tip! Removing blank items in a compose

This is a follow-up post for my earlier blog, Combine data from multiple apply to each into a single output file (Variables and compose) Cat Schneider helped me tremendously on this one, full credit to her! Find her blog here Thank you Following these steps, results in some empty values also being added. For example, if there is an empty entry, but the item exists and you specify that item it will show up.