Send data to Data Source via Power Automate

Send data to Data Source via Power Automate

Microsoft Power Automate

Using Power Automate you will be able to create flows that upload information from an external source dirctly into a ILG Forms Data Source.

ILG Form Requirements

In order to create the HTTP connect in Power automate, you will require:
  1. The External ID of the Datasource you wish to upload to.
  2. Your ILG Forms company ID.
  3. Your ILG Forms API Full Access Key.

Once you have obtain the above, head into your flow in Microsoft Power Automate, add a HTTP action to your flow and enter the follow information.

API URL Call

The API call we will be using is the following:
Enter this URL in the URI field on the HTTP field.

API Method Call

The method we will be utilising on this is PUT. Please select this on the drop down.

Headers and Queries

In this example these can be left blank.


API Body
In the Body field please enter the following code:
  1. {
  2. "ExternalId": "apitestdatasource",
  3.   "NewRows": [
  4.     "column0,column1,column2,column3"
  5.   ],
  6.   "CompanyId": 12345,
  7.   "IntegrationKey": "apiIntegrationKey"
  8. }
Change the following items:
  1. External ID will need to be enter on line 2, where it currently states apitestdatasource, enter your ILG Forms Data Source External ID within the quotation marks.
  2. Line 4, where it states column0, etc, enter the information you would like added into the datasource, if this information is coming from a another part of your flow, please select this using the flow builder. separate each columns data by using comma (,).
  3. Company ID needs to be entered on line 6, please replace where it says 12345
  4. Lastly your API Full access key needs to be entered into line 7 where it says apiIntegrationKey, make sure to input this in between the quotation marks.

Finally, test your flow and make sure information is entering your Data Source on ILG Forms, if you have any issues or questions, please contact us via contact@ilg.support 

    • Related Articles

    • Adding a SharePoint Connection

      Authenticating a connection to SharePoint enables communication between the two platforms. This must be successfully added before Form Connectors (SharePoint List and Sharepoint Document) can push or Data Source Connectors can pull data. Adding The ...

    • Adding an MS Graph Connection

      Adding a Connection When logged into your ILG Forms web portal, navigate to Connected Data > Connections > Add Connection - Microsoft Graph. Once added, you'll be presented with the Connection's properties to fill out, and then hit SAVE to view the ...