You’re offline. This is a read only version of the page.
6
Hi everyone,
I’m building a flow in Power Automate where flagging an Outlook email should add a row into an Excel table with the email details (date, sender, subject, and status).
Here’s the problem I’m facing:
In the “Add a row into a table” action, it asks me to select a table.
I select the only table available (I even renamed it for clarity).
Normally, after selecting a table, there should be a drop-down showing each of my headers (date, sender, subject, status). But that never appears.
When I test the flow, it does add a new row to the table — but the row is completely blank.
What I’ve tried:
-Made sure my Excel file has headers (date, sender, subject, status) formatted as a proper table.
-Rebuilt the table and flow multiple times.
-Tried re-signing into the Excel connector.
-Even followed step-by-step instructions with Copilot, but still no luck.
It seems like Power Automate isn’t detecting my table headers at all.
Has anyone run into this issue before? Do I need to change something in the way I formatted the Excel table, or is this a connector bug?
Thanks a lot for your help!
Map the columns under “Advanced parameters” (new designer UI)
In the Excel Online (Business) → Add a row into a table action, the per-column inputs are tucked under Advanced parameters → Row. Expand that and you should see your table’s columns to map (Date, Sender, Subject, Status). Several users solved the “no columns showing” issue simply by expanding Advanced and mapping there.
Share
Report
All responses (
Answers (
/, :, @, #. Rename to simple text (e.g., EmailDate, Sender, Subject, Status). Numeric-only or special-character headers are a known source of weird behavior.
