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