Billy Ewton

I recently encountered an issue with SharePoint integration on a Portal site where, after adding several new fields to a custom table, uploaded documents were being saved to a different folder in SharePoint than where they were originally being uploaded to. I have SharePoint integration configured to create the folder structure based on the Contact entity. The new fields I created in the custom table were lookup fields to the Contacts table. This resulted in each field creating a new one-to-many relationship with the Contacts table.

According to Microsoft, the logic that creates the folder structure in this scenario will create that folder structure based on the column with a one-to-many relationship with the Contacts table. Since I now had multiple columns that fit this description, the logic did not know which one I wanted to use so it uploaded documents to the root of my SharePoint document library instead.

I would like to request a feature that will allow us to select the one-to-many relationship to use for the folder structure in this scenario.