How to connect Microsoft SharePoint Online and Formstack
Create a New Scenario to Connect Microsoft SharePoint Online and Formstack
In the workspace, click the “Create New Scenario” button.

Add the First Step
Add the first node – a trigger that will initiate the scenario when it receives the required event. Triggers can be scheduled, called by a Microsoft SharePoint Online, triggered by another scenario, or executed manually (for testing purposes). In most cases, Microsoft SharePoint Online or Formstack will be your first step. To do this, click "Choose an app," find Microsoft SharePoint Online or Formstack, and select the appropriate trigger to start the scenario.

Add the Microsoft SharePoint Online Node
Select the Microsoft SharePoint Online node from the app selection panel on the right.


Microsoft SharePoint Online

Configure the Microsoft SharePoint Online
Click on the Microsoft SharePoint Online node to configure it. You can modify the Microsoft SharePoint Online URL and choose between DEV and PROD versions. You can also copy it for use in further automations.
Add the Formstack Node
Next, click the plus (+) icon on the Microsoft SharePoint Online node, select Formstack from the list of available apps, and choose the action you need from the list of nodes within Formstack.


Microsoft SharePoint Online
⚙

Formstack


Authenticate Formstack
Now, click the Formstack node and select the connection option. This can be an OAuth2 connection or an API key, which you can obtain in your Formstack settings. Authentication allows you to use Formstack through Latenode.
Configure the Microsoft SharePoint Online and Formstack Nodes
Next, configure the nodes by filling in the required parameters according to your logic. Fields marked with a red asterisk (*) are mandatory.
Set Up the Microsoft SharePoint Online and Formstack Integration
Use various Latenode nodes to transform data and enhance your integration:
- Branching: Create multiple branches within the scenario to handle complex logic.
- Merging: Combine different node branches into one, passing data through it.
- Plug n Play Nodes: Use nodes that don’t require account credentials.
- Ask AI: Use the GPT-powered option to add AI capabilities to any node.
- Wait: Set waiting times, either for intervals or until specific dates.
- Sub-scenarios (Nodules): Create sub-scenarios that are encapsulated in a single node.
- Iteration: Process arrays of data when needed.
- Code: Write custom code or ask our AI assistant to do it for you.

JavaScript
⚙
AI Anthropic Claude 3
⚙

Formstack
Trigger on Webhook
⚙

Microsoft SharePoint Online
⚙
⚙
Iterator
⚙
Webhook response


Save and Activate the Scenario
After configuring Microsoft SharePoint Online, Formstack, and any additional nodes, don’t forget to save the scenario and click "Deploy." Activating the scenario ensures it will run automatically whenever the trigger node receives input or a condition is met. By default, all newly created scenarios are deactivated.
Test the Scenario
Run the scenario by clicking “Run once” and triggering an event to check if the Microsoft SharePoint Online and Formstack integration works as expected. Depending on your setup, data should flow between Microsoft SharePoint Online and Formstack (or vice versa). Easily troubleshoot the scenario by reviewing the execution history to identify and fix any issues.
Most powerful ways to connect Microsoft SharePoint Online and Formstack
Formstack + SharePoint Online + Microsoft Teams: When a new form submission is received in Formstack, the submission data is saved to a SharePoint document library, and a notification message is sent to a Microsoft Teams channel.
Formstack + SharePoint Online + Microsoft Outlook: Upon a new form submission in Formstack, the data is saved to a specified SharePoint directory and a confirmation email is sent to the submitter via Microsoft Outlook.
Microsoft SharePoint Online and Formstack integration alternatives

About Microsoft SharePoint Online
Automate SharePoint Online document management using Latenode. Trigger flows on file changes, move documents based on content, or update metadata without code. Streamline approvals and notifications with visual workflows, integrating SharePoint with other apps. Benefit from flexible logic and scalable execution.
Similar apps
Related categories

About Formstack
Use Formstack with Latenode to capture data via forms and automatically trigger workflows. Update databases, send notifications, or create documents based on submissions. Latenode adds logic, routing, and integrations to scale Formstack beyond simple data collection with visual tools and custom code.
Similar apps
Related categories
See how Latenode works
FAQ Microsoft SharePoint Online and Formstack
How can I connect my Microsoft SharePoint Online account to Formstack using Latenode?
To connect your Microsoft SharePoint Online account to Formstack on Latenode, follow these steps:
- Sign in to your Latenode account.
- Navigate to the integrations section.
- Select Microsoft SharePoint Online and click on "Connect".
- Authenticate your Microsoft SharePoint Online and Formstack accounts by providing the necessary permissions.
- Once connected, you can create workflows using both apps.
Can I automatically back up Formstack submissions to SharePoint?
Yes, you can! Latenode’s visual editor makes this easy, ensuring every new Formstack submission is safely backed up to your SharePoint document library. Benefit from robust data security and centralized storage.
What types of tasks can I perform by integrating Microsoft SharePoint Online with Formstack?
Integrating Microsoft SharePoint Online with Formstack allows you to perform various tasks, including:
- Create new SharePoint list items from Formstack submissions.
- Upload files submitted via Formstack to SharePoint folders.
- Update SharePoint records based on Formstack data changes.
- Send email notifications based on Formstack and SharePoint events.
- Generate documents in SharePoint from Formstack responses.
Can I use JavaScript to manipulate data between Microsoft SharePoint Online and Formstack?
Yes! Latenode allows you to use JavaScript code blocks to transform data, enabling complex data manipulations between Microsoft SharePoint Online and Formstack that aren't possible with simple integrations.
Are there any limitations to the Microsoft SharePoint Online and Formstack integration on Latenode?
While the integration is powerful, there are certain limitations to be aware of:
- Large file transfers might experience delays depending on your network speed.
- Real-time updates depend on the polling interval configured in your Latenode workflow.
- Complex SharePoint permissions may require adjustments for seamless data flow.