
We have an Excel file in Microsoft Teams that once a month we want to run a PAD flow that reads through it and updates a website.
I cannot seem to find a way to launch excel from Teams or SharePoint, does anyone know if it is possible?
Hi Mark,
You do not have the option to launch excel from Teams or SharePoint directly, you do need to have an intermediary step to launch it. By this way using PAD, you have to open Teams or SharePoint on Web and navigate to the excel file, download it to the computer. There you can launch it.
From my opinion, there are better solutions that you can try.
First choice is that, you can use Cloud flow to read and extract the data from excel file on Teams or SharePoint, it is quite simple actions on Cloud flow and then use this data as the parameter to trigger your PAD flow (because in PAD you can pass parameters from Cloud flow when triggering it). This is depend on the complexity of your data in the excel file, if it is complicated, then I would not suggest this way.
Second choice and I think it is the simplest and easiest, you just need to install OneDrive on the computer that runs PAD flow, and turn on Autosync feature to download the file automatically to the local computer. Then, you will have your excel files on the computer and you can do whatever you want with these file as it stores in the local folder.
Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others