cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PavelBaranov
Regular Visitor

Select item from SharePoint Choice Field

Dear friends I have a simple flow that:

1. Gets items from SharePoint List

2. Filters SharePoint List items that have empty cells in specific column

3. Selects Filtered Data

4. Creates HTML table from the Selected Filtered Data

5. Creates Email Message and inserts HTML table into the body of the email

6. Submits email message to user

 

The fact is that SharePoint List contains Choice Field. When I use SELECT action to take Choice Field Element Value I get the following statement: 

 

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"РЗН"}

 

 

How to get the value of the Choice Field directly using SELECT action? Or is there any other means I can reference the Choice Field Value? 

 

Here is my flow 

PavelBaranov_0-1597257659225.png

PavelBaranov_1-1597257743374.png

PavelBaranov_2-1597257769675.png

PavelBaranov_3-1597257789437.png

 

 

 

 

 

 

  

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @PavelBaranov,

 

If the choice column isn't multiple choice column, you could use the following expression to get the value:

item()?['ChoiceName']['Value']

Annotation 2020-08-13 105855.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
leyburn19
Memorable Member
Memorable Member

I think yu may need to reference the ID of the field as it will be like a table.  Try an expression like

 

item('Reference to loop or Get Item')[0]['Column']

 

 

v-litu-msft
Community Support
Community Support

Hi @PavelBaranov,

 

If the choice column isn't multiple choice column, you could use the following expression to get the value:

item()?['ChoiceName']['Value']

Annotation 2020-08-13 105855.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thanks a lot for help.  

 

The approach is the working one:

item()?['ChoiceName']['Value']

 

Hi @PavelBaranov,

 

Glad it could work on your side, if your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
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!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (68,434)