Notifications
Announcements
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?
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
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?
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
Thanks for the reply, However will this work on a sharepoint file? Thanks.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
