web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Importing words from a...
Power Automate
Suggested Answer

Importing words from a column in a table (excel) to another table's column in another spreadsheet.

(1) ShareShare
ReportReport
Posted on by
Hey guys, I needed help with an flow that would essentially copy words from a column in a spreadsheet and put them in another column (named in the same) in another spreadsheet.
 
Here's a more indepth explaination
 
SpreadSheet1 
Table1:
Project Devs Notes
EdgeTask John Still working on it.
 
SpreadSheet2:
Table2:
Project Devs Notes
EdgeTask John Finished working on it.
 
 
After the flow is ran:
SpreadSheet2:
Table2:
Project Devs Notes
EdgeTask John
Still working on it.
Finished working on it.
 
I need the flow to recognize the project Name and see if they're equal. Once they're equal it should copy Table1's project Notes into Table2's project notes.
I'm extremely new to automate flow but I'm doing this for an internship to help me get a return offer. So if someone could help me out that would be absolutely perfect.
Whenever I ask ChatGPT to do it, the flow runs forever because I think it's struggling to find the equality in the project table names.
If this is really hard to accomplish then please let me know so that I can figure out how to reduce the scope of the project.
Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at
    I have attached the sample flow and excel sheet.
    Please mark it as answer if it works.
  • CashiFr Profile Picture
    on at
    I can't directly reply, but is it possible you can send me a screenshot of this flow? I cannot directly import the file due to corporate reasons and I have to copy and paste.
  • Suggested answer
    SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at
    Here you go
     
  • CashiFr Profile Picture
    on at
    I'm having issues with the filter query, so for my instance, the column is named User, instead of Dev. What would be the filter query in this case?

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 248 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 204

#3
Haque Profile Picture

Haque 179

Last 30 days Overall leaderboard