Link to specific task in the Team Planner

%3CLINGO-SUB%20id%3D%22lingo-sub-2139704%22%20slang%3D%22en-US%22%3ELink%20to%20specific%20task%20in%20the%20Team%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139704%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20are%20using%20Team%20Tasks%20to%20get%20an%20overview%20of%20tasks%20for%20our%20team%20and%20the%20tasks%20are%20exported%20to%20Excel%20to%20be%20used%20as%20a%20data%20source%20in%20Tableau%20for%20further%20analysing.%20I%20would%20then%20like%20to%20create%20a%20link%20to%20the%20Team%20tasks%20directly%20from%20Tableau.%20Looking%20closer%20at%20the%20link%20I%20get%20when%20copying%20a%20link%20to%20a%20specific%20task%20from%20the%20Team%20webside%20it%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftasks.office.com%2FDFDS.onmicrosoft.com%2FHome%2FTask%2FTmx216HM6kaHtdo-SPNfWpYAOtb9%3FType%3DTaskLink%26amp%3BChannel%3DLink%26amp%3BCreatedTime%3D637490872581330000%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftasks.office.com%2FDFDS.onmicrosoft.com%2FHome%2FTask%2FTmx216HM6kaHtdo-SPNfWpYAOtb9%3FType%3DTaskLink%26amp%3BChannel%3DLink%26amp%3BCreatedTime%3D637490872581330000%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETo%20me%2C%20it%20seems%20that%20the%20last%20part%20%22Link%26amp%3BCreatedtime...%22%20is%20representing%20the%20unique%20identification%20of%20a%20task%20but%20how%20do%20I%20get%20this%20field%20exported%20to%20the%20Excel%20file%20to%20be%20used%20as%20a%20variable%20part%20in%20the%20URL%20in%20Tableau%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20suggestions%20%3F%3C%2FP%3E%3CP%3EThanks%20very%20much%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

We are using Team Tasks to get an overview of tasks for our team and the tasks are exported to Excel to be used as a data source in Tableau for further analysing. I would then like to create a link to the Team tasks directly from Tableau. Looking closer at the link I get when copying a link to a specific task from the Team webside it looks like this:

https://tasks.office.com/DFDS.onmicrosoft.com/Home/Task/Tmx216HM6kaHtdo-SPNfWpYAOtb9?Type=TaskLink&C...

To me, it seems that the last part "Link&Createdtime..." is representing the unique identification of a task but how do I get this field exported to the Excel file to be used as a variable part in the URL in Tableau?

Any suggestions ?

Thanks very much in advance.

0 Replies