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.