Versions Compared

Key

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

...

How-To and Fixes

Expand
titleUpdate SFOC Creation tools questions and answers

Questions with answers of this application can be modified in DataHelper class of the Sfoc project.

folder with SFOC tool questionsUpdating document links in Populate Word template
Expand
titleWord template document folders

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

Expand
title

in 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:

  1. Copy updated file from COPY folder to NOT_FOR_EDITING folder. This can be done by selecting updated file and Copy to command to copy file to the production folder to override existing file in the Production folder. This update affect SFOC Workflow solution links, which points to none-existing Word files.

  2. Update link to this document in Power Automate solution “SFOC Workflow”

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.

Image Added
Expand
titleUpdate link to the template documents in “SFOC Workflow” Power Automate solution

Steps to update template documents are following:

  1. Launch “Power Automate“ application from SharePoint left top menu and open and edit “NewSFOC flow V2” workflow solution.

  2. Find related “Populate a Microsoft Word template” action. This action for “SFOC-RPAS Base Template.docx” is located in the first Populate a Microsoft Word template” and all other are located inside of condition actions. After finding required template file *File field can be edited to point to right version of the file.

  3. Image Added

    After updating links for every updated file “Save” the solution and validate SFOC Creation tools, ensure that the tool generates desired output file.

Expand
titleUpdating questions Yes/No cases with new Word template

To create a new action for population of Word document the following steps should be done

  1. Add “Populate a Microsoft Word template” action and update fields, similar to other action

  2. Add HTTP action with “POST” method, similar to other HTTP actions

  3. Add “Set variable” action to update InProgress variable value.

Expand
titleRequesting a Power Apps license.

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
namesfocSFOC Network Topography (DRAFT 0.2).drawio
View file
nameSFOC Network Topography (DRAFT 0.1)sfoc.drawio