If you’ve ever needed a simple way to collect information without exposing an entire SharePoint list, this one’s for you.
Microsoft has quietly rolled out a new Forms experience built directly into Microsoft Lists and SharePoint lists, and it fills a long‑standing gap between “basic list forms” and heavier tools like Power Apps or Microsoft Forms. The goal is simple: make it easier to collect information directly into a list, while keeping the experience clean, branded, and easy for the person filling it out.
At first glance, it feels familiar. But once you dig in, it’s clear this isn’t just a visual refresh. It’s a new way to think about lightweight data collection inside Microsoft 365.
Why this feature matters
Historically, collecting information into a SharePoint list came with tradeoffs.
You either:
Gave people access to the full list (sometimes more than you wanted), or
Built a separate Microsoft Form and stitched everything together with Power Automate.
The new Microsoft Lists Forms experience removes that friction.
With a few clicks, you can create a form that:
Writes directly to a SharePoint or Microsoft List
Can be shared via a link to people in your organization
Lets respondents submit data without seeing the list at all
Feels modern, fast, and mobile‑friendly
For admins and power users, the real win is that the data lands exactly where you want it, ready for views, rules, Power Automate, or reporting—no duct tape required.
Microsoft Lists - New Forms Experience [Now available]
How the new Lists Forms experience works
You can create a form from an existing list, or even start with a form and let Microsoft create the list behind the scenes.
🔧 Create a form from a list
- Open your SharePoint or Microsoft List
- In the command bar, select Forms → New form
- Give your form a title and optional description
- Choose which columns appear on the form (and hide internal-only fields)
- Apply a theme or branding
- Preview, save, and copy the sharing link
Every submission instantly becomes a new list item. From there, it behaves just like any other list data—views, rules, notifications, and automation all apply.
🎯 Not just one form per list
One underrated feature: you can create multiple forms against the same list.
That means:
- A “Quick Intake” form for lightweight submissions
- A “Detailed Request” form for power users
- Separate entry points for IT, HR, or events—all feeding the same data source
Where this really shines (real‑world scenarios)
✅ Employee or IT intake requests
Create a clean submission form for common requests (access, hardware, issues) without granting list access. Internal fields like priority, status, or assignment stay hidden from the user.
Tip: Pair the form with a list rule or Power Automate flow to auto‑assign or notify the right team.
✅ Event registrations or RSVPs
Collect attendee details directly into a list you can filter, group, and export—no more syncing between tools.
Tip: Use required columns and column validation in the list to ensure complete submissions.
✅ Idea submissions and feedback
Let users submit ideas anonymously or with minimal friction, while keeping ownership, scoring, and workflow on the back end.
Tip: Hide review columns from the form but surface them in list views for reviewers.
✅ Departmental data collection
HR forms, safety requests, equipment tracking, field reporting—this is an easy win for internal processes that don’t justify Power Apps development.
Tip: Create different forms for different audiences, even when they all write to the same list.
Tips and tricks worth knowing
- Forms are internal-only: Sharing is limited to people in your organization. External respondents and guests aren’t supported yet.
- Conditional branching is available: You can show or hide questions based on previous answers, making longer forms easier to use.
- Branding matters: Themes and logos help build trust and make forms feel official.
- Stop or schedule responses: You can open and close forms or set start and end dates without touching permissions.
- This complements, not replaces, Microsoft Forms: Lists Forms are best when your data needs to live in a list from day one.
Wrapping it all together
The new Microsoft Lists Forms experience is one of those updates that feels small until you start using it—and then it quietly changes how you build solutions. It won’t replace Power Apps, and it isn’t meant to compete with Microsoft Forms. Instead, it fills a sweet spot: fast, clean, list‑native data collection with just enough customization to be useful.
For teams already living in SharePoint and Microsoft Lists, this is a feature that reduces friction, speeds adoption, and keeps information structured without overengineering the solution. If you manage internal processes, build lightweight workflows, or support end users who just want “a simple form that works,” this one is absolutely worth exploring.
External Links
