cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mattbell
Advocate I
Advocate I

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

1 ACCEPTED SOLUTION

Accepted Solutions
capoaus75
Frequent Visitor

This issue seems to have been resolved on my tenancy.

 

Also there was an issue with "Allow searching" in combo box. If the option was ON, when the solution was imported to a new environment the "Allow searching" option was OFF in the imported canvas app.  From my tests this issue has been resolved as well.  Definitely few steps in the right direction for ALM. Well done Microsoft!!!

View solution in original post

12 REPLIES 12
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 V
Advocate V

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 V
Advocate V

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.

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,917)