SharePoint PowerApps Flow Consulting with Microsoft Form Integration guides you as a starting point to the integration in Power Platform.
EditFormSharePointForm1 OnSave – Submits the changes to SharePointForm1. SharePointForm1 – This is the form that’s used to create, show, or edit the list item. OnNew – How an app responds when a user clicks or taps the New button or opens the Create item form in SharePoint. The SharePointIntegration control communicates user actions between SharePoint and PowerApps. OnEdit – How an app responds when a user clicks or taps the Edit all button or opens the Edit item form in SharePoint. If you have multiple forms, make sure to submit the changes only for the form currently being used. ResetFormSharePointForm1; RequestHide. OnCancel – How an app responds when a user clicks or taps the Cancel button in SharePoint. In this article, we’ll walk through the details of how these forms work and how you can customize them further. Note that if you change this property, the Selected and SelectedItemID properties may stop working. You can’t control the hiding of a form when a user clicks or taps Cancel in SharePoint, so make sure you reset your forms in the OnCancel formula of the SharePointIntegration control. ‘YourListName’ OnNew – Sets SharePointForm1 in new mode. IfIsBlankSharePointIntegration.Selected || IsEmptySharePointIntegration.Selected,First’YourListName’,SharePointIntegration.Selected OnSuccess – Once the item is created or saved successfully, the form is reset and SharePoint hides the form. Item – The selected item from the list. OnView – How an app responds when a user clicks or taps an item or opens the Item detail form in SharePoint. If you’ve customized a form for a SharePoint list, you’ve likely noticed that the default generated form works for all operations, like creating, showing, or editing an item. You can use OnNew, OnView, or OnEdit formulas to run logic before the form is shown to the user every time. Understand the SharePointIntegration control. This is set to First item in the list for your convenience when working in PowerApps Studio. These properties may not be available in OnStart or OnVisible. Make sure to include RequestHide in the OnSuccess formula of all your forms. The default generated form consists of the following controls and their corresponding defaults: FormScreen1 – This is the screen that contains the form. Here are some things to keep in mind when you customize forms: To create separate custom experiences for creating, showing, or editing an item, set the OnNew, OnView, or OnEdit formulas of the SharePointIntegration control to set variables or navigate to different Microsoft Flow Integration Consulting screens. Understand the default generated form. ViewFormSharePointForm1 OnEdit – Sets SharePointForm1 in edit mode. Data Source – The list that contains the record that the form will show, edit, or create. Data Source – The list for which the form has been customized. On successful submission of the form, the SharePointForm1.OnSuccess formula is executed. Note You can access the properties for the SharePointIntegration control only when the form is running in SharePoint, not when you’re customizing the form in PowerApps Studio. NewFormSharePointForm1 OnView – Sets SharePointForm1 in view mode. These defaults ensure that the form works when running within SharePoint Power Platform Integration Consulting – they change the PowerApps form mode as the user interacts with it in SharePoint, and they ensure that the changes are submitted to SharePoint. Use the OnSave formula of the SharePointIntegration control to customize what happens when a user clicks or taps Save in SharePoint. If you forget this, SharePoint will not know when to hide the form. OnSave – How an app responds when a user clicks or taps the Save button in SharePoint. Customize the default form. SharePointIntegration – The control responsible for communicating user actions between SharePoint and PowerApps. The SharePointIntegration control has the following properties: Selected – The selected item from the SharePoint list. Now that you have a better understanding of the default generated form and the SharePointIntegration control, you can change the formulas to further customize the forms. You can now easily customize any SharePoint list form in PowerApps. SharePoint always hides the form when a user clicks or taps Cancel in SharePoint. Data Source – The list for which the form has been customized. Tip Set different values for a variable in the OnNew, OnView, and OnEdit formulas. ResetFormSharePointForm1. SelectedListItemID – Item ID for the selected item in a SharePoint list. This is accomplished with the help of generated formulas and the SharePointIntegration control. You can use this variable in the OnSave formula to determine which form is being used. SubmitFormSharePointForm1 OnCancel – Resets the changes to SharePointForm1. The properties for the SharePointIntegration control may not be available in OnStart or OnVisible, and those events execute only once while the list is loaded.