Python Script to 'Get Data' from a 'Folder' and read the 'Last Modified' Date?

[Anonymous]

I am looking for someone to help me with a Python script to be able to load some folder data into a PowerBi dashboard, which gives me a table of the 'Last Modified' date/time.

So when I click 'Get Data' > 'From folder', I have an excel file which I have in this folder where the date and time of the 'last modified' date of a file is kept. This will be used to add a LAST REFRESHED 'card' to the dashboard so users know when it was last refreshed.

Can someone guide me how to do this using Python. For information - the dashboard is saved in a SharePoint. So the folder path currently looks like this: https://companyX.sharepoint.com/sites/Folder/Shared%20Documents/General/ExcelSpreadsheet.xlsx

[Jimmy801]

Hello @Anonymous 

question: Why are you not using the simple build-in function Folder.Files?

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy