PowerApps | Using Defaults and Reset Functions when Patching SharePoint

Published: 05 July 2021
on channel: Andrew Hess
6,602
75

Your fields while using a Patch function don't realize if they are in an 'Edit' or 'New' page. In this video we go over the different way to write defaults for single line text, dropdowns, and combo-boxes for our Patching Statement which writes to SharePoint.

Then we set our patch statement up to edit previous entries by setting the Defaults equal to the ID in SharePoint.

Also we create a global variable to let our Form know if we are in 'Edit' or 'New' mode. Finally we define our Reset functions on the OnVisible property of our screens.

Part 1:    • PowerApps | Gathering Requirements using S...  
Part 2:    • PowerApps |  UX/UI Wireframe / Mockup Desi...  
Part 3:    • Video  
Part 4:    • PowerApps | Convert Single Line Text to Co...  
Part 5:    • PowerApps | Using Defaults and Reset Funct...  
Part 6:    • PowerApps | Using Coalesce for Data Valida...  
Part 7:    • PowerApps | Create Perfect Waffle Sliding ...  
Part 8:    • Video  

Chapters:
0:00 Introduction
1:49 Creating Global Variable
2:49Default Single Line Text
5:05 Default Dropdown
8:15 Default Combo-box
10:04 Default select previous entry in Patch Statement
11:53 Reset fields

Global Variable
Set(varForm="Edit")
Set(varForm="New")

Default:
Single Line Text
If(varForm="Edit",galSocialMedia.Selected.NumViews,"")

Default:
Dropdown
If(varForm="Edit",galSocialMedia.Selected.TypeofSocialMedia,"1")

DefaultSelectedItems:
Combo Box
If(varForm="Edit",Filter(["","English","Spanish","French","German","Mandarin","Cantonese"],Value in Split(galSocialMedia.Selected.Language,",")),[])

Concat in combobox:
Concat(cmbLang.SelectedItems,Value,",")


On this page of the site you can watch the video online PowerApps | Using Defaults and Reset Functions when Patching SharePoint with a duration of hours minute second in good quality, which was uploaded by the user Andrew Hess 05 July 2021, share the link with friends and acquaintances, this video has already been watched 6,602 times on youtube and it was liked by 75 viewers. Enjoy your viewing!