Get File Properties Excel.Workbook(Web.Contents

[MarkMunro]

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)

[MarkMunro]

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?

[v-henryk-mstf]

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.