Multi Select From 'Choice' Column In Sharepoit List Not Adding to Excel Table Properly

[MarcB85]

Hi,

I have a Column in a Sharepoint List that is a Choice with muli select.  However, the flow I have created seems to provide me with the following in the Excel table:

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"No-One"}]

I can see the correct value/s there but why I am I getting this other information please?  Sorry I'm very new to this.

[KvB1]

A choice column in SharePoint is populated by a record. When youre looking at the list, you only see the value.

You can change the flow to grab the value from the record, and use that to populate a cell in excel. You would add ['value'] or ?['value'] or .['value'] to the expression

[MarcB85]

Thanks KvB1.  Is there an expression I'd need to use?  Currently there is no expression I just used the dynamic content.

[KvB1]

Yes you would. If you mouseover the dynamic content, you should see a bit more. Could you share that please?

[MarcB85]

Is this what you means?  

triggerOutputs()?['body/WhoElseInvolved_002d_Catagory']

[KvB1]

I guess so, if that is the trigger of your automate, you should be able to use this as an expression rather than use the dynamic content:

triggerOutputs()?['body/WhoElseInvolved_002d_Catagory']['value']

[v-yujincui-msft · Accepted solution]

Hi @MarcB85 ,

Do you want to save the value of the multiple Section Choice Column to an excel table?

I have made a test for your reference.

1. Here is my SharePoint list.

2. Here is my excel table.

3. Here is my Flow.

replace(variables('var_status'),' ','')

Result Screentshot:

Best Regards,

Charlie Choi