Insert a row issue

[pk833129]

Hello Team

Below is the scenario which I am trying to create a flow and got stuck up in it.

I am unable to get insert a row option in excel online while making a flow from Gmail to excel online and getting the errors mentioned in the screenshots. Please guide how I can have the insert a row option for excel online.

any help would be appreciated. 

[RookieI]

You can use Add a row into a table action.

[v-yamao-msft]

Hi @pk833129 ,

It seems that you are working with Excel Online (OneDrive), and you want to insert new rows into an Excel table.

Please consider using the action Add a row into a table.

Please check the following flow for a reference.

Best regards,

Mabel

[pk833129]

Thank you for your reply.

Yes, I am using the same action mentioned by you (Add a table in a row), but when I run this flow it gives me this error:-

"status": 409,

"message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: d733d6ac-4510-490c-8ef8-e260ea2ffe07",

"source": "excelonline-wi.azconn-wi.p.azurewebsites.net"

}

I have circled this error above in the picture also. It is to mention that I am using excle online one drive.

your help would be appreciated.

Thanks and regards

Priyanka

[v-yamao-msft]

Hi @pk833129 ,

How is the flow created? Please share a full screenshot of the flow?

How is your Excel table configured? Do you have any special format in the table?

Please share more details on your Excel table.

Best regards,

Mabel

[pk833129]

Thank you for your reply,  Yes My table is having a format and that I am sharing with you here in the attachment, Also sharing Flow creation through screenshots.

4312

[v-yamao-msft]

Hi @pk833129 ,

If you have any special format in the table, please remove the format to see if the issue still occurs.

I have seen a similar issue at here, please check it for a reference:

https://techcommunity.microsoft.com/t5/Excel/Getting-this-message-quot-This-won-t-work-because-it-wo...

Best regards,

Mabel

[pk833129]

Hi Mabel,

I am having the only headers in my table so I don't think so We should make any changes in that otherwise how data will be fetched accordingly.

Yes, The reference given by you is also having the same problem but did they get any solution for that or if our team could help us in resolving the same that will be very helpful.

looking for your response.

Regards

Priyanka Aggarwal

[v-yamao-msft]

Hi @pk833129 ,

Could you help test without the action Parse resume detail via file content?

I am not able to use this action on my side.

Look forward to your reply.

Best regards,

Mabel

[pk833129]

Hi Mabel, 

Yes, I can test without the action Parse resume detail via file content, But again my issue is, not getting insert a row option in excel online (Onedrive). When I want to save data of my email attachment to an excel online one drives' sheet's table, even another option (Add a table in a row) suggested by you again having the same error 

"status": 409,

"message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: d733d6ac-4510-490c-8ef8-e260ea2ffe07",

"source": "excelonline-wi.azconn-wi.p.azurewebsites.net"

}

please suggest me the way to get this option (insert a row) as I am getting it while making the flow with Gmail to google sheet as follows:

Thanks & Regards

Priyanka