Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

T0 be Auto update Approve on Field

Posted on by 70

Hello all,

  I have one scenario on account object i have to fields one is { CRM approval status } and second is ( Approved On ) my issue is whenever CRM approval status changed to Approved the Approve on filed should be auto update with date and time when the record CRM approval approved so kindly anyone suggest how to achive this!!!

  • Verified answer
    LuHao Profile Picture
    LuHao 40,872 on at
    RE: T0 be Auto update Approve on Field

    Hi Asif,

    Don't forget to click Yes under the titles to mark the Verified Answer.

    Thanks.

  • Asif Shaikh Profile Picture
    Asif Shaikh 70 on at
    RE: T0 be Auto update Approve on Field

    Thanks for sharing info !!!!

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: T0 be Auto update Approve on Field

    Hi Asif,

    We can use workflow to implement it simply.

    Here is a demo.

    There are to fields on my Account form, option set field 'CRM approval status' with options A,B and C, date and time field 'Approve on Time'.

    pastedimage1576492041617v1.png

    I would the field 'Approve on Time' should be auto update with the time when the field 'CRM approval status' is changed to B and C.

    1) Create a workflow of Account entity, select Scope as Organization, select Start when as Record fields change, select the field 'CRM approval status'.

    pastedimage1576492362578v2.png    pastedimage1576492386865v3.png

    2) Add a step - Check Condition, set the field 'CRM approval status' equals B,C.

    pastedimage1576492487348v5.png    pastedimage1576492504213v6.png

    3) Then add a step - Update Record, set the field 'Approve on Time' to Dynamics Value, Process, Execution Time.

    pastedimage1576492764384v7.png    pastedimage1576492786719v8.png

    4) Activate this workflow.

    Since the Execution Time of the workfloww process is approximately equal to the change time of the field 'CRM approval status', it can be used to represent the field 'Approve on Time'.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans