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!
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.
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).
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.
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.
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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!