Forum Discussion
Sharepoint list mirroring
Hey,
As I set up the basic SharePoint list, mirroring most of the data comes through without a problem.
The issue is the fields categorized as User/Group type. (for example: Modified by / Created by fields in SharePoint lists)
They don't seem to return the values, as they are nested data structures that mirroring just skips instead of giving the option to flatten them.
Hi Michal_Tyl,
Thank you for reaching out to the Microsoft Fabric Community Forum.
The issue occurs because SharePoint User/Group fields such as Created By and Modified By are stored as complex nested objects instead of simple text values. These fields contain multiple properties like Display Name, Email, Claims ID, and other metadata. Currently, the mirroring process in Microsoft Fabric mainly supports standard scalar data types, so these nested User/Group columns are skipped instead of being automatically flattened into readable values.
As a workaround, you can create additional text/calculated columns in the SharePoint list to store simple values such as the user’s Display Name or Email, which will mirror correctly. Alternatively, after mirroring, you can use Dataflow Gen2, Pipelines, Notebooks, or SQL/Spark transformations in Fabric to expand and flatten the nested User/Group structure manually. Currently, this behaviour is considered a limitation rather than an issue with your SharePoint list configuration.Please refer these following links:
1. https://learn.microsoft.com/en-us/fabric/mirroring/sharepoint-list?
2. https://learn.microsoft.com/en-us/fabric/mirroring/overview?
3. https://learn.microsoft.com/en-us/fabric/mirroring/sharepoint-list-tutorial?Hope this helps. If you have any questions regarding this, please feel free to reach out us. We will be happy to help.
3 Replies
Hi Michal_Tyl,
Thank you for reaching out to the Microsoft Fabric Community Forum.
The issue occurs because SharePoint User/Group fields such as Created By and Modified By are stored as complex nested objects instead of simple text values. These fields contain multiple properties like Display Name, Email, Claims ID, and other metadata. Currently, the mirroring process in Microsoft Fabric mainly supports standard scalar data types, so these nested User/Group columns are skipped instead of being automatically flattened into readable values.
As a workaround, you can create additional text/calculated columns in the SharePoint list to store simple values such as the user’s Display Name or Email, which will mirror correctly. Alternatively, after mirroring, you can use Dataflow Gen2, Pipelines, Notebooks, or SQL/Spark transformations in Fabric to expand and flatten the nested User/Group structure manually. Currently, this behaviour is considered a limitation rather than an issue with your SharePoint list configuration.Please refer these following links:
1. https://learn.microsoft.com/en-us/fabric/mirroring/sharepoint-list?
2. https://learn.microsoft.com/en-us/fabric/mirroring/overview?
3. https://learn.microsoft.com/en-us/fabric/mirroring/sharepoint-list-tutorial?Hope this helps. If you have any questions regarding this, please feel free to reach out us. We will be happy to help.
Hi Michal_Tyl,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi Michal_Tyl,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.