Forum Discussion
Use Table.ExpandRecordColumn to convert SharePoint Author to Name?
I beat my head against this enough and figured it out. If anyone else needs this in the future.
1. Go into Transform data
2. Find the field reference as a record by scrolling far over on right of columns
3. Click the double arrow
4. Select the record fields you want, such as Title for full name.
5. Apply changes
Now you will have a new column available called Author.Title or Editor.Title.
The advanced editor adds these lines.
#"Expanded Author" = Table.ExpandRecordColumn(#"PREVIOUS LINE ENTRY", "Author", {"Title"}, {"Author.Title"}), #"Expanded Editor" = Table.ExpandRecordColumn(#"Expanded Author", "Editor", {"Title"}, {"Editor.Title"})
I beat my head against this enough and figured it out. If anyone else needs this in the future.
1. Go into Transform data
2. Find the field reference as a record by scrolling far over on right of columns
3. Click the double arrow
4. Select the record fields you want, such as Title for full name.
5. Apply changes
Now you will have a new column available called Author.Title or Editor.Title.
The advanced editor adds these lines.
#"Expanded Author" = Table.ExpandRecordColumn(#"PREVIOUS LINE ENTRY", "Author", {"Title"}, {"Author.Title"}),
#"Expanded Editor" = Table.ExpandRecordColumn(#"Expanded Author", "Editor", {"Title"}, {"Editor.Title"})thanks a million!
