Forum Discussion
Getting user names from a Sharepoint.files() extraction (Power Query)
From Sharepoint, I am able to extract a table containing filenames, file extensions, and dates... https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder However, I would like to...
On the first steps of the query, identify this record column (FieldValuesAsText)
Expand this column by checking Editor (user who last modified) and any other column you need.
And that's it! 🙂
The field you refer to is not in the table retrieved in that initial query
If you refer to this link you will see the initial data under the item 3 of "Connect to a SharePoint folder from Power Query Desktop"
Where do you see this field under ?
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
