cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mattbell
Frequent Visitor

Data Source Environment Variables not working for combo boxes based on SharePoint

Hi
I have migrated a solution between environments.  The solution includes an app whose data is based on a SharePoint library.  There are some combo boxes in a form which were automatically created from the choice fields in the SharePoint datasource.

When I import the solution I update the datasource EV to the correct SharePoint site.  This works correctly in the app apart from on the combo boxes.  I need to delete and re-connecting the datasource and that fixes it.  A refresh doesn't work, and re-connecting the data source using the EV works.

A bit of a nuisance because I obviously don't want to touch the app in the destination environment.

Anyone else experienced this and knows a fix?

 

Thanks

Matt

11 REPLIES 11
Rohit4044041
Helper II
Helper II

I confirm, I see same behaviour. 

 

In my case i had removed app from one tenant to another with datasoruce environment variables. However, once soluton improted to destination, my power app was still referring source varaible values and datasource did not change. 

Anja1
Regular Visitor

I have the same issue. 


When using a managed solution, I unfortunately cannot customize the app.

And even in an unmanaged solution, I don't want to take any manual steps when deploying to the target environment.

I think environment variables have a lot of potential once all the bugs are fixed.

Is there any news about the bug?



dave-jorgensen
Advocate IV
Advocate IV

Yes, same issue here - environment variable sharepoint datasources in apps don't update with changes to the environment variable. Would be nice if Microsoft would keep things that don't work out of the platform until they were ready to go.

lorettalee
Regular Visitor

Yes, same issue for me. The Environment variable basically is useless for my PowerApp with a SharePoint form. I cannot make the updated value of the environment variable work.

 

Is there any news about this bug?

dave-jorgensen
Advocate IV
Advocate IV

I have a ticket open on the item. It is a known bug. It was suggested (not promised) that update at the end of September may include the fix for this.

EricRegnier
Super User
Super User

@dave-jorgensen@Anja1@lorettalee @mattbell Have you guys seen the recent announcements for Connection Reference enhancements and the ability to set in pipelines/PowerShell? This might help: https://powerapps.microsoft.com/blog/announcing-the-public-preview-for-connection-references-support... 

I don't see that helping as that is for setting the connection reference. The issue isn't the value in the connection reference, it's the value in the PowerApp, and that if you set it to a connection reference, it doesn't use the connection reference value in your target environment. IE if you change the environment reference in your target environment, PowerApps still uses the value set when you exported the solution.

mattbell
Frequent Visitor

Mine are managed solutions but I can amend the app by going into the apps section of powerapps.  The app is part of the managed solution but I don't attempt to amend it from within the solution.

Dave_jorgensen
New Member

Hi mattbell. The fact that you need to edit the app is the bug. You should only have to change the environment variable current value.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,582)