Using PowerApps to Customize a SharePoint List Form
- With your SharePoint list on screen, click the down arrow next to PowerApps on the list toolbar and click on Customize forms:
- PowerApps editor will open and create a default form:
- Let's make the form wider so we can have 2 columns of fields.
- Click on File > App Settings and change Orientation to Landscape
- Click on Apply
- Click on the back arrow to return to the PowerApps Editor:
- Grab the righthand middle control on the form and stretch it to the width of the page.
- On the data source menu, change the number of columns to 2. If you closed your data source menu, you can re-open it by click on Data - Service Requests link on the righthand edit menu.
Note: Standard field width is 455 and covers 1/3 of the screen for Horizontal forms. You can widen fields to 2/3 or full width by increasing the width of the Data card. 1/3 width is 455, 2/3 width is 910 and full screen width is 1365.
- Your form should look like this:
Note: You can hide fields easily by turning their visibility off or you can also delete them. If you want to pass form data to the list via "Hidden Fields" you can populate the form field with user data such as their ID, then hide the field and that data will still be passed through when the user submits their form.
- Next, let's change the width of the Title and Description fields to cover 2 columns.
- Select the Title card and grab the righthand middle control and stretch it to the right side of the form.
- Note that the Description card was pushed down to the next line.
- Now select the Description card and do the same - stretch it to the right side of the form.
- Your form should look like this:
- Let's save and publish your changes and test it with our SharePoint list.
- Click on File > Save
- Now click on Publish to SharePoint > Publish to SharePoint
- Click on the URL to our SharePoint list (it's above the Saved timestamp)
- Back on your list, click on New
- You should see something similar to this:
- Close your form.
Create a Southwest Airlines branded header for your form
- Next, let's add a logo and title to our form.
- Go back to the PowerApps Editor tab in your browser or in your Service Requests list, click the down arrow next to PowerApps on the list toolbar and click on Customize forms.
- In the Screens menu on the left, select your SharePoint form (SharePointForm1).
- Grab the top middle control on the form and drag it partially down the page (about 65 pixels).
- From the Insert ribbon, click on Label and stretch it to cover the area you just opened up.
- set the text color to white and the background color to blue, then click on Custom and set the hex values to 304CB2 or set the RGB values to 48 76 178 respectively. This is the approved Southwest corporate blue.
- Click on Home and change the font size to 22.
- Change it to bold.
- Set the Padding left to 210 (This leaves room for the logo)
- Under the Media drop-down, Select Image > Add the SWA Logo
- Position it into the top left corner of the blue Header Label.
- Rename it "Header Label"
- Next let's add the User Profile Information to the header Label.
- From the Insert ribbon, click on Label for the text property insert in the following. Office365Users.MyProfile().GivenName & " " & Office365Users.MyProfile().Surname & " - " & Office365Users.MyProfile().MailNickname & " - " & Office365Users.MyProfile().Mail & " - " & Office365Users.MyProfile().OfficeLocation
- Using the controls, move and stretch it to cover the right hand side of the Title Label you just created previously.
- Your form should look like this:
- Now Save, Publish and test your form:
- Note - if you don't see your form changes, refresh your browser.