Microsoft Fabric Dataflow Gen2- How to read data from SharePoint Online list and load data into Lake

[dd88]

I have a SharePoint data list, with columns fields that contains data values. Users author names are obtained from Microsoft365.

Users view

I want to load and connet the SharePoint list in Fabric and load the data into a lake

1. In Microsoft Fabric, I select Data Factory, New Dataflow Gen2
2. Select Get data, More, SharePoint Online list
3. The Sharepoint Online List, I add the base url
eg https://companyname.sharepoint.com

4. In Choose data, select Documents

The results, the column fieldnames display. However the data values do not. Instead it displays [Record]. and author names which are entered from Microsoft 365 displays as an ID number.

What do I need to do to get this working ie display the actual column field data valued

 

TIA.

[christinepayton · Accepted solution]

This is normal depending on which field types you're looking at. Person-type fields are referencing people profile records, so you have to click the double arrow to expand to get either their name or email - I think in the menu, the display name is actually called "title". 

Choice columns usually have their value listed in a column somewhere in there in addition to the "record" column, if they're single value. I'd do a search in the view tab for the column name or just scroll and look around a bit more. If it's a multivalue field, you'd need to expand the values kind of similarly to the person-type column (be careful for row duplication, if you're working with multiple values - iirc you can expand them into a single cell and comma separate, but I usually do it in a separate table as a dimension and relate them).