Share via

Update multiple equal values on online excel table

Anonymous
2021-11-16T14:37:03+00:00

Is there a way to update multiple rows that have the same value? I see using "update a row" without any function or difficult thing, only updates the first row that contains that value but not the rest.

I want to update every row that contains "Send" to "Done" as last action of the flow.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-16T15:03:35+00:00

    Hi Victoria,

    Unfortunately, your requirement is not feasible via Power Automate > Update a Row. The Key value should be associate with a unique value in your Excel worksheet. If you have duplicate values, as a result, it will only update the first row which has the key value match.

    For your requirement, you will need to use the Office script as described in the following thread:

    how to update multiple rows with a key value

    Meanwhile, as the Power Automate related questions are not fully supported in this community. To make sure you get the best answers to your concern, please post a new thread in thePower Automate Community.

    Appreciate for your understanding.

    Regards,

    Alex Chen

    0 comments