Hi,
Current flow i'm attempting to extract an updated row's cell and paste it in another excel sheet's specific cell.
My flow stops at updating a row as it cannot find the ID of that row.
Any suggestions what i can do please?
Thanks for the reply, However will this work on a sharepoint file? Thanks.
Hi @Infinity1 ,
Yes you can do this by using Power Automate Desktop Excel actions. Essentially you can find the first free row in a worksheet and paste in your data by column. Works like a charm! Please mark as a solution if this was helpful! Always glad to help! Tom
Hi @trice602,
I understand now that this may be looking for a key value in Column 2. However, It will be Blank and only update according to what is entered in the first sheet from a specific row/column cell.
In this instance, what what i do?
Hi @Infinity1 ,
It looks like in the second sheet, it cannot find the column2 keyvalue "3". Can you confirm your second sheet has "3" in column2 in table2 please? Paste in your sheet if you can - will be helpful! Always glad to help! Tom
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional