SharePoint Custom Forms with PowerApps

Learn how to customize your SharePoint list forms with Power Apps. Learn how to get started, has SharePointIntegration control works, save, publish, and tips to make it easier for you to customize your SharePoint Online lists.

00:00 It starts
1:38 Demo of a custom sharepoint form with an Outlook and Power BI Connection
4:13 Customize with PowerApps your first SharePoint form including save and publish
8:40 The forms DataSource and Items property
10:24 SharePointIntegration control .Selected record and .SelectedListItemID
12:00 Save, Publish, and then open SharePoint list in a second tab to make the back and forth faster
13:18 SharePointIntegration Edit button, New Button, Save Button, Cancel Button, OnEdit, OnNew, OnSave, OnView, OnCancel
14:27 SharePointForm1 OnSuccess ResetForm(Self) RequestHide()
15:43 Add the Office 365 Outlook Connector and Send an email with a button SendEmailV2
18:19 Resize the display form
21:06 File Save, Save As, Security, running the form stand alone, and why none of them work for these custom forms
22:36 Add the Power BI Tile
23:01 Manage, hide, and delete your custom form from SharePoint List Settings Form Options
24:19 Don't do too much. My warnings of overusing this.
25:25 Use the SharePoint Webpart Microsoft PowerApps Preview on a Modern Page

[jackpost]

Shane this video is my bread and butter for the current work I do at my company. Tons of custom SP forms powered by PowerApps. I found you while trying to figure out how to deal with signatures on in SP lists and you made me a base64 expert. Keep it up!!!

[lisajac]

THANK The "resize" part of this video straight to the end is everything I have been struggling with in the Power app world. This is a great tool and I love the customization optionality... BUT! yes, don't do too much. Thanks for this, its a great help.

[makayla]

Thank you! Appreciate the additional explanations of the code functionalities ❤

[TracyOsimowicz]

I didn't know you can't export/import form customization. Useful info!

[sandramcgechan]

I didn't quite understand the final bit about embedding something into a site page. I can see the use case for a PowerApp App, but for a PowerApp Form that belongs to a SharePoint list, I don't understand what you would be embedding?

[RickySpears]

Hi Shane! Great video as always! At 13:26 you encountered a common caching issue that I often see. You were viewing Chewy's record, then created a new record. In the label control at the bottom of the form, it still shows Chewy's name instead of an empty label as one would expect. I haven't yet found a consistent and simple way to keep this sort of thing from happening. Sometimes doing a Refresh() will clear the cache, and fix the problems, but not always. Sometimes setting all the fields default values to variables and then loading those variables as desired at OnNew, OnView, and OnEdit before displaying the form will fix it, but not always. Sometimes adding a delay before showing the form seems to fix it, but not always. Have you discovered the magic phrase that works all the time?

Say, "Hi, " to Nicola for me. It's been far too long since I've last seen you both!

[robertorodriguez]

Shane, you are genial! thank you for sharing!

[stefancochrane]

Many thanks! Is there a way to check for changes, and in the "OnCancel" event, let the user know, and decide to remain there instead of cancelling? This is the normal behavior for Word, Excel documents, for example - close or cancel it, and you are prompted that changes will be lost. Any recommendations? 🤷‍♂

[gabrielgonzaleztorres]

One thing I did to replicate a form is to save the SharePoint list as a template. Then copy the Form control (CTRL + C) from the original, delete the form that you are trying to customize from the template and then Pasted it (CTRL + V).
So long as the columns are named the same, Power Apps can recognize them. You may have to check the formulas if you are referencing other stuff but it’s posible.

[kanwalsingh]

Hi Shane, I am facing a challenge. I have customer a form in power app and saved & Published but still can not see the customized form in SharePoint list. I have done the basic troubleshooting like refreshing data source in power app, republished, refreshed SharePoint list multiple times, tried different browser but still no luck. Any tip please?

[danieldickinson]

Great video, I came across the same issue when I open the resized form it was opening at the smaller window, I did find a fix.
go in the List settings>Advanced Settings>"Launch forms in a dialog?" was set to launch in a dialog set to no and that fixed it.

[pkp]

Hi Shane, thank you so much for the video. Is there any way we can make forms responsive like apps?

[simonesteevens]

Hello Shane, can I create a PowerApp Form with minimal fields but then still have the option to edit ALL columns when I hit edit in SharePoint List?

[lepettit]

This video is exactly what I needed, particularly learning how to edit the different modes...new, edit, submit, etc.
Do you have a video that reviews the different formulas that can be used in Power Apps or recommend a website? Thanks for the info.

[jl]

How do you use the patch formula that allows a button to update the status of the item when selected? it seems to be much more difficult with a sharepoint integration form

[teridittmann]

Hi Shane, thanks for the video! Hoping you can help with an issue I'm having between my SharePoint List and the Power Apps Form. I'm selecting a record from a SharePoint List using a dropdown, but the value of the record is only shown on the form, and is blank on the Sharepoint list. Any idea why this might be happening?

[dtodounpocomx_nl]

Hi, I having troubles, when I click on customize form, power apps creates a form but only title column is shown, the rest of columns/fields are not added, do you know why?

[stevenhampson]

Thanks Shane. Great idea to include the 'what not to do' aspect.
Two questions -
1) Licensing - does each user who uses the power app integrated form need a power apps licence? If not, what is required?
2) When you had the email button, it asked you to allow permissions and then sent the email from your email account. Will each logged in user be sending emails from themselves, or is it from you as the author of the app?

[travissmithoh]

Am I missing something, or does Power App Custom Form for SP not allow multi-select fields?

[tanishamatthews]

I wish you would have shown how to get rid of the tiny, tiny form when it displays in SharePoint. It's so annoying and I haven't found any way to get past it other than wait a few days and try again. Sometimes I'm unable to wait a week for it to correct itself. Very little online about it. Thanks for the video.