Export plans comments to excel and verification list when exported to excel is not in correct order

%3CLINGO-SUB%20id%3D%22lingo-sub-753675%22%20slang%3D%22en-US%22%3EExport%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753675%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%C2%B4s%20any%20way%20to%26nbsp%3BExport%20plans%20comments%20to%20excel%20%3F%3C%2FP%3E%3CP%3EI%20check%20also%20that%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20order%2C%20its%20random.%20Can%20this%20be%20fixed%3F%3C%2FP%3E%3CP%3EThanks%20for%20support.%3C%2FP%3E%3CP%3ERicardo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753824%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20or%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753824%22%20slang%3D%22en-US%22%3EUnforntunaltely%20there%20is%20not%20a%20default%20way%20to%20export%20plans%20comments%20to%20excel%2C%20you%20will%20have%20to%20build%20buy%20yourself%20using%20Graph%20API.%20In%20regards%20of%20the%20problem%20you%20have%20experienced%20in%20the%20Export%20to%20excel%20feature%2C%20I%20would%20also%20advice%20to%20open%20a%20support%20ticket%20to%20notify%20the%20issue%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811034%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20or%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1547%22%20target%3D%22_blank%22%3E%40Santhosh%20Balakrishnan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20what%20third%20party%20are%20you%20using%20in%20this%20instance%20to%20pull%20out%20comments%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756278%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20or%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3BI%20Agree.%20Even%20with%20the%20Graph%20API%20it%20is%20complicated%20to%20get%20the%20task%20comments%20as%20the%20Planner%20task%20comments%20are%20stored%20in%20Exchange%20group%20mailboxes.%20You%20need%20to%20rely%20on%20third-party%20apps%20for%20export%2Fimport%20planner%20tasks%20from%20excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-821212%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20or%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821212%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394593%22%20target%3D%22_blank%22%3E%40jasminjenkinsontonik%3C%2FA%3E%26nbsp%3BApps4.Pro%20Planner%20Manager%20works%20well%20for%20your%20case.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fapps4.pro%2Fplanner-manager.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapps4.pro%2Fplanner-manager.aspx%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824140%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20or%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1547%22%20target%3D%22_blank%22%3E%40Santhosh%20Balakrishnan%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20help!%20Don't%20suppose%20you%20know%20the%20license%20cost%20after%20the%20trial%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824286%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20plans%20comments%20to%20excel%20and%20verification%20list%20when%20exported%20to%20excel%20is%20not%20in%20correct%20or%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394593%22%20target%3D%22_blank%22%3E%40jasminjenkinsontonik%3C%2FA%3E%26nbsp%3BIt%20costs%2049%20USD%20per%20user%20year%20after%20the%20free%20trial.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

Hi everybody

 

There´s any way to Export plans comments to excel ?

I check also that verification list when exported to excel is not in correct order, its random. Can this be fixed?

Thanks for support.

Ricardo.

 

 

6 Replies
Highlighted
Unforntunaltely there is not a default way to export plans comments to excel, you will have to build buy yourself using Graph API. In regards of the problem you have experienced in the Export to excel feature, I would also advice to open a support ticket to notify the issue
Highlighted

@Juan Carlos González Martín I Agree. Even with the Graph API it is complicated to get the task comments as the Planner task comments are stored in Exchange group mailboxes. You need to rely on third-party apps for export/import planner tasks from excel. 

Highlighted

@Santhosh Balakrishnan 

 

Hi what third party are you using in this instance to pull out comments? 

 

 

Highlighted

@Santhosh Balakrishnan Thanks for your help! Don't suppose you know the license cost after the trial? 

 

Highlighted