User Registration Form using Sharepoint online

Pinnu 21

Hello All,

I want to create a user registration form using SharePoint online. can somebody help me to define the end to end steps involved right from creating a site, creating the form, validating and storing the entered data to excel sheet.

Thanks,

1 answer

Emily Du-MSFT 41,946 Reputation points Microsoft Vendor

2021-10-27T07:22:08.887+00:00

@Pinnu

Based on your description, I understand that accounts and passwords of users are stored in the cloud, you want to create a form in the SharePoint Online to validate accounts and passwords of users, if the validation is successful, then the record will be added into a excel file.

Per my knowledge, above requirement is not available in the SharePoint Online.

As a workaround, you could create a Microsoft form to register user information. Here're steps:

1.Create a page.

2.Add the Microsoft form web part in the page -> New form -> Enter name -> Create.

3.Add new questions.

4.After users have submitted form, you could see responses in the excel file.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Emily Du-MSFT 41,946 Reputation points Microsoft Vendor

2021-11-01T09:37:59.673+00:00

@Pinnu

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

Pinnu 21 Reputation points

2021-11-01T14:50:36.107+00:00

Hi Emily,

Good Morning and appreciate your help, However after going through your answer i realized that you did not understood my question, It might be my mistake for not posting the query in right manner. I am reposting the same question.

The requirement is to have a Form which will have some fields where user will be able to enter information fields like FirstName, LastName, Address, ZipCode,Phone Number,IP Address,Study Name.

Below if the Requirement:

This should be a UI developed using sharepoint.

There should be a validation in place for these fields on the form. for e.g if user enters string in numeric field e.g phone number then the error should be displayed. like wise zipcode should be 6 digits or less else system will show error message.

Once user is done entering all the information in this Form, There is a save button on the bottom of the form.The moment user clicks the button following should happen: a) If there are errors on Form then all the errors should be displayed and save operation is failed. b) If everything looks good on the form then the information on the form should be saved in a excel sheet. c) the excel sheet is already predefined with the Column Names (e.g First Name)

Emily Du-MSFT 41,946 Reputation points Microsoft Vendor

2021-11-02T09:00:38.267+00:00

@Pinnu

I want to confirm that whether you want to create a form in the SharePoint modern page or modify a new form in the list?

Pinnu 21 Reputation points

2021-11-02T13:51:43.537+00:00

Hi Emily,

I want to create a new form from the scratch.

Pinnu 21 Reputation points

2021-11-03T15:46:29.347+00:00

I want to create a new Form in SharePoint

Emily Du-MSFT 41,946 Reputation points Microsoft Vendor

2021-11-04T09:57:10.193+00:00

@Pinnu

To create a new form that satisfies above requirements in the SharePoint modern page, you should develop a SPFx web part.

Please start a new discussion with sharepoint-dev tag in the Q&A Community so that you can get dedicated support on this issue.
Sign in to comment