Update a row in an existing Excel Table

I have a scenario that gets an update from a websocket. I update the the result to an excel file. This is working fine. I want to update a certain row in an excel that matches the criteria from the update I recieve from web socket. The update has a filed id called ‘order id’ and similarly my excel table has the column ‘order id’. How can I update this particular row? I have used the list table rows method and then tried to filter on the ‘order id’ but the update table requies a row ID and I can’t get that using the filter I have in placed.

I have managed:
List all the rows,
Filter on field
Update the rows (get the row Id from the filter using “map” attribute)

Heya @Yasir_Gilani welcome to the community :wave:

Also, great work figuring this out! Thanks a lot for stepping back into the thread and for sharing what you found out with us. It’s awesome to see that you’re keeping the community in mind :pray:

Just FYI: I marked your reply as a solution so that folks in the future know where to look when searching for similar information. :white_check_mark: