I have a SharePoint folder with Excel files containing addresses in it. Everytime a new Excel file is added, I want a new "copy" Excel file to be created with 2 additional columns (latitude and longitude of each address) in the "With Coordinates" folder of the SharePoint. I have a Python script on VS Code taking the hard coded files and returning the file with Coordinates, however I don't know how to automate the whole process. I have tried using Power Automate and using http to call an Azure function that will send the excel file name and path to the Python script. The issue is that I don't have the functionalities needed to do that as I don't have the premium version of Power Automate. How should I approach this? Should I try fetching the Sharepoint files using Python only? Continue reading...
