Power Platform Community Forum Thread Details

Hi

I’m fairly new to building Power Apps.

I’ve created a dev and prod environment and a pipeline within a dev solution to deploy my app to the prod environment. My app ingests an excel file from a folder on a SharePoint site and puts it into a Dataverse table. It uses power query within a Power App dataflow to retrieve the excel file from the SharePoint site. The folder it retrieves this excel file from changes depending on the environment.

Is it possible to dynamically change the data source SharePoint URL within the dataflow depending on the environment (dev or Prod)? I have an environment variable which is either ‘Test’ or ‘Live’ depending on the environment we are in:
sharepoint.com/sites/Test/Pending/data.xlsx
sharepoint.com/sites/Live/Pending/data.xlsx

I would like to use an environment variable in the URL to alter which folder it is looking at so when I deploy from dev to prod I don’t have to manually change the folder path to the files from ‘Test’ to ‘Live’.

sharepoint.com/sites/<Environment Variable>/Pending/data.xlsx

Is that possible, or is there another way of achieving this?

Categories:

Building Power Apps