Unable to update excel using flow

[KK3]

I have successfully set up a flow such that any changes in my sharepoint list (name = VC QC) is supposedly to update in an excel saved on sharepoint (filename = flow trial new.xls). The flow when tested was successful, but the excel file is not updated. Can anyone help out on this please?

[efialttes · Accepted solution]

Hi

Did you inspect your flow execution under Run History? if so, can you share a screenshot? Sometimes excel files can get blocked, if you inspect flow execution we can evaluate this first hypothesis.

https://docs.microsoft.com/en-us/power-automate/see-a-flow-run

Also, when you mention "the excel file is not updated", what do you exactly mean?

When executing your flow, no matter the expected result is to update an excel row or create a new row, nothing happens? Or, does your flow always create a row, no matter the expected result is to update a row? Or, does your flow always try to update a row, no matter the expected result is to create a row? 

THanx!

[KK3]

Hi, thanks for taking a look. Here is the screen capture of the successful flow.

To be more precise, when I add a new row or amend a pre-existing row on sharepoint list, no changes occur in the excel.

Thx in advance!

KK

[efialttes]

Weird...

Please inspect flow execution again, this time doubleclick on every action block so you will expand all of them; also in the "condition", and doubleclick on whatever action block was executed inside your 'condition' (either true or false branch). Now share the screenshot (you will probably need 2 or 3)

Can you also share the expressions you are currently using both in the Condition and in the Filter array?

Thanx!

[KK3]

Hi, this is what I got. I didn't notice anything abnormal. The file just wouldn't create a new row...seems that it can update the pre-existing three rows in the excel.

Br

KK

[efialttes]

Hi

Extremely weird

Just for troubleshooting purposes, I would suggest:

-to add a dummy Compose action block in between List rows present in a table and Filter Array, and assign as its input the following expression:

length(body('List_rows_present_in_a_table')?['value'])

-to add a new 'List rows present in a table' after your condition, so it would apply no matter true or false branch are executed. By default, flow editor will rename it as 'List rows present in a table 2'

-to add a dummy Compose action block after this 'List rows present in a table 2', and assign as its input the following expression:

length(body('List_rows_present_in_a_table_2')?['value'])

REexecute the flow with whatever input that should create a new item, and inspect values on these two dummy Compose action blocks

Thanx!

[KK3]

Hi. I did what you suggested, and once again the tests ran smoothly (unfortunately I somehow can't insert photos on this computer....)

Changes on the pre-existing 3 items on the sharepoint list did change; however, addition of new items in sharepoint list did not lead to changes in excel.....

I am stuuuuuuuck!!!!!

Anymore ideas please?

Br

KK

[KK3]

Very sorry, but I found out that actually all the new items were added at the very bottom of the excel table (about 2000 rows below)....don't know why that happened, but at least they are there.

Thanks for  your help throughout!!!

[efialttes · Accepted solution]

HURRAY!!! It works!!

Maybe the table limits you defined includes 2000 rows (1990 or even more empty), if so new rows are added at the end. Please review it on your excel config

https://support.office.com/en-us/article/resize-a-table-by-adding-or-removing-rows-and-columns-e65ae...

So my humble suggestion is:

1.-Mark this topic as "Solved" by clicking "Accept as a solution". Please note you can even select several replies as as 'Solution', even from different community members, including yourself!

2.- (OPTIONAL) Click on 'Thumbs up' in any answer you found valuable.... or even in all of them 😉

Even though this 2nd step is OPTIONAL, please remember it is the cheapest, easiest way to say thanks to somebody that simply tried to help on a weekend. And just between you and me, everytime an inspiring answer receive a kudo, an ewok escapes from The Emperor menace  😉

Thanx for your contribution to keep this community great!