cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pk833129
Frequent Visitor

Insert a row issue

Hello Team

 

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

excel.pngEXCEL ONLINE FLOW.png

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. 

10 REPLIES 10
RookieI
Resolver I
Resolver I

You can use Add a row into a table action.

v-yamao-msft
Community Support
Community Support

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.

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pk833129
Frequent Visitor

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
 

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

44331122table screen shot.png

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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:
 
new screenshot.png
 
Thanks & Regards
Priyanka

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (34,952)