how to create a fillable form in sharepoint office 365

"How to Create a Fillable Form in SharePoint Office 365"

By Hannah Walker
AD

Creating a fillable form in SharePoint Office 365 can significantly streamline your workflow by enabling users to input and submit data easily. This guide will walk you through the process, ensuring you create an efficient and user-friendly form.

Before you begin, ensure you have permission to edit your SharePoint site and are familiar with its interface. This process uses the Power Apps functionality, introduced to create robust forms without requiring extensive coding.

Accessing and Setting Up Power Apps

To get started, you need to access Power Apps and set up a new app for your form. Follow these steps:

AD
6 Easy Ways to Add Microsoft Forms to SharePoint
6 Easy Ways to Add Microsoft Forms to SharePoint
Learn How To Customize A Sharepoint List Form
Learn How To Customize A Sharepoint List Form
Capture data in Microsoft Forms to create a new template agreement in SharePoint
Capture data in Microsoft Forms to create a new template agreement in SharePoint

1. In your SharePoint site, click on the 'Settings' cog and select 'Power Apps'.

2. Click on 'New' and choose 'Power App'.

Download the Ultimate SharePoint Governance Template FREE!
Download the Ultimate SharePoint Governance Template FREE!
How to Create Custom SharePoint Site Designs in Office 365
How to Create Custom SharePoint Site Designs in Office 365

Choosing a Template or Starting Blank

You have the option to start with a template or create a blank app. For this guide, let's choose a template and modify it to meet our needs.

1. Under 'Choose a template', select a relevant one to your form's purpose.

AD

2. Click 'Choose' to start building your form.

Customizing the Form Layout

Now that you have a template, you can customize it to fit your specific needs.

1. Use the 'View' dropdown to switch between edit, mobile, and preview modes.

AD

2. Click on the screen to see a pane on the right with different properties and settings to customize your form.

Adding Fields and Elements to Your Form

Next, you'll add fields and elements to your form to gather the necessary information.

1. In the 'Home' tab, find the 'Controls' section. Select the type of field you want to add (e.g., text, number, dropdown).

AD

2. Drag and drop the field onto the form screen. Repeat this process for each field you need.

Customizing Field Properties

Customize each field's properties to ensure they collect the correct data.

1. Click on a field to open the 'Properties' pane on the right.

2. Change properties like 'Name', 'Display Mode', 'Default Value', etc.

Arranging and Formatting Your Form

Organize your form elements using the layout and alignment tools to ensure a clean and user-friendly design.

1. Use the 'Layout' tab to adjust the form's layout (e.g., phone, tablet, desktop).

2. In the 'Home' tab, use 'Arrange', 'Align', and ' група' tools to organize your elements.

Adding Business Logic and Validation

Apply rules and validation to maintain data integrity and consistency.

1. In the 'Home' tab, find the 'ảo' tab to add 'If', 'Data', 'Set', and 'Submit' functions.

2. Use these functions to create rules, apply calculations, or perform actions based on user input.

Setting Up Connectors and Submissions

Configure connectors to send data to other services, like emailing the form's submission or saving it to a database.

1. Click on 'Add a connector' in the 'Home' tab.

2. Choose the connector, set up its properties, and place it within your form's business logic.

That's it! You've created a comprehensive, fillable form in SharePoint Office 365. Test your form thoroughly with different user inputs to ensure it works as expected. As your needs change, you can always update and adjust your form. Now, go ahead and share it with your team, making your work processes more efficient and automated.

AD