web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Multiple SharePoint li...
Power Apps
Unanswered

Multiple SharePoint list forms in one app

(0) ShareShare
ReportReport
Posted on by 1,599 Super User 2024 Season 1

Hello,

 

I have been creating a power app where I can select a form from a menu, where the OnSelect for each form takes you to a new screen with the form fields to fill out and submit to a SharePoint list.

 

Each SharePoint list uses it's own content type with approximately 60 fields for each. 


In total, there are 10 forms to choose from which means there are 10 SharePoint data sources connected to the one app. 

Whilst it takes a while to edit the App in edit mode (10-20 seconds), it doesn't appear long to open the App itself.

 

One of the requirements for this app is the ability to save forms down into a collection so that they can be used Offline using the Power Apps desktop app - do you see any issues with an app with so many forms and going offline?

I am assuming that one button wouldn't be able to sync all 10 lists for offline use? (or at least just syncing the data that relates to the user who created their previous items.

 

Due to the team who will be using this App, are fairly non-IT savy, it needs to be as easy as possible to use and hence why i've created just one app rather than 10. 

 

There doesn't appear to be any best practices around this.

 

 

Categories:
I have the same question (0)
  • cha_cha Profile Picture
    4,932 Moderator on at

    Hello @sudosaurus 

     

    Is the use of JSON not possible in your scenario? I think the use of JSON will greatly reduce the load on the app.

     

    On SharePoint's end, you can keep all the columns but only update them via the JSON from the Power Apps thru Power Automate.

    cha_cha_0-1669121964981.png

     

    PowerApps JSON

    https://www.youtube.com/watch?v=FqfLiJDdC3Q&ab_channel=RezaDorrani

     

    Power Automate Compose, Join, Select, Filter, Create tables, Parse JSON | Data Operations in flow

    https://www.youtube.com/watch?v=qxFx0hqJxj4&ab_channel=RezaDorrani

     

     

  • thirukumarans Profile Picture
    16 on at

    Create 10 screens and add each data source to each screen then in the onselect property of the home screen navigation button just navigate to the respective screen,then in the onvisible property of that particular screen as onscreen= newform('Form Name'). For collection, save all the forms in the same collection and create variable based on the screen name. So, while retrieving it'll show only that particular item. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard