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.

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. 

   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.