cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anubhav247
Helper I
Helper I

Missing setting "Automatically Create env variabes when adding datasource" in dataverse for teams app?

Dear Experts,

Am trying to find the setting shown below

anubhav247_0-1645122773617.png

My app will have different sharepoint list as datasource in different environment. 

 

I cant find this setting when i try to create an app in dataverse for teams.

Is there a reason..or is it by design? How do i do ALM in such a case?

 

Regards,

Anubhav

@Anonymous 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PowerRanger
Super User
Super User

@anubhav247 In PowerAutomate you would use it just as any Envrionment Variable. You should see them in the Dynamic Contents.

 

In PowerApps, you would add a datasource as you would normally do but you do not select the Site from the "Recent Sites" Tab but from the "Advanced" Tab.

 

I have created a DataSource Variable (type Datasource-Site) with the Name: SharePoint SiteCollection Demo

 

PowerRanger_0-1645258759543.png

 

After you have selected the Site you would also do not select List from the "Lists" Tab but again from the "Advanced" Tab. I have created an Environment Variable of Type Datasource-List with the name: SharePoint List Demo

 

PowerRanger_5-1645258931157.png

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

6 REPLIES 6
PowerRanger
Super User
Super User

@anubhav247 I am not sure but I guess this is by design. However, you should be able to add an environment variable to your solution manually and then use it in the app.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

Yes we tried that, we created 2 environment variables. One which allows you to store sharepoint site url

Another which stores list name(these variables are not text type instead these are specific type which are meant for storing sharepoint datasource details. ).

 

Now when I creat my app(dataverse for teams App) how can I add an environment variable as a data source..?Just like we use any other environment variable is it..?

PowerRanger
Super User
Super User

@anubhav247 In PowerAutomate you would use it just as any Envrionment Variable. You should see them in the Dynamic Contents.

 

In PowerApps, you would add a datasource as you would normally do but you do not select the Site from the "Recent Sites" Tab but from the "Advanced" Tab.

 

I have created a DataSource Variable (type Datasource-Site) with the Name: SharePoint SiteCollection Demo

 

PowerRanger_0-1645258759543.png

 

After you have selected the Site you would also do not select List from the "Lists" Tab but again from the "Advanced" Tab. I have created an Environment Variable of Type Datasource-List with the name: SharePoint List Demo

 

PowerRanger_5-1645258931157.png

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.
ReinerKnudsen67
New Member

Create a new "SharePoint" connection and confirm the user to connect with.

Then instead of selecting the site or list directly, click the "Advanced" tab and find your environment variables.

For Future readers...Advanced tab will only be visible if the environment variable already exists.

 

@PowerRanger Thanks a lot!!

I am also struggling with changing value of environment variables when deploying a managed solution in production(Again a dataverse for teams Environment).  Any good blogs you have in mind....really appreciate your response...thanks

 

PowerRanger
Super User
Super User

@anubhav247 that's a good point regarding changing environment variables in Dataverse for Teams Environments. As there is no default solution you can't change them

 

Workaround I use. 

Create an unmanaged Solution in that Environment and add the Environment variables. You will now be able to edit those 😁

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,115)