Forum Discussion
Create a date custom column by file date
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
MarcelBeug one more thing: what if it was an xls / xlsx document?
That would be very similar: just replace Csv.Document with Excel.Workbook.
Is there also any way to get modified/created date out of file when the file is stored in the SharePoint?
Iam connecting to it with powerbi using get data "web"
Hi,
I have the same issue.
I would like to display the creation date of an excel file in my report.
Any idea how to read and display it?
Thanks a lot for helping.
Rob
