Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Automation Sales

(0) ShareShare
ReportReport
Posted on by 5

HI!

What do you recommend for automating actions, like performing a date check on objects in a custom view? Let's say Opportunities. I was thinking about Power Automate maybe but couldn't find a useful guide. And the PA connector in combination with tenants and cryptic table (names) is not necessarily self-explaining.

Thanks, have a good day!

  • RanjithK Profile Picture
    RanjithK 16 on at
    RE: Automation Sales

    To create an automated workflow that performs a date check on Opportunities in a custom view, you can use the "Data-verse" connector in Power Automate. This connector allows you to connect to your Dynamics 365 Sales instance and perform various actions and triggers.

    Here's an example workflow that you can create in Power Automate to perform a date check on Opportunities in a custom view:

    Create a new workflow in Power Automate and select the "Common Data Service (current environment)" connector.

    Choose the trigger that you want to use to start the workflow. For example, you can use the "Recurrence" trigger to run the workflow at a set interval (e.g. every day).

    Use the "List records" action to retrieve the Opportunities that you want to check. You can specify the custom view that you want to use in the "Filter Query" field.

    Use a "Condition" action to check the date field(s) that you're interested in. For example, you can check if the "Est. Close Date" field is less than or equal to today's date.

    If the condition is true, use the "Update a record" action to update the Opportunity record(s) with the new information. For example, you can update the "Status" field to "Lost" or "Inactive".

    Save and test the workflow.

    Keep in mind that this is just one example workflow, and there are many other possibilities for automating actions in Dynamics 365 Sales using Power Automate.

  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: Automation Sales

    Hi Partner,

    Have any updates?

    Please feel free to contact me if you have any questions!

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: Automation Sales

    Hi Partner,

    Maybe you can refer to the following steps:

    1.Go Power automate to create one schedule flow:

    pastedimage1676265940590v1.png

    2.List rows:

    https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows 

    --Retrieve all opportunity records:

    pastedimage1676267553398v3.png

    3.If you want to retrieve only the opportunities on the custom view, you need download code and apply fetch xml query:

    pastedimage1676267450664v2.png

    pastedimage1676267695944v1.png

    4.Add 'Apply to each' action:

    pastedimage1676268510267v2.png

    5.Get a row by id:

    pastedimage1676269665272v7.png

    6.Add 'Compose' to get date field you need (My example is 'Created On' field):

    pastedimage1676269716077v8.png

    7.Add 'Condition' to compare date:

    ----In my example, comparing the creation date is less than or equal to the current date

    pastedimage1676269841107v10.png

    8.Then you can add other actions under 'Yes' or 'No' branches:

    pastedimage1676268829127v6.png

    9.Test:

    pastedimage1676269917271v11.png

  • Mo BRRR Profile Picture
    Mo BRRR 5 on at
    RE: Automation Sales

    Hello, I would like to act on dates expiring and things like that automatically.

    So yes, it is about triggering actions based on my custom view.

    What would be a good way to do that, is the question? Maybe Power Automate could be the tool of choice, I don't know. The one time I looked into it I found it hard to figure out how this could work.

    And could you elaborate on this statement of yours as follows please, is there a tutorial or could you describe the required steps? 

    If yes then we can Download that Custom Views from Advance find then Use that in Power Automate and trigger it in Schedule flows

    Thank you!

  • Ram Prakash Profile Picture
    Ram Prakash 2,287 on at
    RE: Automation Sales

    Hi,

    Can you please provide me more clarity?

    Do you want to trigger actions for the Custom Views which you created?

    If yes then we can Download that Custom Views from Advance find then Use that in Power Automate and trigger it in Schedule flows

    Please mark as Answer if it is helpful and provide Kudos

    Subscribe : www.youtube.com/.../UCnGNN3hdlKBOr6PXotskNLA

    Blog : microsoftcrmtechie.blogspot.com

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans