Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Populating Fields in One Table from Another Table Based on Lookup Choice

(0) ShareShare
ReportReport
Posted on by 29
I am working on a tool to manage Change Management in a project schedule. I would like to populate several fields in a form (Current Content (i.e. task name), Current Start, and Current Finish) from a table that has that information in it based on the selection of a Lookup field ("Tasks") containing the WBS number (WBS = Work Breakdown Structure; it's basically an index field). So, when a user selects a WBS from a dropdown ("1.1"), text boxes underneath populate with the Task Name ("Do This Task"), the Start Date ("9/25/24") and the Finish Date ("9/26/2024"). 
 
The name of the table with the existing task information is called "Tasks." The name of the table I want to copy that information into is "Change Tasks." This table is a joiner table that is also connected to a third table called "Changes."
 
 
Mechanically, I need a process (i.e., a Power Automate flow) to see the "1.1", find other information corresponding to that record in another table, and paste it in these fields. This seems like it should be easy enough to do. I just can't figure it out. 
 
Any information you can provide or direction you can point me towards would be GREATLY appreciated.
  • JohnAlan92 Profile Picture
    JohnAlan92 29 on at
    Populating Fields in One Table from Another Table Based on Lookup Choice
    First, thank you for responding. I greatly appreciate it!
     
    Regrettably, something I failed to mention is that this is a model-driven app. Can I accomplish something like this within that context?
  • Suggested answer
    EricParker Profile Picture
    EricParker 8 on at
    Populating Fields in One Table from Another Table Based on Lookup Choice
    Have your form which contains the fields Current Content, Current Start, and Current Finish point to your data source where the data is stored. Then set the Item property to something like this:
     
    Item = Lookup('Change Tasks', WBS = TasksField.Selected.Value)
     
    That will take the value in the Tasks dropdown, and then go query the Change Tasks table base on the WBS field and return the values, populating the Form. Then simply submit the form, which will save the values into the table.
     
    I hope I understood the problem correctly. Please correct me if I am wrong.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard