cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dsalad
Level: Power Up

Simple add row to excel when task complete; succeeds but no new row in file

Can't figure out why Flow isn't adding a row to my excel table. This is a simple recipe...Where else can I look? THANK YOU!

1Setup.pngFlow recipe2success.png3File.png4nothingthere.png5TableSetup.png

3 REPLIES 3
Community Support Team
Community Support Team

Re: Simple add row to excel when task complete; succeeds but no new row in file

Hi @dsalad ,

 

It seems that there is no problem with the configuration of Flow.

First make sure that the table you are configuring is the one you expect.

In addition, I noticed that Excel table seems to have only one row (I mean Excel table instead of the current sheet).

When you use "Format as Table" to select the selected cell as a table, the number of rows selected is the current number of rows in the Excel table.

Try the following method to add more rows to store information about the task.

Image reference:

444.gif

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dsalad
Level: Power Up

Re: Simple add row to excel when task complete; succeeds but no new row in file

I have tried several table sizes. The example I sent had one row, but I have tried multiple row tables, single column tables, etc. What is even more odd is that it has done seomthing a couple of time, but never when I am watching. I have opened the excel sheet and found a couple rows inserted...not sure who completed the task, but there were rows. I did what you suggested and the flow showed successful, but no rows were inserted/added.

 

I'm perpelexed and frustrated. Multiple tests this morning with different configurations did not work.

 

I'm starting to wonder if it is my permissions, OR that my tet tasks have been completed once and I am "uncompleting" them and then clicking complete to do my testing. I have tried completing other people's tasks and it doesn't work. Maybe it is a permissions issue or a connector issue (even thought all my connectors show green). 

 

 

Community Support Team
Community Support Team

Re: Simple add row to excel when task complete; succeeds but no new row in file

Hi @dsalad ,

 

I am sorry that you have encountered such a situation.

Could you share screenshots of Flow run history? I did a test on my side and it seems to be able to reproduce a similar issue.

Whether your Flow run history is the following situation, although the Flow display runs successfully, but the action in Apply to each is not executed, so the expected row is not added in the Excel table.

13.PNG

If the situation is the same as above, the solution is to ensure that the task that is currently complete is assigned to the specific user.

14.PNG

If there is no similar operation, then assignments will be an empty set, so Apply to each will not traverse any values.

Please take a try again and feel free let me know if issue still exist.

 

Best Regards,

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 78 members 4,597 guests
Please welcome our newest community members: