Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Portals
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find partner offers
    • Partner GTM Resources
    • Blog
    • Customer stories
    • Developer Plan
    • Documentation
    • For IT Leaders
    • Roadmap
    • Self-paced learning
    • Webinars
    • App development topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power Apps Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Connector Development
    • Power Query
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog
    • Power Apps Community Blog
    • Galleries
    • Community Connections & How-To Videos
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Business Value Webinars and Video Gallery
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Ideas
    • Power Apps Ideas
    • Community Engagement
    • Demo Extravaganza 2021
    • Demo Extravaganza - Components 2021
    • Power Apps Community Demo Extravaganza 2020
    • Experimental
    • Error Handling
    • Power Apps Experimental Features
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Webinars and Video Gallery
    • Reuse Forms/Galleries for multiple SharePoint list...

    Reuse Forms/Galleries for multiple SharePoint lists!

    10-28-2018 00:56 AM - last edited 10-28-2018 01:41 AM

    Power Automate Audrie-MSFT
    Power Automate
    3448 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Audrie-MSFT
    Power Automate Audrie-MSFT
    Power Automate
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Reuse Forms/Galleries for multiple SharePoint lists!

    ‎10-28-2018 12:56 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

    Preview file
    301 KB
    Labels:
    • Labels:
    • Friday Function Series
    • SharePoint Magic
    Message 1 of 4
    3,448 Views
    2 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    Crockerfeller
    Crockerfeller Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎11-09-2018 05:46 PM

    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! 

    Message 2 of 4
    3,227 Views
    2 Kudos
    Reply
    Anonymous
    Not applicable
    In response to Crockerfeller
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-05-2019 05:55 AM

    Am stuck with patching .With this video i fot close but getting error that says too many records

    Preview file
    17 KB
    Message 3 of 4
    2,945 Views
    0 Kudos
    Reply
    Anonymous
    Not applicable
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-05-2019 05:57 AM

    Any suggestions are welcome as i have been pulling my hair for days

    Preview file
    17 KB
    Message 4 of 4
    2,944 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2022 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks