Capture submissions into a list or table
When someone submits a form, automatically create a record in a List, table or another approved data store.
Where the action happens
Forms / Power Automate / Lists / SharePoint
Product or feature needed
Intake workflow
AI required
No
Extra credits
No
Technical skill
Low to medium
Risk level
Low
Licence dependency
Usually standard Microsoft 365 connectors.
Credit dependency
No AI credits.
UK availability
available
What it can do
- Turn form submissions into structured records.
- Trigger follow-up actions from the new record.
Limitations
- The destination needs a stable structure and ownership.
Prerequisites
- A form and target list/table.
Notes
Generic automation capability.
Watch-outs for Automate repetitive work
- Start with the simplest reliable workflow before adding AI.
- Flows need an owner and basic monitoring once other people depend on them.
- Premium or external connectors can change licensing requirements.
Last checked: 2026-10-09
Disclaimer: Always follow your organisation's internal guidance and policies regarding AI usage. The suggestions in this guide have been created to the best of accuracy, but Microsoft licensing, pricing and feature availability change frequently — treat them as a planning baseline, not a procurement quote.
Community feedback
Has your organisation tried this? Confirm whether it's possible, whether it's useful, and share any tips.
0
Confirmed possible
0
Reported not possible
0
Found it useful
0
Not useful
Loading feedback…