I have 2 flows, one of them I can run in Online Power Automate, the other has a trigger of selecting rows in a particular Excel sheet table. My flows are just for my use - my Office 365 subscription has one user, just me. Both flows refer to tables in this one workbook on Onedrive Business.
So my problem is I have tried to use the Flow app from the MS store which is an Add-In for Excel supposedly to link to Excel related flows and the icon appears in the Excel data tab called Automation. With this file open, it says I don't have any flows for this file.
So I am trying to work out why...
- Subscription or lack of is this the problem? What's allowed under Free access to online Power Automate is a total mystery after a lot of searching. I can run one of my flows fine from within the online Power Automate so that doesn't sound the problem. Can anyone clarify?
- The file is on Onedrive Business but it's not Excel Online, it's Excel 365 - should it be Excel Online?
- I have checked sign in for Power Automate and the 365 Workbook are the same.
- I have closed the automatic syncing on Onedrive Business as I use Google Drive. But the file is there and available on my Windows explorer in Onedrive Business.
What do you think is wrong here? I have come to a screaming halt on using this tool for automation as I work primarily in Excel and to run it from Excel would be just the best way for me to use it.
thanks for your help,
John
