cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
damienjs
Frequent Visitor

ALM: How to manage Sharepoint connector across dev, test and prod?

Hi All,

 

I'm in the process of trying to work out the best practises around migrating an app that uses a sharepoint list as it's data store between dev, test and prod environments. I currently have build and release pipelines built for the application that will move it between environments and that is working great.

 

The current issue i'm facing is how do i point the application at a different sharepoint site in each environment. I've explored using an environment variable but i cannot work out if it can be used as an input for the Sharepoint connector, is this even possible in this scenario? Is there some other way i can either automatically or manually configure the connection once the app is deployed as a managed application?

 

Cheers,

Damien

1 ACCEPTED SOLUTION

Accepted Solutions
Magesoe
Advocate I
Advocate I

There is currently no way to do this fully automatically. You can move the app between environments, but you would need to manually configure the app once it is deployed.

 

One solution to easy the pain is to have 2 pipelines, one for your regular configurations, forms, views etc. And then one for your things with external connectors like SharePoint. This of course requires 2 different solutions in CDS.

That way you can customize the system, without having to constantly go in and configure your connectors.

View solution in original post

3 REPLIES 3
Magesoe
Advocate I
Advocate I

There is currently no way to do this fully automatically. You can move the app between environments, but you would need to manually configure the app once it is deployed.

 

One solution to easy the pain is to have 2 pipelines, one for your regular configurations, forms, views etc. And then one for your things with external connectors like SharePoint. This of course requires 2 different solutions in CDS.

That way you can customize the system, without having to constantly go in and configure your connectors.

View solution in original post

damienjs
Frequent Visitor

Thanks for the response, really just needed confirmation what i was trying isn't possible.

 

I think i'm going to try convince the client to move the data store to CDS to make it easier for deployment but your 2 solution strategy is really helpful to think about.

JensKofod
Resolver II
Resolver II

it seem that there is a new option as u can now automatically create Power Platform environment variables when connecting to SharePoint list in a Canvas App, and when importing Canvas app in other environment it will ask for which SharePoint list to use... see a demo of it here Now it is time to be Curious about Power Platform Environment Variables! (iiu.dk)

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,772)