Skip to main content

Notifications

Power Automate - General Discussion
Answered

Unable to update excel using flow

(0) ShareShare
ReportReport
Posted on by 56

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?

 

Screenshot 2020-03-22 at 08.03.02.png

Screenshot 2020-03-22 at 08.04.22.png

Screenshot 2020-03-22 at 08.04.47.png

  • Verified answer
    efialttes Profile Picture
    efialttes 14,756 on at
    Re: Unable to update excel using flow

    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-e65ae4bb-e44b-43f4-ad8b-7d68784f1165?ui=en-US&rs=en-US&ad=US

     

    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!

    Flow_AcceptSolution.png

     

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

    Flow_thumbsUp.png

    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!

  • KK3 Profile Picture
    KK3 56 on at
    Re: Unable to update excel using flow

    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!!!

  • KK3 Profile Picture
    KK3 56 on at
    Re: Unable to update excel using flow

    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

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Unable to update excel using flow

    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 Profile Picture
    KK3 56 on at
    Re: Unable to update excel using flow

    Screenshot 2020-03-22 at 21.41.58.png

    Screenshot 2020-03-22 at 21.44.44.png

    Screenshot 2020-03-22 at 21.44.55.png

    Screenshot 2020-03-22 at 21.45.07.png

    Screenshot 2020-03-22 at 21.45.20.png

     

    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.

     

    Screenshot 2020-03-22 at 21.48.01.png

     

    Br

     

    KK

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Unable to update excel using flow

    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 Profile Picture
    KK3 56 on at
    Re: Unable to update excel using flow

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

    Screenshot 2020-03-22 at 20.52.02.png

    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

  • Verified answer
    efialttes Profile Picture
    efialttes 14,756 on at
    Re: Unable to update excel using flow

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard