Save data to SPO using third party app

Question

Hello everyone!

I have different users that are unlicensed. 

I want to ask if i can create a portal, or use a third party app to let the user fill a specific form.

When they submit this form i want to save the form data of the users on SharePoint list. (Without giving them any kind of License)

Is it possible to achieve this ? if yes, there is any tutorial that i can follow up ?

Any help would be appriciated.

Thank you!

Answer 1

Hi julienBH,

Based on your descriptions, I assume you are considering to create a provider-hosted app using visual studio - Host the app externally from SharePoint and use all the options available with the Client-Side Object Model

Get started creating provider-hosted SharePoint Add-ins

If you want to get more help, you can go to MSDN forum where there’s a SharePoint Development and Programming category.

Regards,

Rena

Answer 2

Hi Rena Yu MSFT,

Sorry for late reply.

It's a good idea to use Microsoft Forms, but actually what i am thinking about is to create a simple .NET web application hosted  at my own website. So i can create my own flow to call the API of this web app and store the data in SharePoint List.

Can you please guide me by sharing some good documentation where i can achieve my needs ?

I will be greatly appreciative, if you could help me.

Thank you!

Answer 3

Hi JulienBH,

Have you tried Microsoft Forms? If you still meet any difficulties, please feel free to post back and we will be glad to help you.

Regards,

Rena

Answer 4

Hi JulienBH,

Based on your requirements, I would suggest you use Microsoft Forms. With Microsoft Forms, you can create surveys, quizzes, and polls, and the respondents are not required to have any Office 365 license.

Refer to Check and share your form results, the response data are stored in different ways.

1.      If you go to OneDrive for Business or SharePoint Online modern site library, you can click “New” > Forms for Excel to create the form. your Excel workbook is automatically stored in OneDrive for Business and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

2.      If you've created your form in Forms on the Web (https://forms.office.com) and click Open in Excel, an offline Excel workbook will open that has no relationship or connection to your form.

Some other reference articles you may need about Microsoft Forms:

Adjust your form or quiz settings in Microsoft Forms

Send a form and collect responses

Regards,

Rena