SFOC Creation Tool

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

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 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.

Open

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. Open

   

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

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.

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!