Power Platform Community Forum Thread Details

Another day, another Dataverse puzzle !

I have a solution that exists as unmanaged in DEV and managed in TEST and PROD environments. There is a custom option set that is used in a table and also in a powerapps combo box using the choices function. There is another option set in the environments that is named almost the same but it is not included in the solution. In DEV and PROD the table column points towards the correct option set, but in test the column points towards the wrong one.

I recently changed the options and noticed that in the DEV application the options changed, but not in the test version. The option set itself has updated the values but the application shows the wrong ones. The patch function which updates the choice column works in the app. This makes me believe the test app is also pointing to the wrong option set, although I have no idea how when the code clearly points to the correct one.

What I believe could have happened is the following :
1) Creation of new table column in dev pointing towards the wrong option set

2) Solution pushed to test environment with the wrong option set

3) Deletion of column in DEV and recreation pointing towards the correct option set

4) Solution pushed to Test again but because the options were the same in the two option sets it wasn't noticed that it hadn't updated

5) Solution pushed to PROD where the column was created using the correct option set

This is all just a theory, but I don't see how else there could be a column pointing to two different option sets in different environments.

Now I need to sort this mess out and am at a loss as to how...help please !

I tried deleting the column in test to then reimport the solution, but as it is managed I am unable to delete the column. I don't want to delete the column in dev, reimport to test to delete the column then readd again in dev in case it blocks when I move to production or worse, deletes the column and readds it and we lose all the data !

I suppose I could just leave it since the production version is correct, but I obviously I would rather the test solution was a correct reflection of what will be seen in prod.

Any thoughts ?

Categories:

Microsoft Dataverse with Power Apps