question

Pinnu-8453 avatar image
0 Votes"
Pinnu-8453 asked EmilyDu-MSFT commented

User Registration Form using Sharepoint online

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,

office-sharepoint-onlinesharepoint-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered EmilyDu-MSFT commented

@Pinnu-8453

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.
144117-1.png
2.Add the Microsoft form web part in the page -> New form -> Enter name -> Create.
144162-2.png
3.Add new questions.
144090-3.png
144173-4.png
4.After users have submitted form, you could see responses in the excel file.
144157-5.png


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.



1.png (9.9 KiB)
2.png (37.3 KiB)
3.png (17.8 KiB)
4.png (11.7 KiB)
5.png (25.7 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Pinnu-8453

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.

0 Votes 0 ·

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:
1) This should be a UI developed using sharepoint.
2) 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.
3)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)

0 Votes 0 ·

@Pinnu-8453

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?

0 Votes 0 ·
Show more comments