Hero Image
Quick tip - data refresh in command bar

This is the quickest tip ever, but I just spent hours trying to figure this out (ouch) so figured I’d share. I’m working on a custom button in the command bar in a Model Driven app. I want it to trigger my flow, so I’m doing a Patch to a new column Workflow started. Seems easy enough. Patch( Datasource, Self.Selected.Item, {WorkflowStarted: true} ); Notify("Flow started", NotificationType.Success) Whatever I do, I cannot get it to recognise the column. It kept saying: The specified column doesnt exist.

Sunday, September 28, 2025 | 1 minute Read
Hero Image
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 form Sounds 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.

Wednesday, July 17, 2024 | 4 minutes Read
Hero Image
How do I automatically have a GUID in my field?

Usecase I 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. So this didnt work.

Monday, November 27, 2023 | 3 minutes Read