Message Center to Planner - PowerShell walk-through

%3CLINGO-SUB%20id%3D%22lingo-sub-121801%22%20slang%3D%22en-US%22%3EMessage%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-121801%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20posted%20part%201%20of%20my%20walk-through%20of%20the%20PowerShell%20code%20in%20the%20Azure%20Functions%20behind%20the%20Change%20management%20sample%20-%20explaining%20my%20code%20for%20the%20pulling%20of%20data%20from%20the%20Message%20Center%20and%20writing%20it%20out%20to%20the%20storage%20queue%20-%20and%20part%202%20will%20cover%20picking%20it%20up%20and%20creating%20tasks!%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Flwal.me%2F3z%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Flwal.me%2F3z%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-121801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EChange%20Management%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPlanner%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123360%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123360%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20nice.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-123289%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123289%22%20slang%3D%22en-US%22%3E%3CP%3ETotally%20agree%20Paul%2C%20and%20I%20did%26nbsp%3Bthink%20about%20having%20an%20'other'%20bucket%20where%20the%20ones%20I%20didn't%20catch%20by%20title%20would%20be%20dumped%20and%20they%20could%20be%20manually%20assigned.%26nbsp%3B%20I%20also%20reached%20out%20to%20the%20team%20who%20own%20the%20message%20center%20and%20service%20health%20dashboard%20-%20they%20have%20considered%20making%20some%20of%20the%20other%20fields%20mandatory%20(like%26nbsp%3BAffectedWorkloads)%20but%20that%20needs%20some%20API%20level%20changes.%3C%2FP%3E%0A%3CP%3EAlso%20I%20just%20posted%20part%202%20of%20the%20walkthrough%20-%20%3CA%20href%3D%22https%3A%2F%2Flwal.me%2F37%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Flwal.me%2F37%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3EBest%20regards%2C%3C%2FP%3E%0A%3CP%3EBrian.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-122457%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-122457%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20really%20interesting%20sample.%20One%20possible%20issue%20is%20the%20product%20matching%2C%20if%20a%20MC%20notice%20is%20posted%20without%20the%20product%20clearly%20noted%20then%20it%20could%20get%20missed.%20Still%2C%20the%20easy%20workaround%20is%20just%20to%20post%20everything%20to%20Planner%20since%20theoretically%20all%20MC%20notices%20apply%20to%20active%20services%20in%20your%20tenant%20and%20should%20be%20reviewed%20anyway.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-121887%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-121887%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Juan%20Carlos%20-%20fixed!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-121857%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-121857%22%20slang%3D%22en-US%22%3EThe%20point%20at%20the%20end%20of%20the%20Url%20makes%20the%20link%20not%20working!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454169%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454169%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F68%22%20target%3D%22_blank%22%3E%40Brian%20Smith%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20that%20Microsoft%20has%20added%20to%20their%20roadmap%20this%20item%2C%20%22%3CSPAN%3ESync%20Message%20Center%20posts%20to%20Planner%3C%2FSPAN%3E%22%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-US%2Fmicrosoft-365%2Froadmap%3Ffilters%3D%26amp%3Bsearchterms%3D63317%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-US%2Fmicrosoft-365%2Froadmap%3Ffilters%3D%26amp%3Bsearchterms%3D63317%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20the%20same%20solution%20that%20you%20are%20offering%3F%26nbsp%3B%20What%20is%20Microsoft%20plan%3F%26nbsp%3B%20I%20see%20that%20the%20status%20is%20launched%20and%20that%20the%20release%20is%20Q2%20CY2020.%26nbsp%3B%20It%20is%20June%202020%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20a%20similar%20situation%20where%20I%20need%20the%20data%20to%20be%20reviewed%20and%20assigned%20to%20a%20change%20person.%26nbsp%3B%20I%20have%20an%20API%20that%20downloads%20all%20of%20the%20details%20into%20a%20SQL%20server.%26nbsp%3B%20Now%20just%20looking%20at%20developing%20a%20MS%20PowerApp%20to%20access%20it%20and%20update%20a%20few%20fields.%26nbsp%3B%20Then%20use%20Power%20BI%20to%20report%20on%20it.%26nbsp%3B%20Thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457766%22%20slang%3D%22en-US%22%3ERe%3A%20Message%20Center%20to%20Planner%20-%20PowerShell%20walk-through%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457766%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28507%22%20target%3D%22_blank%22%3E%40Ty%20Lewis%3C%2FA%3E%26nbsp%3Bit%20is%20fair%20to%20say%20this%20feature%20grew%20out%20of%20the%20idea%20I%20had%20after%20showing%20the%20team%20what%20I'd%20come%20up%20with.%2C%20but%20the%20team%20delivering%20it%20are%20doing%20it%20in%20a%20much%20more%20scalable%20way%20as%20it%20is%20going%20to%20all%20our%20customers.%26nbsp%3B%20They've%20done%20a%20much%20better%20job%20on%20the%20formatting%20of%20the%20content%20too.%26nbsp%3B%20They%20have%20also%20taken%20the%20decision%20to%20just%20put%20all%20the%20new%20messages%20for%20your%20chosen%20workloads%20into%20one%20bucket%20-%20so%20that%20they%20can%20be%20triaged%20and%20assigned.%26nbsp%3B%20You%20might%20well%20be%20able%20to%20automate%20some%20of%20that%20with%20PowerApps%20-%20and%20if%20I%20get%20some%20time%20I'm%20certainly%20going%20to%20be%20playing%20around%20with%20that.%26nbsp%3B%20I'm%20fortunate%20that%20it%20is%20already%20running%20in%20my%20tenant%20and%20I%20think%20the%20broader%20roll-out%20should%20be%20happening%20very%20soon.%26nbsp%3B%20The%20Power%20BI%20angle%20may%20still%20be%20a%20bit%20of%20a%20challenge%20-%20but%20you%20could%20push%20stuff%20with%20PowerApps%20into%20a%20more%20Power%20BI%20friendly%20store%20maybe%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBrian%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

I just posted part 1 of my walk-through of the PowerShell code in the Azure Functions behind the Change management sample - explaining my code for the pulling of data from the Message Center and writing it out to the storage queue - and part 2 will cover picking it up and creating tasks!  https://lwal.me/3z

7 Replies
Highlighted
The point at the end of the Url makes the link not working!
Highlighted

Thanks Juan Carlos - fixed!

Highlighted

This is a really interesting sample. One possible issue is the product matching, if a MC notice is posted without the product clearly noted then it could get missed. Still, the easy workaround is just to post everything to Planner since theoretically all MC notices apply to active services in your tenant and should be reviewed anyway.

Highlighted

Totally agree Paul, and I did think about having an 'other' bucket where the ones I didn't catch by title would be dumped and they could be manually assigned.  I also reached out to the team who own the message center and service health dashboard - they have considered making some of the other fields mandatory (like AffectedWorkloads) but that needs some API level changes.

Also I just posted part 2 of the walkthrough - https://lwal.me/37.

Best regards,

Brian.

Highlighted
Highlighted

@Brian Smith 

 

I see that Microsoft has added to their roadmap this item, "Sync Message Center posts to Planner"

https://www.microsoft.com/en-US/microsoft-365/roadmap?filters=&searchterms=63317

 

Is this the same solution that you are offering?  What is Microsoft plan?  I see that the status is launched and that the release is Q2 CY2020.  It is June 2020 now.

 

I am in a similar situation where I need the data to be reviewed and assigned to a change person.  I have an API that downloads all of the details into a SQL server.  Now just looking at developing a MS PowerApp to access it and update a few fields.  Then use Power BI to report on it.  Thoughts?

Highlighted

Hi @Ty Lewis it is fair to say this feature grew out of the idea I had after showing the team what I'd come up with., but the team delivering it are doing it in a much more scalable way as it is going to all our customers.  They've done a much better job on the formatting of the content too.  They have also taken the decision to just put all the new messages for your chosen workloads into one bucket - so that they can be triaged and assigned.  You might well be able to automate some of that with PowerApps - and if I get some time I'm certainly going to be playing around with that.  I'm fortunate that it is already running in my tenant and I think the broader roll-out should be happening very soon.  The Power BI angle may still be a bit of a challenge - but you could push stuff with PowerApps into a more Power BI friendly store maybe?

 

Best regards,

 

Brian