cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Scaling large Power Apps deployment

Hello!

 

Within our customer service teams, we have over 75+ PowerApps. The design is almost identical between each of them. There is a form connected to a SharePoint list on Screen1, then a gallery connected to SharePoint, and a bit of code in a button to collect all the info and trigger a flow. 

 

Now this works really well, but we have found the scaling challenging, as every amendment requires you to go into every app.

 

Does anyone have any similar experience scaling projects? In an ideal world we would only have 1 app, and it would dynamically change data source / chose relevant code etc.

 

Any suggestions on how to deploy this are greatly appreciated.

 

NOTE - Component Libraries can be part of the solution, but are not the entire solution. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

@mdevaney 

Maybe I got it wrong, but as I understood OP he has 75+ apps that are kinda-identical, but the only difference is the data source. The challenge is to dynamically access a different data source for each app.

 

I'm not sure about the performance if you have 75+ data sources connected to the app and a switch statement accessing a different table based on a condition. Might be good... might be bad. Something to try out, I'd say 🙂

 

Cheers

Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.

View solution in original post

4 REPLIES 4
Super User III
Super User III

@AndyH_JSY

It is possible to show several different datasources in a single gallery but the catch all datasources must have the same column names.  Therefore, you must use SHOWCOLUMNS to get only the data you need and RENAMECOLUMNS to put the data into standard column names.


Here's some sample code for the Items property of a gallery.

Switch(
    varDatasourceSelected,
    "A",
    RenameColumns(
        ShowColumns(
            TableA,
            "Asset Name"
            "Asset Category"
        ),
        "Asset Name", "Title",
        "Asset Category", "Subtitle"
    ),
    "B",
    RenameColumns(
        ShowColumns(
            TableB,
            "Vehicle Name"
            "Vehicle Location"
        ),
        "Vehicle Name", "Title",
        "Vehicle Location", "Subtitle"
    )
)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Blog: https://matthewdevaney.com 
 

Super User
Super User

Hi @AndyH_JSY 

 

Unfortunately, it is not possible to have a dynamic SharePoint data source in Power Apps. The approach you described is what everyone needs to go through. 

If you would consider using Dataverse for Teams, however, the whole thing would look different. Dataverse for Teams uses (as the name suggests) dataverse as a data source. If you deploy that app to another team, a new data source for that team will simply be created on-the-go. Kinda solving your issue, eventually.

 

If you would like to semi-automate the deployment process, you could export your Power Apps (.zip). Then, modify the json file it includes to match the destination URLs and GUIDs, pack it back together to a zip file and upload it again.

This sounds quite cumbersome, but there is actually a script created by @DenisMolodtsov doing all that.

I've created a blog post about it (it says it migrates SharePoint Forms, but it also works with regular Power Apps).

--> https://fabianackeret.com/copy-power-apps-sharepoint-form/

 

I hope this helps and answers your question.

Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.

@FabianAckeret 
If my memory serves, its true that you cannot have a dynamic datasource for a gallery in Power Apps but you use table-shaping features and a conditional statement to show different datasources within the same gallery.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Super User
Super User

@mdevaney 

Maybe I got it wrong, but as I understood OP he has 75+ apps that are kinda-identical, but the only difference is the data source. The challenge is to dynamically access a different data source for each app.

 

I'm not sure about the performance if you have 75+ data sources connected to the app and a switch statement accessing a different table based on a condition. Might be good... might be bad. Something to try out, I'd say 🙂

 

Cheers

Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (54,080)