Anyone using Node-Red in combination with Office365 ?

%3CLINGO-SUB%20id%3D%22lingo-sub-97281%22%20slang%3D%22en-US%22%3EAnyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-97281%22%20slang%3D%22en-US%22%3E%3CP%3E%22Node-RED%20is%20a%20programming%20tool%20for%20wiring%20together%20hardware%20devices%2C%20APIs%20and%20online%20services%20in%20new%20and%20interesting%20ways.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20anyone%20in%20the%20community%20is%20using%20node-red%20in%20combination%20with%20O365%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexamples%3A%3C%2FP%3E%3CP%3Eretrieving%20data%20via%20REST%20API%20from%20O365%20and%20use%20them%20in%20whatever%20flow%20%3F%3C%2FP%3E%3CP%3Eor...post%20certain%20events%20from%20a%20node-red%20flow%20to%20a%20MS%20Teams%20channel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20share%20your%20opinion%20and%20examples%20(in%20case%20you%20have%20examples%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-97281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-324957%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324957%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Stefan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20we%20use%20Node-Red%20quite%20extensively%20with%20Office365%2C%20Flow%20and%20PowerApps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFlow%20is%20awesome%20and%20extremely%20easy%20to%20use%2C%20but%20it%20happens%20from%20time%20to%20time%20that%20you%20need%20to%20run%20an%20on%20premises%20instance%20workflow%20and%20Node-Red%20is%20very%20good%20at%20this.%20It%20is%20not%20as%20easy%20to%20use%20as%20Flow%20is%2C%20but%20it%20is%20very%20expandable%20without%20additional%20costs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20did%20a%20project%20recently%20where%20we%20needed%20PowerApps%20to%20RX%20data%20in%20a%20MongoDB%20(not%20Cosmos%20DB%2C%20Mongo)%20and%20we%20used%20Node-Red%20and%20agilite.io%20for%20this.%20The%20solution%20is%20amazing%20and%20PowerApps%20is%20a%20great%20front%20end%20for%20the%20solution.%20The%20MongoDB%2C%20Node-Red%20and%20Agilit-e%20instances%20are%20on%20premises%20so%20although%20Flow%20can%20interact%20with%20the%20solution%20(and%20is%20used%20as%20an%20API%20proxy%20to%20give%20external%20parties%20access%20to%20the%20system)%2C%20to%20just%20use%20Flow%20for%20this%20would%20not%20have%20been%20an%20option%20for%20this%20particular%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENode-Red%20is%20also%20great%20for%20IOT%20and%20I%20recently%20saw%20some%20guys%20using%20it%20with%20Azure%20IOT%20Hub.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20saw%20some%20videos%20from%20Agilit-e%20where%20Node-Red%20is%20used%20in%20conjunction%20with%20the%20MS%20Bot%20framework%20and%20it%20works%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20be%20great%20to%20hear%20what%20you%20have%20been%20using%20Node-Red%20for%20on%20O365%5CAzure%5CPower%20Platform%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138469%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138469%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Steven.%3C%2FP%3E%0A%3CP%3EI%20will%20work%20with%20Microsoft%20Graph%20and%20Flow.%26nbsp%3B%20I%20appreciate%20the%20input!%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EMarc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138153%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138153%22%20slang%3D%22en-US%22%3E%3CP%3EFlow%20is%20built%20on%20Azure%20Logic%20Apps%2C%20you%20can%20create%20additional%20connectors%20in%20logic%20apps%2C%20of%20export%20your%20flow%20and%20import%20it%20to%20logic%20apps%20to%20develop%20it%20further.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EKafka%20has%20various%20options%20for%20endpoints%2C%20for%20example%20HTTP%20which%20would%20be%20trivial%20for%20Flow%20to%20call.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFlow%20has%20existing%2C%20rich%20connectors%20for%20SharePoint%2C%20Skype%2C%20Teams%2C%20Email%20etc.%20If%20you%20want%20to%20send%20SMS%20then%20your%20would%20typically%20send%20an%20email%20to%20a%20gateway%20service%20of%20some%20kind%2C%20most%20mobile%20operators%20provide%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFlows%20access%20to%20Office%20365%20is%20fully%20documented%20as%20open%20APIs%20known%20as%20the%20Microsoft%20graph%2C%26nbsp%3Bit%20would%20be%20entirely%20possible%20for%20the%20Node-Red%20community%20to%20develop%20against%20it.%20It's%20documented%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138143%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138143%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Stefan%2C%3C%2FP%3E%0A%3CP%3EI%20am%20looking%20to%20exchange%20messages%20between%20Office%20365%20products%20and%20other%20services.%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20create%20a%20message%20in%20Sharepoint%20and%20the%20user%20will%20receive%20a%20Skype%20or%20Teams%20message%20along%20with%20an%20email%20in%20Outlook%20but%20also%2C%20a%20text%20via%20SMS.%26nbsp%3B%20Node%20Red%20will%20allow%20me%20to%20efficiently%20connect%20with%20other%20services%20other%20than%20Microsoft%20such%20as%20SMS%20or%20other%20messaging%20platforms.%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3EMarc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138030%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138030%22%20slang%3D%22en-US%22%3EHello%20Marc%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ewhat%20Skype%20things%20you%20want%20to%20cover%3F%3CBR%20%2F%3EA%20notification%20to%20a%20skype%20chat%3F%3CBR%20%2F%3ENotified%20whenever%20a%20specific%20user%20starts%20a%20conference%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOld%20lync%20backend%20or%20the%20new%20skype%20backend%20within%20teams%3F%3CBR%20%2F%3ETell%20me%20your%20use%20case%20and%20i%20can%20hopefully%20give%20you%20a%20proper%20answer%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EStef%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-138029%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-138029%22%20slang%3D%22en-US%22%3EHello%20Marc%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ewhat%20Skype%20things%20you%20want%20to%20cover%3F%3CBR%20%2F%3EA%20notification%20to%20a%20skype%20chat%3F%3CBR%20%2F%3ENotified%20whenever%20a%20specific%20user%20starts%20a%20conference%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOld%20lync%20backend%20or%20the%20new%20skype%20backend%20within%20teams%3F%3CBR%20%2F%3ETell%20me%20your%20use%20case%20and%20i%20can%20hopefully%20give%20you%20a%20proper%20answer%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EStef%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137986%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137986%22%20slang%3D%22en-US%22%3E%3CP%3EStefan%2C%3C%2FP%3E%0A%3CP%3EThanks%20forthe%20info!%3C%2FP%3E%0A%3CP%3EI%20want%20to%20use%20Node%20red%20with%20Skype%20and%20I%20am%20looking%20for%20some%20guidance.%26nbsp%3B%20If%20you%20have%20something%20to%20share%2C%20I%20would%20appreciate%20it!%3C%2FP%3E%0A%3CP%3ERegards%2C%3C%2FP%3E%0A%3CP%3EMarc%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137959%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137959%22%20slang%3D%22en-US%22%3E%3CP%3Eyes%2C%20node-red%20was%20initiated%20by%20ibm%2C%20but%20it%20is%20driven%20by%20a%20nice%20community%20%3A)%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eif%20you%20compare%20the%20amount%20of%20triggers%20within%20node-red%20with%20the%20%22175%20triggers%22%20MS%20flow%20offers%20at%20the%20moment%2C%20then%20i%20would%20say%20that%20the%20open%20community%20of%20node-red%20offers%20much%20more%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fflows.nodered.org%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflows.nodered.org%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethe%20main%20target%20group%20for%20MS%20Flow%20(in%20my%20opinion)%20are%20the%20Endusers%3C%2FP%3E%0A%3CP%3E--%26gt%3Bif%20there%20is%20a%20new%20file%20on%20onedrive%2C%20then%20do%20whatever)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E..whereas%20with%20Node-red%20you%20have%20plenty%20of%20things%20for%20system%20people%20(and%20all%20the%20folks%20who%20are%20interested%20in%20this%20IoT%20topic)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eone%20example%3A%3C%2FP%3E%0A%3CP%3Ethere%20is%20no%20ms%20flow%20thingie%20available%20for%20Apache%20Kafka.%20Kafka%20is%20in%20my%20case%20one%20key%20element%20which%20i%20use%20to%20re-route%20all%20differnt%20things%20(and%20to%20use%20it%20in%20combination%20with%20node-red).%3C%2FP%3E%0A%3CP%3EIf%20you%20miss%20a%20%22Node%22%2C%20then%20just%20develope%20it%20yourself....%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethere%20are%20for%20sure%20dozens%2Fhundreds%20of%20other%20usecases.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eas%20said%2C%20MS%20Flow%20is%20cool%20stuff...but%20just%20targeting%20endusers%20which%20is%20in%20my%20case%20the%20wrong%20group%20of%20people.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137940%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137940%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20what%20ways%20is%20this%20not%20just%20an%20IBM%20version%20of%20Microsoft%20Flow%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137929%22%20slang%3D%22en-US%22%3ERe%3A%20Anyone%20using%20Node-Red%20in%20combination%20with%20Office365%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137929%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Stefan%2C%3C%2FP%3E%0A%3CP%3EI%20am%20interested%20in%20doing%20the%20same%2C%20using%20Node%20Red%3B%20have%20you%20made%20some%20progress%3F%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3EMarc%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Super Contributor

"Node-RED is a programming tool for wiring together hardware devices, APIs and online services in new and interesting ways."

 

I'm wondering if anyone in the community is using node-red in combination with O365 ?

 

examples:

retrieving data via REST API from O365 and use them in whatever flow ?

or...post certain events from a node-red flow to a MS Teams channel?

 

please share your opinion and examples (in case you have examples :)

thank you

 

 

 

10 Replies
Highlighted

Hi Stefan,

I am interested in doing the same, using Node Red; have you made some progress?

Thanks!

Marc

Highlighted

In what ways is this not just an IBM version of Microsoft Flow?

 

 

Highlighted

yes, node-red was initiated by ibm, but it is driven by a nice community :)

 

if you compare the amount of triggers within node-red with the "175 triggers" MS flow offers at the moment, then i would say that the open community of node-red offers much more

https://flows.nodered.org/

 

the main target group for MS Flow (in my opinion) are the Endusers

-->if there is a new file on onedrive, then do whatever)

 

..whereas with Node-red you have plenty of things for system people (and all the folks who are interested in this IoT topic)

 

one example:

there is no ms flow thingie available for Apache Kafka. Kafka is in my case one key element which i use to re-route all differnt things (and to use it in combination with node-red).

If you miss a "Node", then just develope it yourself....

 

there are for sure dozens/hundreds of other usecases.

 

as said, MS Flow is cool stuff...but just targeting endusers which is in my case the wrong group of people.

 

 

Highlighted

Stefan,

Thanks forthe info!

I want to use Node red with Skype and I am looking for some guidance.  If you have something to share, I would appreciate it!

Regards,

Marc

 

Highlighted
Hello Marc,

what Skype things you want to cover?
A notification to a skype chat?
Notified whenever a specific user starts a conference?

Old lync backend or the new skype backend within teams?
Tell me your use case and i can hopefully give you a proper answer :)

Stef
Highlighted
Hello Marc,

what Skype things you want to cover?
A notification to a skype chat?
Notified whenever a specific user starts a conference?

Old lync backend or the new skype backend within teams?
Tell me your use case and i can hopefully give you a proper answer :)

Stef
Highlighted

Hi Stefan,

I am looking to exchange messages between Office 365 products and other services.

For example, create a message in Sharepoint and the user will receive a Skype or Teams message along with an email in Outlook but also, a text via SMS.  Node Red will allow me to efficiently connect with other services other than Microsoft such as SMS or other messaging platforms.

Thanks!

Marc

Highlighted

Flow is built on Azure Logic Apps, you can create additional connectors in logic apps, of export your flow and import it to logic apps to develop it further.

 

Kafka has various options for endpoints, for example HTTP which would be trivial for Flow to call.

 

Flow has existing, rich connectors for SharePoint, Skype, Teams, Email etc. If you want to send SMS then your would typically send an email to a gateway service of some kind, most mobile operators provide them.

 

Flows access to Office 365 is fully documented as open APIs known as the Microsoft graph, it would be entirely possible for the Node-Red community to develop against it. It's documented at https://developer.microsoft.com/en-us/graph

 

Highlighted

Thanks Steven.

I will work with Microsoft Graph and Flow.  I appreciate the input! 

Regards,

Marc

Highlighted

Hi Stefan,

 

Yes we use Node-Red quite extensively with Office365, Flow and PowerApps.

 

Flow is awesome and extremely easy to use, but it happens from time to time that you need to run an on premises instance workflow and Node-Red is very good at this. It is not as easy to use as Flow is, but it is very expandable without additional costs.

 

We did a project recently where we needed PowerApps to RX data in a MongoDB (not Cosmos DB, Mongo) and we used Node-Red and agilite.io for this. The solution is amazing and PowerApps is a great front end for the solution. The MongoDB, Node-Red and Agilit-e instances are on premises so although Flow can interact with the solution (and is used as an API proxy to give external parties access to the system), to just use Flow for this would not have been an option for this particular solution.

 

Node-Red is also great for IOT and I recently saw some guys using it with Azure IOT Hub.

 

I also saw some videos from Agilit-e where Node-Red is used in conjunction with the MS Bot framework and it works great.

 

Would be great to hear what you have been using Node-Red for on O365\Azure\Power Platform?