You’re offline. This is a read only version of the page.
Some time ago I found some good help here in this community, during my search I found an interesting post where the author explained how to get all a parental table fields in the dynamics content. Very interesting! I did not write it down because the method was fairly simple....but I do to remember it and I spent some hours looking for it with no result.
Anybody kind enough to give me an input?
Thank you very much and Have a nice day!!!!
Carlo Scampicchio
carlo.scampicchio@club-crm.it
Hi Mira Ghaly,
sorry for being late. I'm using the standard and most recent "Dataverse" connector for Power Automate:
What I was trying to do was to start an automated cloud flow to send a mail to a new customer when a car is sold. Trigger: Status change to "Sold" for the car record and "Customer lookup field" on the car record updated with a Contact record.
For the moment I solved it with a legacy Workflow that copies the email address of the contact into a new custom field (Customer Mail) on the Car form, very easy. Once the new field is updated with the e-mail address the solution is very easy as well and I can get the mail being sent. Anyhow I'm still looking for a way to get into dynamics fields of Power Automate all the fields of a "parent record, in this example the fields of the contact who is put into the "Customer lookup field" of the car being sold. this way I would not need a replicate field and use a more up to date and elegant solution.
I know it is possibile and knowing how to do will ease many of my projects and will help greatly my move to Power Automate from legacy Work Flow. I remember the solution has something to do with "triggerOutputs" or "triggerbody" expressions, but I cannot remember how to do it...
I have a good experience of Dynamics (since Microsoft CRM V.1.2 of 2003), I started using Power Apps a couple of years ago (and I think I can get good results by embedding Canvas Apps into Model driven ones), but I have a limited experience of Power Automate, since I can still satisfy most of my needs with legacy Work Flows, but I decided to move on Power Automate for many obvious reasons.
Any help or hint you could provide me will be very appreciated.
Thank you again for your help, have a nice day!
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (