Skip to main content

Notifications

Microsoft Dynamics CRM forum
Unanswered

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

Posted on by 5

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

  • fshaikh Profile Picture
    fshaikh 164 on at
    How to use an environment variable as the source in a dataverse dataflow
    Hi, 
     
    Is there any solution to this problem yet?
     
  • 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

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,907 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,189 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans