How to use flow to update different cells in the same excel line through different forms?

[Freesunshine]

HI,

   Eeveryone：

How to use flow to update different cells in the same excel line through different forms?I hope to get an answer.

[Brad_Groux]

You can't update individual cells, the Excel connector only allows for the manipulation of entire rows with the Update row action. This does however allow you to update column-specific items as well. 

If updating individual cells is a functionality you would like to see added to Flow, please consider submitting it to the Flow Ideas page, where it can be voted on by other users, and tracked and commented on by the Flow team.

Here's an existing idea that you can vote on. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[v-lin-msft]

Hello @Freesunshine ,

Is this cell part of the table? And is there have multiple tables?

If you want to update individual cell as a part of table, I think you can reference to this way as below:

E.g. I want to get the value of the Total Height.

Step1: Get the table by using action "List rows present in a table".

Step2: Add action "Filter array" to get the item within table you want, for instance Total.

Step3: Update the row, for instance Height.

These functions are

"body('Filter_array')[0].Name"

"body('Filter_array')[0].Name"

"body('Filter_array')[0].Age"

"body('Filter_array')[0].Sex"

This is a screenshot of the flow running successfully:

Please have a try and I hope it will help you.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Freesunshine]

@v-lin-msft  Thank you very much for your answer.

I tested the contents of a cell in the update row .When updating the key value of the row and changing it to a fixed value, I can update the contents of the row.

My question:

Doing this above, I can only update fixed lines.

I want to specify an update to a specific line via Forms,FLOW can't be found key value,will report error 404.

[v-lin-msft]

Hello @Freesunshine ,

If you want to win at excel dynamically specify line to update excel, in flow is impossible currently, because the excel connector is not perfect.

If you want to achieve in the form specified line to update the list of item Numbers, I suggest you use SharePoint connector, because SharePoint existing APIs can achieve the needs of what you want.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.