Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Call or initiate D365 F&O action/workflow from Power Automate

(1) ShareShare
ReportReport
Posted on by 2
Hello everyone,
 
We are trying to automate the workflow "Submit" option from D365 F&O (Trade Agreement Journals) through Power Automate workflow.  
 
 
We are using Premium Connector and could see only below options in Power Automate for F&O:
 
Which action we should use from the above listed actions to call or automate the "Submit" workflow option which is mentioned in the above screenshot?
 
Basically, idea is to call inbuilt D365 workflow from Power Automate. 
 
Any help is appreciated!
 
Thanks. 
  • Suggested answer
    Yogesh Mulay Profile Picture
    Yogesh Mulay 54 on at
    Call or initiate D365 F&O action/workflow from Power Automate

    Unfortunately, directly triggering the built-in D365 workflow 'Submit' from Power Automate using the standard connector actions isn't feasible. The available actions primarily focus on data manipulation (create, read, update, delete) and entity listing.

    Potential Workarounds:

    1. Custom Action in D365:
    • Develop: Create a custom action in D365 F&O that encapsulates the 'Submit' workflow logic.
    • Expose: Expose this custom action as a service or function that can be invoked externally.
    • Power Automate: Use the 'Execute action' action in Power Automate to call this custom D365 action, effectively triggering the 'Submit' workflow indirectly.
    1. OData/REST API:
    • Investigate: Explore if D365 F&O provides any OData or REST API endpoints that allow triggering workflows or actions.
    • HTTP Request: If such endpoints exist, use the 'HTTP' action in Power Automate to make the necessary API calls to initiate the 'Submit' workflow.
    1. Logic Apps with Custom Connector:
    • Custom Connector: Develop a custom connector in Azure Logic Apps to interact with D365 F&O and potentially expose workflow triggering capabilities.
    • Logic App: Build a Logic App that utilizes this custom connector to trigger the 'Submit' workflow.
    • Power Automate: Call this Logic App from Power Automate using the 'HTTP' action or by creating a custom connector for the Logic App itself.
    Please mark my answer verified if this is helpful!
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,904 Super User 2024 Season 2 on at
    Call or initiate D365 F&O action/workflow from Power Automate
    Hi,
     
    To call business logic in F&O from Power Automate you can use the option Execute action. There is a prerequisite that a data entity should have a method decorated with SysODataActionAttribute. I doubt if there is a data entity for trade agreement journals supporting such method to be able to call logic to start a workflow.

    You can consider a customization to support your requirement. In my blog, you can read more about the technical architecture in F&O to support calling business logic: Let your Operations Flow – Part 8 - Dynamicspedia

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

Product updates

Dynamics 365 release plans