Skip to main content

Notifications

Announcements

No record found.

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 160 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

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans