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 know what user modified the file.
I cannot find how to add this field to the query.
This is a similar request that was not answered either.
https://community.fabric.microsoft.com/t5/Power-Query/How-to-Power-BI-list-Document-Property-Last-Modified-Person-Name/td-p/2085421
3 Replies
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
I don't seem to have that column.
Attributes do not contain either Editor or Author
Related: https://community.fabric.microsoft.com/t5/Power-Query/How-to-Power-BI-list-Document-Property-Last-Modified-Person-Name/td-p/2085421
