logo
Forms
Jan 26, 2018

How to create Public web forms with repeating rows (save to SharePoint)

Customer Support Engineer

Have you ever faced a situation where you need to add items to SharePoint list, but you don’t want to give direct access to your site? Maybe you have, maybe you just thought about it.

Of course, it has always been possible to have more than one site, or limit users’ rights — but is that the most convenient option? In many situations, it really isn’t. What if you could add items to SharePoint from an outside source, like a custom web form?

1

Let’s say, you have a contact form for your clients — how to handle it best? Or maybe you need to have an office supplies request form and want all submissions to go directly to SharePoint. This is the example we’ll showcase in this article, but whatever your needs might be, Plumsail Forms has you covered. Web forms designed with Plumsail Forms can be easily published to absolutely any webpage. You can also protect yourself from unsolicited submissions with reCAPTCHA.

2

Our web forms are simple to design, they are responsive and mobile-friendly, but also highly customizable with many custom methods and events that you can use — all forms are built with Vue.js and also allow you to utilize JQuery.

The editor offers simple drag-n-drop interface and simple forms can be built in just a couple of minutes while there are almost no limits to how advanced your web forms can be. Most importantly all forms’ submissions are handled by Microsoft Flow and allow you access to thousands of custom connectors and actions.

3

In the end, web form submitted with MS Flow can create or edit many items in SharePoint, in this example, we create one item in Order list with the order description:

4

But we also create multiple items from our Data Table in the Ordered Items list which are all tied to the Order itself with a Lookup, like this:

5

Please, check out our full article with detailed instructions for every step, including automatic calculations of Total price for each ordered item and Total Order price, setting up MS Flow, formatting dates, and everything else.

If you are interested in custom web forms which would then utilize all capabilities of Microsoft Flow, please, check out our site for more information and other use cases. Plumsail Forms would allow you not only to add items to SharePoint, but also to add records to SQL Server, send emails, upload files to SharePoint Document Libraries or Dropbox, and much more.

Note: The post has been originally published at: