SharePoint Data Connection as a Variable

[lliu_western]

Hello community, 

I have three SharePoint sites for Development, UAT and Production. When the Flow is in the DEV environment, the trigger of the Flow connects to one of the lists in the Dev SharePoint site.

However, when I export the Flow from Dev and Import it into UAT, I have to manually change the SharePoint connection within the Flow so it is connected to the list in the UAT SharePoint site.

Is there anyway to set the "Site Address" to a environmental variable? Any tips is appreciated. Thank you.

[Jcook]

Hello @lliu_western 

Yes, you can use Environment Variables to achieve this. Check out my Blog post on how to do this:

https://flowaltdelete.ca/2020/09/09/using-environment-variables-as-parameters-for-power-automate-dep...

Also a great video by Kent Weare can be found here:

https://www.youtube.com/watch?v=gTcDcOH3V0E