Forum Discussion
Get File Properties Excel.Workbook(Web.Contents
Is there a way to return last modified property when accessing Excel.Workbook via Web.Contents?
let
Source = Excel.Workbook(Web.Contents("https://org.sharepoint.com/personal/username/Documents/Folder/ExcelFileName.xlsx"), null, true)
2 Replies
Hi MarkMunro ,
According to your description, you can click advanced editor in power query to see all the execution steps.
There are specific execution steps on the right, you can add, delete and change the corresponding steps.
If the problem is still not resolved, please provide detailed error information and related screeenshoots. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.The goal is to utilize a link that is shared with me, via One-Drive. I have been granted READ access to a web link to view the content of an excel file. I also want to be able to identify when the file was last modified. READ access to the file via ONE-Drive using Shared with me works using the example above. Is there any way to see the file properties, last modified?
