New Record in “Job Planning Line” to Sharepoint Online Tasks – Microsoft Flow Demo
New Record in “Job Planning Line” to Sharepoint Online Tasks – Microsoft Flow Demo
A few days ago, at a local event, we had a brief presentation with Microsoft on some possible integration scenarios between Microsoft Flow and Dynamics 365 (Dynamics 365 BE and NAV 2017 in this case). The tool is very interesting and we are offering it to our customers (and not just for Microsoft products integration..); below some simple examples of integrations.
Updated Documentation: New “Power” Communities
Welcome to the Power Users Community
https://powerusers.microsoft.com/
Welcome to the Microsoft Flow Community
https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity
FLOW TEMPLATES AVAILABLE IN GALLERY
Some templates are currently available relating to the integration of Flow with Dynamics 365 and NAV 2017; below i illustrate one that looks interesting.
Templates Link
Template “Low stock warning” (By Suvidha BS)
Nice demo with these topics: Dynamics 365 Read Data + Do Loop + Outlook email + Dynamics 365 Update Data
My Microsoft Flow Dynamics 365 BE Demo Template: “New Record in “Job Planning Line” to Sharepoint Online Tasks”
This sample will be soon available on Microsoft Template Directory.
Scope of this demo: EXPORT JOB PLANNING LINE (WS) to SHAREPOINT ONLINE TASKS
STEPS:
1) Read new “Planning Lines” from Dynamics 365 (ALL: budget and billable records in this scenario)
2) Insert New “Planning Lines” AS “Sharepoint Tasks” in Sharepoint Online
INVOLVED OBJECTS
WS NAME: “Job_Planning_Lines” > standard Dynamics 365 page exposed on WS
Link: https://msp882270.financials.dynamics.com:7048/MS/OData/Company(‘CRONUS%20US’)/Job_Planning_Lines
ON DYNAMICS 365
JOB PLANNING LINES PAGE: Insert new record in Job Planning Lines Page
ON MICROSOFT FLOW
DEFINE TWO CONNECTIONS
Ø You need to define two connections: 1 to Dynamics 365 For Financials, 1 to Sharepoint Online
FLOW STRUCTURE
Ø When a record is created (in Dynamics 365)
Ø Create Item (In Sharepoint)
SAMPLE OF CONNECTION
Create Item Action:
CREATE TASK ON SHAREPOINT
FLOW TEST RUNNING
RESULTS: TASKS ARE VISIBLE ON SHAREPOINT ONLINE “TASK SECTION”
My old post about Microsoft Flow
NAV 2017 and “Microsoft Flow” integration: “Business Notification Manager” reinvented in Cloud
“Microsoft Flow” Preview – “Work less, do more with Microsoft Flow”
https://robertostefanettinavblog.com/2016/04/29/microsoft-flow-preview/