Hello,
I have an issue with using a combination of Environment Variables with SharePoint as a Data Source. Here are the steps taken:
- Created a SharePoint List with couple of different fields: single line of texts, person, choice, etc. Nothing fancy.
- Created a solution in one environment, added environment variable for previously created site and list
- 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:
- Removed current value of Environment Variables
- Published all customization
- Exported solution
- Created fresh site in other environment using PnP Provisioning
- 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