What is the best method for creating an online signup sheet? #M365AMA

In this episode, the #M365AMA panel discusses the following community question:

“How would I use Excel, Teams, or Forms (or a combination) to create online signup spreadsheets? I’d like to have an online document where students can type their first name, last name, and others column for details of whatever they are signing up for. They should be able to edit so they can add their info in one row, but not be able to delete what other students write. I also want them to be able to see what other students write, because I usually ask that they all choose a different topic/date for their presentations. I know I could set up a survey through Forms where they can tell me their info and then I can download a spreadsheet of answers, but then they can’t see what others have written. Thanks!”

Check out the discussion here:


Participating in this discussion were:

Some relevant notes/links shared by the team:

  • As we discuss in the video, there are several ways you can approach this depending on your requirements. You can create a Microsoft Form using a Power Automate flow to populate a SharePoint List with view only access. Or create a solution using Power Apps (our suggestion). Or you can share an Excel file with locked cells via OneDrive. You have options.

Christian Buckley

Christian is a Microsoft Regional Director and M365 Apps & Services MVP, and an award-winning product marketer and technology evangelist, based in Silicon Slopes (Lehi), Utah. He is the Director of North American Partner Management for leading ISV Rencore (https://rencore.com/), leads content strategy for TekkiGurus, and is an advisor for both revealit.TV and WellnessWits. He hosts the monthly #CollabTalk TweetJam, the weekly #CollabTalk Podcast, and the Microsoft 365 Ask-Me-Anything (#M365AMA) series.

1 Response

  1. February 3, 2023

    […] is the best method for creating an online signup sheet? #M365AMA [blog | […]