Skip to main content Link Search Menu Expand Document (external link)

Subcontractor Autofill

Table of Contents

  1. Purpose
  2. Flow Diagram
  3. Connections, Triggers, and Actions Used

Purpose

This flow is an automated process that runs after an HTTP POST request is recieved. This flow is primarily called when the subcontractor opens the link to the subcontractor form. The URL parameters contractNum and subName are required to be submitted to this API. Using that information, the correct folder/file pair is sourced from the submissions folder, and all the data within that is sent back via the response.

The file contains all the form data with previously submitted data. It is also used to extract known good information from JSON files with the contract number.

Given the following information, the file with ** is the selected file.

contractNum: A-12345
subName: Kangaroo

+-- ..
|-- (root)
|-- submission
|   |-- R-33333 (ContractNum)
|   |   |-- JSON
|   |   |   |-- R-33333.json
|   |   |   |-- Subcontractor1.json
|   |   |   |-- Subcontractor2.json
|   |-- A-12345 (ContractNum)
|   |   |-- JSON
|   |   |   |-- R-33333.json
|   |   |   |-- **Kangaroo.json**
|   |   |   |-- Subcontractor1.json

Flow Diagram

Power Automate Flow for Subcontractor Autofill API

Connections, Triggers, and Actions Used

Trigger: When HTTP Request is recieved

ConnectorAction
VariableInitialize Variable
Data OperationParse JSON
SharePointGet File Content Using PATH
HTTPS callWhen a HTTP request is recieved
Response


Copyright © 2022 TCIG.