Environment Variables and Choices() function issue

[mpilarczyk]

Hello,

I have an issue with using a combination of Environment Variables with SharePoint as a Data Source. Here are the steps taken:

1. Created a SharePoint List with couple of different fields: single line of texts, person, choice, etc. Nothing fancy. 
2. Created a solution in one environment, added environment variable for previously created site and list
3. Created canvas app in that solution, added connection to SharePoint with usage of previously created environment variables. Created screens for listing and editing items. All works fine for that part.

After that wanted to move that solution to a different environment in a different tenant. Here are steps taken:

1. Removed current value of Environment Variables
2. Published all customization
3. Exported solution
4. Created fresh site in other environment using PnP Provisioning
5. Imported solution to other environment, choosed new site and list.

Now what happens is that after doing all of these steps, app itself runs okay but when trying to edit or create a record an error is thrown, saying that "The specified record was not found. List not found". When opened app in edit mode all of the fields that are using Choices() function are failing with that error, others are working fine. I could fix that by removing data sources and re-adding them again but then whole purpose of Environment Variables is lost. Is there anything that I am doing wrong? Or is it some kind of a Ms bug? (among others...)

Thanks in advance,

Marcin

[PowerRanger · Accepted solution]

Microsoft is already deploying a fix to some customers as far as I am informed. Will take some time till it will reach all Tenant I guess. Actually all complex field Types are not working as expected. 

[SergioPerez]

Hi @leksi31.  Yes, I have. I have been declaring something like this on the OnStart:

ClearCollect(lovStatus, Table( {Value: "Enable"}, {Value: "Disable"}));    //lov --> List Of Values

And replacing "Choices( <SomeList>.Status )" with "lovStatus".

Probably I'm going to create a new list called LOV with two columns: Title and Value. 

Title                    Value

----------             ------------

Status                  Enable

Status                  Disable

And load the lovStatus with a something like this:

ClearCollect(lovStatus, ShowColumns( Filter(LOV, Title = 'Status'), Value));

[BrianMaster]

This was resolved in Power Apps version 3.22022.31. 

[marial16]

Hallo,

how do we find the PowerApps version running?

[BrianMaster]

When editing your canvas app, go to File > Settings > Support.  It is displayed as Authoring version.

[marial16]

 I made a new test importing a solution (with environment variables) in a new tenant. Complex type fields seems to be working this time (Lookups, choices )