cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcB85
New Member

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1647335722552.png

2. Here is my excel table.

vyujincuimsft_1-1647335762795.png

3. Here is my Flow.

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

vyujincuimsft_2-1647335829742.png

vyujincuimsft_3-1647335976300.png

vyujincuimsft_4-1647336238813.png

Result Screentshot:

vyujincuimsft_5-1647336332484.png

 

Best Regards,

Charlie Choi

View solution in original post

6 REPLIES 6
KvB1
Solution Sage
Solution Sage

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

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

KvB1
Solution Sage
Solution Sage

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

Is this what you means?  

 

triggerOutputs()?['body/WhoElseInvolved_002d_Catagory']

KvB1
Solution Sage
Solution Sage

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
Community Support
Community Support

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.

vyujincuimsft_0-1647335722552.png

2. Here is my excel table.

vyujincuimsft_1-1647335762795.png

3. Here is my Flow.

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

vyujincuimsft_2-1647335829742.png

vyujincuimsft_3-1647335976300.png

vyujincuimsft_4-1647336238813.png

Result Screentshot:

vyujincuimsft_5-1647336332484.png

 

Best Regards,

Charlie Choi

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,588)