SysMultiTableLookup - A way to show fields from multiple tables within custom lookup

Today , I will be discussing about one of the common issue which we might face while showing fields from multiple tables in lookup . As we all know SysTableLookup only pick up fields from first data source. However, in few cases we might need to show fields from multiple tables for instance I need to show operating unit number but as well as organization hierarchy Name which is field of 4th data source within my custom. In order to achieve this target I will be using SysMultiTableLookup class.

Below is the code snippet.

Note: In below line the number 4 is showing the number of datasource n in my case it is 4th datasource.
 sysMultiTableLookup.addLookupField(fieldNum(OMHierarchyType, Name),4);

Final output

Create a model driven app - Part 8

As we all know that in previous section we learned how to create dashboard for model driven application. Now its time to view this newly created app.

So, let's begin with it.

- Sign in PowerApps.

- Go to Apps menu and select your IT projects demo application. Then click on Play button.

- Here is the first navigation menu IT projects dashboard with both chart and list.

- Go to IT Project Demo menu to see your views.

- Create a new project record by clicking on new button.

List updated after creating new project.

Note : I just used duration for demo purpose you can use another field to show long duration.

Create a model driven app - Part 7

As we all know that in last post we learned how to create charts for model driven app. Now we will discussing about how to create a dashboard for this app and link it with site map.

So, let's begin with it.

- Sign in PowerApps.

- Open your model driven app and click on Edit.

Steps required for creating a dashboard.

Step 1) Click on Dashboards and it will show you its components.  Then click on Create new button to create new dashboard. Select classic dashboard option.

Step 2) Choose a layout. In my case I have selected 2 column layout and click on create button. It will open a new window.

Step 3) Enter name for your dashboard. Select Insert chart option for first column and insert list for second column.

Step 4) Insert a chart. Select your record type and view. Then click on add button.

Step 5) Insert a list. Select your record type and view. Then click on add button.

Step 6) Select Save then close. Go to Site map designer and select newly created dashboard.

Steps for linking dashboard with SiteMap. In order to show it as a first screen on app.

Step 1) Click on Site map edit button.

Step 2) Click on Add button and add sub area component.

Step 3) Rename it and set following properties on it. In order link it with newly created dashboard. I moved it up so that it should be first area for user to look around.

In last Save and Publish your application.

In the next part we will see what we have created. Stay tuned.

Create a model driven app - Part 6

As we all know that in previous post we learned how to create views for model driven app. Now we will discussing about how to create a charts for this app.

So, let's begin with it. I will be adding two charts one for showing showing cost of resource allocation per department and another for showing projects count per department.

- Sign in PowerApps.

- Open your model driven app and click on Edit.

Steps required for creating bar chart. In this we will showing cost of resource allocation per department.

Step 1) Click on charts and it will show you its components.  Then click on Create new button to create new chart. It will open new window.

Step 2) Click on charts then bar chart.

Step 3) Enter the name for chart and select series and category columns.
In my case I have selected Series to resource allocation cost and category to department.

Step 4) Select Save and close button.


Steps required for creating pie chart. In this we will showing project count per department.

Step 1) Click on charts and it will show you its components.  Then click on Create new button to create new chart. It will open new window.

Step 2) Click on charts then pie chart.

Step 3)Step 3) Enter the name for chart and select series and category columns.
In my case I have selected Series to project Id and category to department.

Step 4) Select Save and close button.

Finally go back to Site map designer and select your newly created charts.

In next part we will learn how to create dashboards.

Create a model driven app - Part 5

As we all know that in previous blog we discussed about how to create a new form for model driven application. Now  we will discussing about views creation for this app.

So, let's begin with it. I will be adding two views one for showing projects which are in completed status and another with list of all projects.

Step 1) Sign in PowerApps.

Step 2) Open your model driven app and click on Edit.

Step 3) Click on views and it will show you its components.  Then click on Create new button to create filtered view. It will open new window.

Step 4) Click on filter criteria and add a filter for showing only completed projects.

Step 5) Add columns by choosing from column attributes.

Step 6) Rename the form by clicking on edit button and save your filtered view.

Create All projects view.

Step 1) Click on views and it will show you its components.  Then click on Create new button to create filtered view. It will open new window.

Step 2) Add all columns  by choosing from column attributes and rename view.

Step 3) Save and close the view.

In final step you need to select those view from Site map designer screen. Save and close the application.

In next part we will learn how to create charts.

Create a model driven app - Part 4

As we all know that in previous post I created a new model driven app and worked on its SiteMap. Now  we will discuss about how to create a new form for this app. We can also apply business rule not only on data but as well as on forms.

So, let's begin with it.

Step 1) Sign in PowerApps.

Step 2) Open your model driven app and click on Edit.

Step 3) Click on forms and it will show you its components.  Then click on Create new button and select Main form. It will open a new window.

Step 4) Rename the form name by clicking on Form -> Form properties -> Display tab -> Enter form new name.

Step 5) Drag fields from field explorer and add in the general tab.

Step 6) Click on Save and close button.

Step 7) Now select your newly created form and save your application.

In next part we will learn how to create view for this app.

Create a model driven app - Part 3

In last post we discussed about uploading data. Now we will look about how to create a model driven apps from blank and add components in it such as Site Map.

Using Site Map designer we will be able to add new area, new group and sub area. They are sort of navigational path for your app.  New sub area is the part where we can add following four things.

- Entity
- Dashboards
- URL
- Web sources

So, let's begin with creating a new model driven app for previous custom entity and add a site map component in it.

Step 1) Sign in PowerApps.

Step 2) Click on Create meun and select Model driven app from blank button.

Step 3) Entered required information and click on Done button.

Step 4) Click on Site Map edit button. It will open Site Map designer. You must have noticed that configuration is missing so we will do work on it.

Step 5) Rename New Area , group and sub area. Sub area is the part which will linked with our entity. So set following properties on it.

Step 6) I am adding another sub area component in it for creating link with wiki. Drag it in designer and set properties on it.
Note: 1033 code is used for language.

Step 7) Click on save and close button at top right corner.  It will save your application and navigate you back to previous screen where you will notice that configuration error will be removed. Also, all entity relevant components will be shown.

In next blog we will learn  how to create forms.