Hi there I am currently trying to build an inventory management app that has features to reassign, add , edit etc. I have laid out the app in a editable grid style and am facing problems when trying to reassign a created item. All data for this grid is pulled from a sharepoint list which is stored in a collection, the collection is edited and then new changes are submitted to the sharepoint list through patch. Here is the code for my reassign function:
the column "status" is a simple choice column that indicates the state of the object. When I'm trying to submit the changes to the sharepoint list everything is saving but I keep receiving the following error:
The function that saves the changes is this:
I have faced this problem before as evident by the other column drops present in this formula but when I try to drop Status#Id it doesn't work because within the schema I cannot see a column that goes by that name. I have tried everything and really don't know what to do I have tried disabling formula level error management which fixes the problem but I'd rather not do this as it breaks other features within my app. Any advice would be appreciated thank you
