Power Apps

Article08/01/20234 min read

  1. Create a Power Apps environment, if not already done. For more information, click here.

    In the app, the user can choose the language to use during app runtime.

  2. Create the Dataverse database and choose the currency that matches the company currency setup in Business Central.

    For more information on the Business Central Dataverse integration, click here.

  3. Activate the languages to be used in the environment via the Power Apps Admin Center.

    For more information on activating languages, click here.

  4. Import the Power Apps Solutions Foundation and Quality Control in the created Power Apps Online environment. Packages (.zip) can be requested by contacting Aptean.

    For more information on importing packages, click here.

Note

Foundation is used for all Aptean Power Apps Solutions and only contains the tables for all solutions.

During the import, the connection setup for the Azure Blob Storage Connection is shown.

  1. Select the one used in the current environment.

  2. Select the connection to Azure Blob Storage to be used to link and show Quality Control attachments. If there’s no connection available, create a new one. To do that, select New Connection in the drop-down menu.

  3. In the Authentication type field, select Access Key from the drop-down menu while creating a connection with the Azure Blob Storage.

After creating the connection, go back to this screen, refresh, and select the created connection in the drop-down.

  1. Enter the Azure Storage Account Name and Access Key saved in the steps described above for the connection.

The above connection is now linked to the Connection Reference used in the solution. For more information about connection references, click here.

Note

If the connection reference is already setup in the environment, the value will not be updated (so that it does not overwrite customer specific data) and can only be changed after importing manually by editing the connection reference.

  1. As instructed in the user documentation, the Azure Blob Storage container used to store files and photos in Quality Control is created with the name attachments.

This is also asked during import for a fresh install:

If you used another name, the environment variable AzureBlobStorageAttachmentsPath offers the ability to set your own value. In all other cases, use attachments/ as should have been created when following the instructions.

If the environment variable is already setup in the environment, the value will not be asked or updated (so that it does not overwrite customer-specific data) and can only be changed after importing by manually editing the environment variable:

In the Default Solution, search Environment Variables, edit the AzureBlobStorageAttachmentsPath Environment variable and enter your Blob container name to be used as the Current Value. In the example below, the example qualityphotos/ is used instead of attachments/.

Important

Always define the value with / at the end as shown below.

To change an environment variable, go to the Default Solution in your environment, search for Environment variables and select the Environment variable you would like to edit.

  1. Save and publish the app.
Note

Since some values are stored in the cache, it’s advised to reopen the browser after changing connection references or environment variable values. When the app is started, and the old value is still used, the cache refresh can be triggered by pressing CTRL+F5 just after the Canvas App is started.

  1. Run the app to test it and allow all connections.
  2. Repeat the steps described for the other canvas app in the solution. Finally share the Canvas and Model driven app with users that need access to it, otherwise they cannot use the app.For more information on sharing apps, click here.
Note

If you are using the Aptean Quality Control extension, assign the Quality Check Role to those users.

  1. Select Manage users in the Power Platform admin center to find the users.

  2. Select the Power Apps environment.
    A new window opens.

  3. Under Users, select See all.

  4. Select Manage security roles and check the required role.
    For more information on how to setup users and their roles, click here.

    Note

    If you are using the Aptean Quality Control extension, check the QualityCheckUser role.

  5. Execute the data import.

The data package is imported by using the Data Migration Utility.

Note

If you are using the Aptean Quality Control extension, click here to download the Quality Control data package (.zip).

This is part of the XRM Toolkit that can be installed by running the script as described in the installation details in paragraph 3.

  1. Start the data migration XRM toolkit.

  2. Login and open the environment you want to import the data into.

  3. Select Import data.

  4. Select the data file to import.

  5. Select Import Data to start the import.