How to add low-code Power Fx buttons to model-driven apps
[Update June 2022] The modern command designer is now GA!
Power Fx command bar buttons in model-driven apps is the latest exciting feature to be released into preview by the Power Platform team! Check out my first look video and Casey’s blog post.
This post shows you the steps to follow to add a command bar button on a model-driven form to create a related task for the account record and to only show this when the Credit Hold flag is set to No. This would normally require custom JavaScript and the Ribbon Workbench but now can be accomplished with a simple expression!
1. Open the new Model Driven App editor
First, we must open the new model-driven app editor to access the command bar editor.
- Create a new model-driven app and add the account table.
- Open the solution that contains the model-driven app using the preview editor (make.preview.powerapps.com)
- Using the context menu on the model-driven app, select Edit -> Edit in preview
- This will open the new app designer preview. Eventually, this will be the default experience.
2. Edit the command bar
Once the app designer has opened we can edit the command bar on the account table. We will create a form button to create a new task for the selected account.
- Inside the Pages panel, select the Account Page context menu -> Edit command bar (preview).
- Select the Main form command bar to edit.
- The command bar editor will open.
3. Add Power Fx Command Button
The command bar editor will show all the buttons configured for the account main form. Some of these buttons will not be visible by default but are displayed still in the editor. This is very much like the Ribbon Workbench. The existing buttons are considered V1 buttons and cannot be edited at this time.
- Select New command.
- In the Command properties panel on the right, set the Label and Icon of the button.
Note: You can also upload your own svg
rather than selecting from the out-of-the-box icons available.
4. Set Visibility Expression
This is where Power Fx starts to make an appearance!
- In the Visibility section, select Shown on condition from formula that is at the bottom (you may need to scroll down).
- Notice the Expression drop-down now shows Visible rather than OnSelect.
- Enter the expression:
Self.Selected.Item.'Credit Hold'='Credit Hold (Accounts)'.Yes
Note: You can also use navigation properties to access related records in these kinds of expressions! - Save and Publish and then close the editor window.
5. Open Component Library and add a data source
So that we can add a new task, we must add the Tasks data source connection much like we would in a canvas app.
- In the solution editor, select Component libraries and then open the CommandV2 component library that should have been created.
- Once the editor has opened, select Data in the left-hand panel.
- Select Add data.
- Select the Tasks table from the Current environment connector.
6. Close Component Library to release the lock
When you open a component library, a lock is taken out to prevent it from being edited in multiple sessions. We must close the editor to release the lock.
- Select File -> Save.
- Select Publish -> Publish this version.
- Select Close.
7. Add OnSelect Expression to create a task
Now we can add the Power Fx expression to create the new task related to the account record.
- Open the command bar editor again using Edit command bar (preview) from inside the model-driven app editor.
- Select the Main Form again.
- Select the Credit Check button.
- In the OnSelect expression enter:
Patch(Tasks,Defaults(Tasks),{Regarding:Self.Selected.Item,Subject:"Credit Check Follow Up"});
Notify("Credit task created",NotificationType.Success);
- Select Save and Publish.
- Select Play to open the model-driven app.
8. ...and the result!
Once the model-driven app opens, you can open an account record and see the Credit Check button appear only when the Credit Hold column is set to Yes.
Selecting the button will create a new task related to the current record! Notice that the form is automatically refreshed to show the new record created inside the related records.
Note: If you wanted to make the button appear as soon as Credit Hold is set to Yes, you would need to add a call to refreshRibbon
inside the form fields onChange
Event.
To add this functionality using the Ribbon Workbench would have required JavaScript and would be considerably more complex. The new commanding Power FX command buttons unlocks many customizations to low-code app makers!
There are still some requirements that are not yet possible to implement using the new Power Fx Commanding, where you will need to continue to use the Ribbon Workbench. One example of this is the more complex display/enable rules you could create such as visibility depending on the user's security privileges - but I am hopeful that these gaps will be filled in the 'fullness of time' 😊
Watch out for more posts from me on Power Fx commands!
Published on:
Learn moreRelated posts
Security Model of Dynamics CRM
Business Unit – It is a way to group business activities.When an organization is created, a Root Business Unit is created by default. Thi...
Getting Started with Power Fx in Power Pages (Preview): Low-Code Rules Made Easy
Use Power Fx in Power Pages (Preview) Power Pages is getting smarter! Until now, most of the logic you could add to forms and pages had to be ...
Microsoft Copilot Studio – Build enhanced connectors with the Power Platform Connector SDK and PowerFx
We are announcing the ability to create enhanced connectors for makers in Power Apps and Copilot Studio. This feature will reach general avail...
Run Power FX expressions through PowerApps Component Framework Events: Part 2
Introduction Just like we explored in Part 1, where Events in the PowerApps Component Framework (PCF) brought new possibilities to Model-Drive...
I recreated Dynamics CRM with the Power Platform Plan designer
In January 2003 after many months of engineering and development, Microsoft released one of the first business solutions built-in house; Micro...
Exploring Preview Power Fx Functions in Power Apps Test Engine
Microsoft Power Apps Test Engine provides a powerful automation framework to validate Canvas apps using test plans written in YAML and Power F...
Why Plugin Depth Matters in Dynamics CRM
Plugin development in Dynamics CRM is one of the most advanced and intricate components, requiring deep expertise in the platform's event pipe...
Exploring the Potential of Power Fx Functions (Preview) in Power Apps
As developers, we often encounter scenarios where the same logic needs to be written in multiple places. This may result in code redundancy an...