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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / update field to emaili...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

update field to emailid of manager

(0) ShareShare
ReportReport
Posted on by EKL 10

Hi,

I want to update field  to manager email id  on create of record in workflow.

Thanks

I have the same question (0)
  • RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at

    Hi, I think the mean of your question is  when the record is created in the workflow, update the field to the manager's email id.

     

    Since I don't know your specific table structure and fields, I designed a table to test.

    For example, here are two tables Engineer  and Manager. All of them have some fields such as name, phone, email etc. And In Engineer table , I add a column named Manager Email and relationship between Engineer table and Manager table.

     

    To accomplish this requirement, I recommend using Automated cloud flow and Dataverse Trigger in Power Automate.

     

    For steps to accomplish this requirement

    • Create an Automated cloud flow and select a trigger named When a row is added, modified or deleted. Choose added type .Select the action and table you need to trigger as shown in the figure.pastedimage1685957306620v3.png
    • Since your update operation involves two tables, I recommend that you query the data from both tables. So you can use List rows actions to query data.
    • Then you need to make updates to the fields in the table. At this stage you need to use the Odata id from the information obtained in the previous step
    • Then you can try to add a record and see the results

     

    These are some of my suggestions for the questions you have asked. If you have any further questions, please contact me.

     

    Best Regards,

    Rudy Zhang

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 74

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans