Within Dataverse, I am trying to use PowerAutomate update a Lookup field ("PLAN") to match the name of a text field ("PROJECTNAME"; crc24_ProjectName; graopmo_plan) for all of the records in a table ("PWATasksDev").
The table the Lookup value calls from is "NAME" (msdyn_subject) in a table called "Plan" (msdyn_projects) (NOTE, The term Plan refers to two different things).
Mechanically, I need to go through the table line by line and:
- Get the value (let's call it 'x') from "PROJECTNAME"
- Find the GUID in the "Plan" table for for 'x'
- Update the column in "PLAN" so that it matches "PROJECTNAME"
How do I do this? I've scrubbed the forums and YouTube but can only get halfway there. The actual exercise of looking at a record, identifying the value from a specific field in that record, and then making another field equal that value via the GUID from that Lookup field is just beyond my reach.
For anyone who answers, please be specific. I'm missing something small - a detail - that's keeping me from getting this thing to work. So, providing me with that detail would be enormously helpful and extremely appreciated.
29
Share
Report
All responses (
Answers (
