Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Planner Multiple Assigned Task Filter

Hello Community,   I have a question related to Microsoft Planner Export to Excel function. It gives multiple assigned task values with semi colon as "Name1 Surname1; Name2 Surname2".  It is recogn...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    Please expand the data by click the icon.

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hİ v-frfei-msft ,

     

    Thank you for the solution offer. I expanded the excel data as rows with Split Column button. This option worked for my raw excel data. So, I eliminated the Sharepoint list step. 

     

    For planner reporting, going with the row option is very useful since it is possible to count distinct values of rows. Planner Export option gives unique task id for this purpose I believe. 

     

    clipboard_image_0.png

     

     

    Thanks again for your help. 

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Please expand the data by click the icon.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hİ v-frfei-msft ,

     

    Thank you for the solution offer. I expanded the excel data as rows with Split Column button. This option worked for my raw excel data. So, I eliminated the Sharepoint list step. 

     

    For planner reporting, going with the row option is very useful since it is possible to count distinct values of rows. Planner Export option gives unique task id for this purpose I believe. 

     

    clipboard_image_0.png

     

     

    Thanks again for your help.