How to use an environment variable as the source in a dataverse dataflow

(0) Share

Report

Posted on by Barks365

In Dynamics 365 power app, I have a dataverse dataflow that uses power query to connect to a dataverse table. All works fine in dev, however everytime we deploy to another environment we have to manually update the datasource. Is there a way to use an environment variable e.g. in the following line in dataflow advanced editor..

let

Source = CommonDataService.Database("oursite-dev.crm11.dynamics.com"),

#"Navigation 1" = . . .

E.g. I want to be able to do something like this..

let

Source = CommonDataService.Database(EnvironmentVariables("siteUrl")),

#"Navigation 1" = . . .

Many thanks

All responses (3)

Answers (0)

Kinson-Lam (WCC) 2 on at

Like (0)

Report

How to use an environment variable as the source in a dataverse dataflow

Any clue for this? I am keen to know how to use environment variables inside dataflow. thanks
fshaikh 216 on at

Like (0)

Report

How to use an environment variable as the source in a dataverse dataflow

Hi,

Is there any solution to this problem yet?
UR-06110101-0 4 on at

Like (1)

Report

How to use an environment variable as the source in a dataverse dataflow

Hello! Did you get a solution on this? I am facing the same issue