Creating a business app in PowerApps for Microsoft dynamics 365 for Finance and Operations.

In this blog post we will try to build out our own business app using PowerApps.

Imagine how cools is that just designing and building a business app in Microsoft PowerApps without writing code, just by dragging and dropping some elements. Functional consultants can be so powerful with this ability.

In this tutorial we are going to do the following:

• create a new app
• connect created app into Microsoft Dynamics 365 for Finance and Operations
• add the gallery to display the list of customers
• add ability to sort by customer account
• add ability to search by customer name alias

Walkthrough:

Sign in into https://web.powerapps.com/home.

Click Data > Connections.

Click Create connection.

In the list of connections, click Dynamics 365 for Operations.

In the dialog box, click Create.

In the Sign in to your account dialog box, provide your credentials for the Dynamics 365 (online) tenant.

The status will be Connected.

Click Apps.

Click Create an app.

Under Start with your data, click Phone layout on the Dynamics 365 tile.

Select connection and choose data set.

Note:

You might experience the load issue like it’s presented below. Just check the D365 accessibility in this case.

Select the table. For our example, we will select Customers.

Click Connect.

Remove all unnecessary elements.

Click Insert > Gallery.

Select Vertical gallery.

Select Data Source for the Gallery.

Select source fields for the Gallery.

Use & symbol to concatenate the values. For example,

ThisItem.CustomerAccount & ” ” & NameAlias.

In this case we will display the Customer account and the Customer name alias.

Repeat the same for the remaining fields.

In this case we will display the Customer address.

Click Play button to see how it works.

This is a result:

Change Sort and Search button logic.

Highlight the Items in the Gallery and type in the following formula in the formula bar:

SortByColumns(Search(Customers, TextSearchBox1.Text, “NameAlias”), “CustomerAccount”, If(SortDescending1, Descending, Ascending))

It will sort by Customer account and search by Customer name alias.

Check it out:

And sorting part:

At the end I would like to provide the link https://docs.microsoft.com/en-us/powerapps/maker/. You might find the link useful because in these articles you can find an answer on all of your questions regarding Power Apps.

It’s just a beginning!