...
System Full Name | Complete a Special Flight Operations Certificate (SFOC) |
---|---|
System Full Name (FR) | Certificats d’opérations Aériennes Spécialisées (COAS) |
Business Support Team | |
Business Administrator | Sylvain Bourque |
Business Owner | Alex Shadeed |
Director | Ryan Coates |
Subject Matter Expert | Nikolay Melnik/Peter Khouri |
Division | |
NTARS Code | |
Option Analysis document | https://034gc.sharepoint.com/:p:/s/DroneDEVteam/EU8W_fqlqoJKrbFTDgrM-VsBGvKDkSsa1nd8YOK9_1SNTQ |
App registration | |
KeyVault | |
Source Code Location | https://dev.azure.com/transport-canada/AFCCC-Civil-Aviation-RPAS/_git/SFOC |
Source Code Power Automate | |
Source Code Azure Functions | https://dev.azure.com/transport-canada/AFCCC-Civil-Aviation-RPAS/_git/SFOC?path=/DocumentMerge |
Excel file with questions |
How-To and Fixes
Expand | ||
---|---|---|
| ||
Questions with answers of this application can be modified in DataHelper class of the Sfoc project. |
Expand | ||
---|---|---|
| ||
Word template documents are located at https://034gc.sharepoint.com/sites/SFOCInspectors-InspecteursCOAS/Shared%20Documents/Forms/AllItems.aspx?ga=1&id=%2Fsites%2FSFOCInspectors%2DInspecteursCOAS%2FShared%20Documents%2FGeneral%2FSFOC%20Certificates&viewid=a3871bfa%2D1995%2D431c%2D9a8c%2Dd6f12dc94347 . SFOC Certificates folder contains Word documents for Production (folder SFOC_Production_Templates_NOT_EDITING) and Word documents, which are using to update files in Production folder (SFOC_Template_EDITION_COPY). The client updates document | folder with SFOC tool questions||
Expand | ||
title | Updating document links in Populate Word templatein COPY folder and creates request (now its BUG) to update related document in Production. There are 2 steps required to update Word documents in SFOC Creation Tool:
Note: There is hidden Populate Word Template action inside of “Check if over 25kg/Scope”. Do not forget to find and update it, if related file is updated in Production template folder. |
Expand | ||
---|---|---|
| ||
Steps to update template documents are following:
|
Expand | ||
---|---|---|
| ||
To create a new action for population of Word document the following steps should be done
|
Expand | ||
---|---|---|
| ||
To work with Power Apps is required to have a User license, which allows to save Flows with Premium features. If the license is expired or never has been granted click the following link which will direct you to a Power Apps License Request form. Power Apps Per User License Request - Power Apps You will get after short period an email from the “Power Apps Centre of Excellence (PACE)” group with confirmation of your Power Apps per User license has been granted! |
Technology Assessment
Platform Type | Web (Internal) |
---|---|
Database Platform and Version | |
Development Language and Framework | |
Operating System and Version | |
Additional Dependencies | Visual Studio 2022 |
Authentication | Azure AD |
...
Note2: It’s important to create a service connection in your DevOps project to have access to the Civav container registry
...
How-To and Fixes
Get a Power Apps license to be able to save Flows with Premium features. This link will direct you to a Power Apps License Request form.
...
Assets
Diagrams source files (to be opened in Draw.io):
View file | ||
---|---|---|
|
View file | ||
---|---|---|
|