03-05-2019 05:55 AM
Learn how to minimize controls in your app by using only 1 form, and only 1 gallery, for multiple SharePoint Lists in this week's Friday Functions video.
This is relevant when all the list columns are identical. For example, imagine you are publishing an app for 5 departments, where they are each submitting the same requests to a SharePoint site collection dedicated to their department.
Benefits: A. Minimize controls, B. No need to have duplicate apps for each department, C. Reduces the number of items in each list (so that you reach delegation limits less quickly), and D. If really 1 site per department; permission things using the Office 365 Users Department Property
Note: If permissions are different, please leverage the DataSourceInfo() and/or IsError() functions to trap the users permissions when all data sources are in the app, AND only use one connector instance for all SharePoint lists. Be careful taking this approach across international regions as the rule is to keep apps, and data in the same environment/region where your end users will be using them.
Helpful Resources:
Forms:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-form-detail
Patch Function:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
If/Switch Functions:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-if
IfError Function:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-iferror
DataSourceInfo Function:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datasourceinfo
watch?v=lSo7u5jIpXk
Hi Audrie,
This is AWESOME! Thank you for creating this video. I am very new to using PowerApps, and I took on a huge challenge in my company to create an app that is modeled after the sample Service Desk App. I wanted to have data records created by the app saved into SharePoint list, and I was struggling with how to patch to an SPList when one of the fields I am trying to patch is a combobox that needs to save multiple selected items to a SPList choice column.
I have spent nearly a month searching on line and trying to understand what the correct Patch() syntax would be to do this and I was getting close, but could not get it to work... until I found this video. Now the one major hurdle I was up against is solved! THANKS TO YOU!