This is just a quick little reminder, mostly to my self. When using Excel Online connectors in Power Automate. It is a multi-step process.
- My Trigger was “For a selected file”
- Get the File Properties
- Perform Excel functions. Using the “Identifier” field from the file properties. File ID will not work.
If you use ID or try to format the string using folder/filename you will get an error message like.
Hopefully this helps someone not waste a morning struggling to figure out why Flow cannot find a file :0)