OneDrive Excel File Metadata (data modified)

[Anonymous]

How can I get the date an Excel file was last modified with a OneDrive connection? It is easy to do with a local file, but I cannot figure out how to get it to work with a OneDrive file.

[edhans · Accepted solution]

Use the SharePoint Folder connector. OneDrive is just a personal sharepoint site.

1. To get the URL, go to your Office 365 home and click on OneDrive
2. get your URL, it will look something like this:
   1. https://tenantnamecom-my.sharepoint.com/personal/firstname_lastname_tenantname_com/_layouts/15/onedr...
   2. Get rid of the layouts and later, so it becomes this:
   3. https://tenantnamecom-my.sharepoint.com/personal/firstname_lastname_tenantname_com/
3. Paste that into the SharePoint folder connector
4. Log in

You will now have a standard file directory listing with the metadata you need.