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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / how to look up by matc...
Power Automate - Building Flows
Unanswered

how to look up by matching columns and patch date column

(0) ShareShare
ReportReport
Posted on by auslander 10
I have MilestoneDates table and OverdueAI table (sharepoint). I want to patch DUEDATE from MilestoneDates table to OverdueAI table matching by two columns (PROJ_NUMBER and MILESTONE) in power automate. Could you please help?

Please see below tables
 
MILESTONEDATES table
ID PROJECT_NUMBER MILESTONES DUEDATE
  091-46 Scrum Kickoff Meeting 2/20/2025
  091-46 Framing Workshop 2/20/2025
  091-46 Alternatives Generation 2/20/2025
  022-63 Alternative Selection 2/20/2025
  091-46 Last Scrum Showcase 2/20/2025
  091-46 Kanban Kickoff Meeting 2/20/2025
  091-46 Kanban Sessions 2/20/2025
  091-46 30% DR 2/20/2025
  021-67 PHA/HAZOP 12/25/2024
  770-90 60% DR 12/10/2024
 
 
OVERDUEAI table
ID WEEKDATE PROJ_NUMBER POP_ITEM_NUMB MILESTONE ACTION_ITEM DUEDATE
45 12/18/2024 091-46 27 60% DR 698  -
56 12/18/2024 091-46 28 60% DR 699 -
67 12/18/2024 091-46 117 60% DR 751 -
78 12/18/2024 091-46 45 Detailed Engineering Completion 706 -
89 12/23/2024 091-46 27 60% DR 698 -
Categories:
Business Process Flows
I have the same question (0)
  • Mark Nanneman Profile Picture
    Mark Nanneman 989 Super User 2025 Season 2 on at
    how to look up by matching columns and patch date column
    Are you wanting to use Power Automate Desktop or Power Automate Cloud Flows?
  • auslander Profile Picture
    auslander 10 on at
    how to look up by matching columns and patch date column
     
    Cloud Flows

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans