cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rogermiddleton
Helper II
Helper II

Wrong text with get items on multiple choice field

Hi,

 

I am getting items from a SP list from a multiple choice column using an array and creating a HTML table. The only problem is that the flow returns: 

 

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"Afronding"}

 

This is the flow I am using:

 

Rogermiddleton_0-1606128377775.png

Anyone have an idea how to get the value in the HTML table instead of the long line of text?

 

Kind regards,

 

Roger Middleton

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User III
Super User III

Where you have the Status field right now, you could try an expression like this:

item()['Status']['Value']

That might not be quite right, but try it and see how you get on.

View solution in original post

2 REPLIES 2
Paulie78
Super User III
Super User III

Where you have the Status field right now, you could try an expression like this:

item()['Status']['Value']

That might not be quite right, but try it and see how you get on.

View solution in original post

Hi @Paulie78 ,

 

Your solution works perfect! Thanks!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (49,256)