Mutlichoice field in Sharepoint List Not able to export

Question

I have a List that I created .. With Column Names ID, Name and Associated Department

The Associated Department Department Column was originally named "TaskAssociationtoDepartment"

This is a multichoce Column, creating in Power Automate flow and I have a Get Item --> Select -->

in select i have Map in map I have this in expression

join(xpath(xml(json(concat('{"body":{"value":', item()?['TaskAssociationtoDepartment'] , '}}'))), '/body/value/text()'), '; ')

in json I see

 "TaskAssociationtoDepartment": [
      {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
        "Id": 17,
        "Value": "Information Technology"
      }
    ]
Where is my formula incorrect. Rest of the columns work just fine..

Answer 1

Hi @Aishwarya Apte ,

According to your description, your problem is related to Power Automate.

Since Power Automate is currently not supported in the Q&A forum. Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

Hope this can help you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

"TaskAssociationtoDepartment": [

  {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

    "Id": 17,

    "Value": "Information Technology"

  }

]

Where is my formula incorrect. Rest of the columns work just fine..