Flow Office 365 Power Automation

Dynamic Files in Excel Online (Business)

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.

  1. My Trigger was “For a selected file”
  2. Get the File Properties
  3. 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)