Versions Compared

Version Old Version 25 New Version 26
Changes made by

Le, Michelle

Le, Michelle

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Steps to install APSD in D365 PowerApps platform

...

Data will not be migrated between environments through the solution. You will need to perform data migration separately following the steps below.

  1. Return to Open the modern Power Apps UI Studio and select the environment you are migrating from.

  2. Click on Solutions on the left-hand menu and then click on the APSD solution.

  3. Click Publish all customizations in the top menu bar.

  4. Switch to the Overview tab on the side and click Export → Next.

  5. Increase version number as applicable, and select Unmanaged, then click on Export.

...

  1. Go to edit the Service Request Canvas app.

  2. When prompted, select Don't Allow.

  3. Remove all connections that are showing as not connected - 5 connections (APSR, MTAPI, SIAPI, SPAPI, TMAPI), Office365Users and APSD_Translations.

  4. Add all of them back.

  5. For APSD_Translation, connect to SharePoint data connector. In the box enter the following URL: https://034gc.sharepoint.com/sites/DSD-CivilAviation/Lists/APSD_Translations/AllItems.aspx

    Image RemovedImage Added

  6. Check off the APSD_Translations list & click Connect.

  7. Run the App Checker and ensure no errors are reported.

  8. Go to the “New Service Request Step One Screen" and click on the cboNapaProject element. Turn on “Allow searching” in the properties.

  9. Go to the “New Service Request Step Three Contact Info Screen” and click on the cboFindOrganizationAlt element. Turn on "Allow searching" in the properties.

  10. Save and Publish the app.

...

Expand
titleImporting SCRAM task data
Info

Alternative solution: Follow https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-odata-dataflows-migration to create a dataflow to migrate the data between environments. This currently exists for QA → ACC.

  1. Go to the environment that has the master set of data for the SCRAM tasks. Currently, this is QA.

  2. On the left menu, go to Data → Tables, then open the Scram Tasks table.

  3. On the top menu, click on Data → Export data. Once the export has been successfully completed, click on Download exported data.

  4. Unzip the csv file.

  5. Switch to the environment you are deploying to.

  6. On the left menu, go to Data → Tables, then open the Scram Tasks table.

  7. On the top menu, click on Data → > beside Get data → Get data from Excel.

  8. Upload the csv file from step 4. If there are any mapping issues, fix them.

  9. Click Import. Wait for the process to complete, then verify that the data was imported.

Expand
titleImporting AP task data 

Follow the same steps for Importing SCRAM task data using the AP Task table instead.

Flows

Expand
titleTimesheet Approval Notifications

Name: Flow - TimeSheetNotifications

Description: This Power Automate Flow triggers when the “ap_timsheetstatus” field is modified to “Rejected”. The flow sends an email to the submitter.

...