Forum Discussion

MichaelG's avatar
MichaelG
Brass Contributor
Jan 30, 2021

Public form for Microsoft Lists

Hi there, 

 

we use Monday for now, but I have a look on Lists. With Monday, we can have a public form (URL, accessible for everyone. So once someone fills out the form, the data appears as a new item in the list.

 

How do I do that for MS Lists? I figured out, how to customize the form for a new item, when you got access to the list (open the list and hit +New Item). But how can people enter data, without access to the list (not even having a company account)

 

THANKS!

5 Replies

  • DPC's avatar
    DPC
    Copper Contributor
    SharePoint Online / Microsoft Lists dev teams - please add this feature to your backlog. My company has a need for this functionality as well.
  • MichaelG's avatar
    MichaelG
    Brass Contributor

    Thanks you, everyone, for the replies. 

    Is Microsoft reading posts like this?

     

    Going via forms and power automate might be the way to go, but it is not user-intuitive. It'd be great to have people use Lists, without any help of an admin. 

  • Eugene_A's avatar
    Eugene_A
    Brass Contributor
    Indeed, you can share but if you want separate direct access to list data you need to use either Microsoft forms as recommended above or other forms ( ones that have connectors with power automate) and connect using Power Automate flow. Had used Jotforms, Formstack to add data in SP lists.
  • Hi MichaelG,

     

    Sharing a list form to anonymous users is not possible.

     

    One alternative would be to create a form with Microsoft Forms and create new items to the list in Microsoft Lists with Power Automate when the form is filled.

     

     

    • jcgonzalezmartin's avatar
      jcgonzalezmartin
      MVP
      Indeed if it possible depending on the sharing level configured in SPO and ODFB. I have just tested this and you can share a list item anonymously that's is not enough from this scenario...it also behaves quite weird:
      - An anonymous user can actually make changes in the list item. But he/she cannot add comments to the list (Sign in is required)
      - An anonymous user can customize the Form Layout, something I would not expect so I guess this a bug

Resources