Empowering SharePoint List Forms with PowerApps
"Learn how to enhance your SharePoint list forms with PowerApps, replacing traditional customization methods. Explore basic PowerApps capabilities, redesigning existing forms, and creating advanced forms with rich features like cascading dropdowns and external data integration."
Uploaded on | 0 Views
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Top Form: Using PowerApps to Replace List Forms
Marc D Anderson President, Sympraxis Consulting Co-Founder and President of Sympraxis Consulting LLC, located in the Boston suburb of Newton, MA, USA. Sympraxis focuses on enabling collaboration throughout the enterprise using the SharePoint application platform. Over 30 years of experience in technology professional services and software development. Over a wide-ranging career in consulting as well as line manager positions, Marc has proven himself as a problem solver and leader who can solve difficult technology problems for organizations across a wide variety of industries and organization sizes. Author of SPServices Awarded Microsoft MVP for SharePoint Server 2011-2018
Session Overview For years, we've customized standard SharePoint list forms by adding our own JavaScript or CSS to the page. When we needed more, we turned to InfoPath. But all that should be in our review mirror now. PowerApps is a natural successor to those methods and gives us the ability to create rich forms including old favorites like cascading dropdowns, improved styling, and internal logic. We can also add in great capabilities like maps, imagery, and data retrieved from calls to outside services. In this session, we'll look at: Basic PowerApps capabilities Utilizing connections to SharePoint lists and libraries and other sources Redesigning your existing forms in PowerApps using common examples Creating forms in PowerApps which go beyond what we could ever do in the past
How Have We Customized Classic Forms? JavaScript SPServices Hillbilly Forms Stratus Forms InfoPath Third party forms tools Too many to mention!
Timeline for PowerApps for SharePoint Lists Announced at Ignite 3Q 2017 First available 4Q 2017 General Availability (GA) 1Q 2018
Want Can We Do? Create custom New, Edit, or Display forms for any SharePoint list Form factor "Phone" or "Tablet" Vertical or horizontal Our custom forms replace the out of the box forms
SharePoint Integration : Form Settings We're familiar with NewForm -> OnNew -> NewForm EditForm -> OnEdit -> EditForm DispForm -> OnView -> ViewForm These can all be the same form, or we can customize each form separately
Modern Out of the Box List Forms Not bad, right?
Commonly Needed Capabilities
Commonly Needed Capabilities Conditional Visibility Conditional Formatting Cascading Dropdowns Maps and Other Imagery Prepopulating Columns Multiple List Editing
Conditional Visibility Very common need to show some columns based on the values selected in others
Conditional Formatting Based on values chosen in other fields Based on the value in the current field
Cascading Dropdowns This one is tricky! Quick Steps: Add new dropdowns for the columns you need to interact Set the data sources for the dropdown columns to correspond to those for the SharePoint list columns Change the SharePoint list columns' Default value to reflect the value chosen in the corresponding dropdown Set the Visible property for the SharePoint list columns' card to Off
Maps and Other Imagery If we have an address or latitude / longitude values, we can display a map in our form
Maps and Other Imagery Column formatting Tie the visualizations in forms to the way you display columns in views
Prepopulating Columns - Label Plain text Data from another data source
Prepopulating Columns Lookup Columns { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint. SPListExpandedReference", Id: 198, Value: "United States" } http://sympmarc.com/2018/02/05/powerapps-setting-a-sharepoint-list-lookup-column/
Prepopulating Columns People Picker { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:Concatenate("i:0#.f|membership|",User().Email), DisplayName:User().FullName, Email:User().Email }
Multiple List Editing We can build a single PowerApp which interacts with multiple SharePoint lists
Multiple List Editing We can build a single PowerApp which interacts with multiple SharePoint lists
Multiple List Editing We can build a single PowerApp which interacts with multiple SharePoint lists
Multiple List Editing We can build a single PowerApp which interacts with multiple SharePoint lists
Tips and Tricks Get your information architecture laid down first Rename cards and fields you'll be using in formulas, but don't bother with the rest Do some light branding to distinguish your custom forms from the out of the box forms Refresh a few times after save to be sure you're picking up your edits
References Cascading Dropdowns Anita Boerboom - How to create cascading drop downs using PowerApps April Dunnam - Cascading Dropdowns in PowerApps SharePoint Lookups Maps Pratap Ladhani - Displaying a Map using an Image Control in PowerApps and Bing Maps or Google Maps API General Todd Baginsky - PowerApps Coding Guidelines & Tips Business Apps Spring 2018 Update
