Edit: I found a solution - straight forward actually. From within the model-driven app, we added a location and specified the display name and folder name. Documents already in our repository were simply moved to the new folder and everything is working just fine.
I have a model driven app through which users can upload documents to SharePoint.
The folder in SharePoint is automatically created with the PK from my Client's table, along with other characters added.
Most of the users access and upload documents through the app, but some are working directly in the SharePoint folders due to the nature of their work.
It is difficult as the folder names are really non-descriptive.
If I go to my Client Table and look at the relationships, I can see two other tables:
client_SharePointDocumentLocations and
client_SharePointDocuments
I assume the folder name will be in those tables, but I cannot access them.
Is there any way in which I can change the folder names on SharePoint to make it more user friendly? I know I can add a column on SharePoint to have something more descriptive, but the users sync the SharePoint folder to their Onedrive, so that won't solve the problem.
Any ideas on how to solve this problem?