Add additional row in excel

(0) Share

Report

Posted on by GN-19080408-0

I have automated my flow but add a row in excel in this i'm facing an issue. this says its forbidden. why i dont get it. can you please let me know

Screenshot 2025-08-19 094108-forbidden.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Yang_Tao_202305 6 on at

Like (0)

Report
Copy link

Link copied!
Check and re-authenticate your connections

Go to Data > Connections in Power Automate and ensure all connections are valid and authorized.

Verify your permissions

Make sure your account has the necessary permissions for the resource you're trying to access.

Contact your admin

If you're blocked by a policy, your Power Platform or Microsoft 365 admin may need to adjust settings.

Review the flow’s run history

Look at the detailed error message in the flow run history to pinpoint which step is causing the issue.

Was this reply helpful? Yes No
NR 8 on at

Like (0)

Report
Copy link

Link copied!
Hi @GN-19080408-0

Make sure the Excel file is stored in:

OneDrive for Business

or SharePoint Online

If it's in personal OneDrive or local storage, Power Automate will throw a "Forbidden" error.

2. Table Must Be Defined
Power Automate can only add rows to a defined table in Excel.

Open your Excel file

Select the data range

Go to Insert → Table

Name the table (e.g., Table1)

3. Permissions
Ensure your account has edit access to the Excel file:

Go to OneDrive/SharePoint

Right-click the file → Manage Access

Confirm you have Edit permissions

4. Connection Issues
Sometimes the Excel connector gets outdated or broken.

Go to Power Automate → Data → Connections

Find the Excel connection

Click Fix connection or Re-authenticateMake sure the Excel file is stored in:

OneDrive for Business

or SharePoint Online

If it's in personal OneDrive or local storage, Power Automate will throw a "Forbidden" error.

Was this reply helpful? Yes No
eromerof 54 on at

Like (0)

Report
Copy link

Link copied!

Hello,

If the Excel is open in another tab is probably that you have errors. Close the excel, Wait 5-10 minutes and re-run again.

Hope can help you

Was this reply helpful? Yes No
Suggested answer

Tomac 4,070 Moderator on at

Like (0)

Report
Copy link

Link copied!

A 403 forbidden error means the account runn the Update Row action doesn't have permissions to the file or folder location. You'll need to check which account connector is being used for that action:

And then ensure that account has the correct permissions to the location and file that you're trying to update.

Was this reply helpful? Yes No