Unleash the Power Fx of commands in Power Apps
In the new command bar editor that Microsoft released for model-driven Power Apps you can use both JavaScript as well as Power Fx formulas. In this article I’ll show you an example of how easily you can use Power Fx to create an action button in the ribbon that interacts with data of the record.
In this example I will create a button to search for the account name in google. By pressing the button the search results will appear in a new tab in the browser.
The command bar editor is available in the app editor via make.powerapps.com Select your model-driven app and press edit.
Click on the ellipsis besides the table you like to create the button for, in the case Account, and select Edit command bar.
There are four different command bars per table, for the main grid (view), main form, subgrid view (on the form), and associated view (on the form, via related). In this case choose Main form and press Edit.
领英推荐
In the Commands left menu press + New and select Command. This will create a new command.
Select the new command, move it to a good location in the bar and in the right Command menu give it a name under Label, select and icon, select Run formula under Action and press fx Open formula bar. In the fx bar on the top, type in the following formula:
Launch(Concatenate("https://www.google.com/search?q=",Self.Selected.Item.'Account?Name'))
This will launch a website URL. The first part of this URL is the standard search URL for Google and the second part refers to the name of the account record in Power Apps.
By pressing Save and Publish in the upper right corner, the new search button in the command bar will be available for the app users.
Using Power Fx in the command bar is a much easier option to creating button that interacts with the data in Power Apps. I hope Microsoft will invest more in this area. For example, starting a cloud flow in Power Automate from a command by Power Fx. As a solution that can be deployed to another environment without the need for customizing it.