I'm trying to create a flow that pulls text strings out of my email and adds them to a table row in Excel. I've created the Condition no problem and composed the JSON output no problem.
However, when creating the "Add a row into a table" Excel action, I select the Location where my file is (OneDrive), I've selected the file, and it sees the defined table name in my Excel file just like I expected. However, when I select the table name, I believe it's supposed to show me the headers in my table so I can map the elements in my JSON file to the columns in my Excel file. But it doesn't show me any columns. I've asked Copilot to give me specific instructions how to map it and it keeps referring to columns that should show but they don't show. The AI support is clear--it tells me to make sure my Excel file is closed (which it is) and make sure my table is named (which it is), and make sure the source file is closed (which it is), and to delete the Action and re-add it to make sure it's seeing the latest file (which I've done multiple times). Still no columns. See screenshots.
What am I missing?!?
