Step 1: Make Sure File Is in a Valid Excel Table Format
Open your Excel file from SharePoint or Teams.
Ensure your data is inside a table (Insert → Table), and it has a name (e.g., Table1).
Save and close the file.
Step 2: Use the Right Trigger
In Power Automate, create a new flow with:
Trigger: When a new response is submitted (Microsoft Forms)
Add: Get response details action
Choose your form from the dropdown
Step 3: Use the Correct Excel Location
Add action: Add a row into a table
Location: Select SharePoint Site (not OneDrive)
Document Library: Pick the correct library (e.g., Documents or Shared Documents)
File: Use the file picker, not manual path
If the picker doesn’t show the file, click the folder icon and browse manually
Table: Pick the table name (e.g., Table1)
If you manually paste the file path, it will fail — Power Automate needs to identify the file through the SharePoint backend path, not OneDrive URL or link.
Step 4: Map Form Responses to Table Columns
Once Power Automate loads the table, it will show column headers. Map the form response fields to each column.
Step 5: Test the Flow
Submit a form response.
Check the Excel table in SharePoint.
The new row should be added.
If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz
