Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
Expand all | Collapse all

Power Automate unable to update the data in excel.

  • 1.  Power Automate unable to update the data in excel.

    Posted 14 days ago
    Hi ,
    I have created the flow in which the flow get the status from share point and update the excel column(Recurrence flow set to run twice in a day) .The excel is available on Teams. The issue I am facing that flow output showing the status as " Approved"( one of status from my share point) but it is not getting reflect in excel sheet(its retaining the earlier value as " Review request"). I tried to change the format of column to text but its still not working. Can anybody help me with this issue .Attached the snap of Flow output and excel column.

    ------------------------------
    pratik manbhekar
    ------------------------------


  • 2.  RE: Power Automate unable to update the data in excel.

    Bronze Contributor
    Posted 14 days ago
    Hi Pratik,
    Could you please include some screen shots of your flow steps? Personally I find the Excel Online connector fussy, so I would like to see how you are attempting to write the value into Excel.
    Thanks,
    -Rob

    ------------------------------
    Rob Clark
    Cambridge
    ------------------------------



  • 3.  RE: Power Automate unable to update the data in excel.

    Posted 13 days ago
    Hi Rob,
    Thanks for reply.
    Attached herewith  snap of the flow I created.
    There will always be data present in my excel in which one column is of Status(List row table ). The recent status will be picked from SharePoint(Get items).Flow is supposed to update the recent status in excel from share point if condition is  matched (update row) .This flow runs twice a day .
    Please let me know if anything else is required.

    ------------------------------
    pratik manbhekar
    ------------------------------



  • 4.  RE: Power Automate unable to update the data in excel.

    Bronze Contributor
    Posted 11 days ago
    Hi Pratik,
    Thanks for posting those screen caps. I suggest you check your recent flow runs and see which branch is being evaluated after the Get Items action. It looks like both Apply to each 3 and Apply to each 4 are set up to evaluate after Get items, and it looks like both are set up to run after Get items succeeds. I do not think both branches will be run - but I may be wrong.
    Two scenarios I can see:
    1. Apply to each 4 is running in parallel with Apply to each 3 and is also trying to update an Excel row - and its action is taking precedence or overwriting the action you showed from Apply to each 3.
    2. Apply to each 4 is running instead of Apply to each 3, which is never evaluated at all.


    ------------------------------
    Rob Clark
    Cambridge
    ------------------------------