Forum Discussion
Post PatronMicrosoft Fabric Dataflow Gen2- How to read data from SharePoint Online list and load data into Lake
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.
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).
1 Reply
- christinepayton
Most Valuable Professional
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).