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.
Hi Anonymous, thanks for your help
I think i'm missing the step where 'i choose the field i want and add it ass column' (and later on, step 5). Usually, when i get a .csv from a folder, i use the 'combine binaries' button, and all of the other columns disappear.
Before combining binaries
After combining binaries
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 Thanks a lot, that worked just fine!
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"
MarcelBeug, good tip.
My new column is containing all of the info. I mean, it does not split into columns. Any ideas how to overcome this?
My file contains Tab separated info
Thanks