Upload data to Microsoft SharePoint
This Action also works when accessing the web through a PROXY server: Please consult the section 188.8.131.52. for more details on how to setup the parameter P4 for web-access through a PROXY server.
To use this Action, you’ll need to setup several parameters on the Microsoft Websites and you’ll also need to obtain your “Application ID” (parameter P1), also from the Microsoft Website. Please see the previous section 184.108.40.206 for more details on the setup process.
Once you have completed the “setup process” described in the section 220.127.116.11, you can use the parameters P6 to P9 to upload data to your Microsoft SharePoint system.
The parameter P6 defines this action operating mode: it can have different values:
•Create List (Overwrite if already exists)
•Append to list
•Delete list and Append
All these operating modes (with the exception of the “Delete list” operating mode) are expecting a table in input. This input table will be injected inside the given list inside the given Sharepoint site in Azure. Ideally, this input table should have a column named “Title” because Sharepoint is imposing that all lists have a “Title” column. We are suggesting you to have a “Title” column in the table in input but you can also decide to ignore our recommendation: In this case, SharePoint will automatically add an empty “Title” column inside your list. Hopefully, you can easily hide this empty “Title” column in this way:
1.Open this URL: https://www.office.com , login into your Office account, and select “Sharepoint”:
2.Navigate to the site and to the list to edit:
2.1. Select a site: Click here:
2.2. Select a list to edit inside your site: Click here:
3.Click the icon next to the header of the column “Title”: This opens a contextual menu: Navigate to the “Show/hide columns” Option:
4.Unchek the checkbox near “Title” and click the “Apply” button: