Adding a row to a table in an automated SharePoint workflow

Question

I am having trouble using the power automate feature to add Excel functionality to a SharePoint online site when I try to add a feature to add a row into a table. 

I get the following error: 

I have tried this where my Excel sheet is in OneDrive and on the SharePoint site. Is there a place where I can set a parameter that would make this workflow work?

Answer 1

Hi MitchFade1,

Thank you for posting your question in this community. From your description, you are trying to create a Flow in order to add a row to an Excel table from SharePoint site. In this this scenario, I suggest you can raise this question in Power Automate community where a lot of experts of Power Automate can provide more professional suggestions and ideas based on your requirements.

At same time, I also found some relevant information from Power Automate community which it may give you some ideas about it.

Excel Online (Business) - Add a row into a table

Add a row into table" in Power Automate

Insert and Update rows in Excel 

Best regards,

Dihao