Let’s start by creating a new Power Apps application within SharePoint. To do this, follow these steps:
Firstly, log in to your SharePoint site as an administrator. Then, click on the gear icon in the top right corner and select “Power Apps” from the drop-down menu.
Once you’re on the Power Apps page, click on the “Create a new app” button. This will take you to the app creation screen where you can choose the type of app you want to create. For this tutorial, we’ll be creating a custom list app.
Select “Custom List” as the app template and give your app a name (e.g., “Employee Directory”). Then, click on the “Create” button to start building your app.
Now that we have our app created, let’s add some tables. In Power Apps, a table is equivalent to a list in SharePoint. To add a new table, click on the “Tables” tab and then click on the “Add a new table” button.
Name your table something like “Employees” and make sure it has at least one column with a unique identifier (e.g., “Employee ID”). Then, click on the “Save” button to save your table.
Next, let’s add some data to our table. To do this, go back to the “Tables” tab and click on the “Data” button next to your table name. This will take you to the data editor where you can enter new records or edit existing ones.
Now that we have some data in our table, let’s create a form to add new employees. To do this, go back to the “Tables” tab and click on the “Forms” button next to your table name. Then, click on the “New Form” button to create a new form.
Name your form something like “Add Employee” and make sure it has at least one field for each column in your table. For example, if you have an “Employee ID” column, you’ll need a text box or number field for that column. Then, click on the “Save” button to save your form.
Now that we have our form created, let’s add some logic to it. To do this, go back to the “Forms” tab and click on the “Logic” button next to your form name. This will take you to the formula editor where you can enter formulas or rules for your form.
For example, you might want to create a rule that checks if an employee’s department is already filled in before allowing them to submit the form. To do this, enter the following formula:
If( Department = “”, “Please fill in the department”, “” )
Then, click on the “Save” button to save your logic.
Finally, let’s add some views to our app. In Power Apps, a view is equivalent to a list view in SharePoint. To add a new view, go back to the “Tables” tab and click on the “Views” button next to your table name. Then, click on the “New View” button to create a new view.
Name your view something like “Employee Directory” and make sure it has at least one column for each field in your table. For example, if you have an “Employee ID” column, you’ll need a text box or number field for that column. Then, click on the “Save” button to save your view.
That’s it! We’ve now created a basic SharePoint Power Apps tutorial. From here, you can customize your app further by adding more tables, forms, logic, and views as needed.