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

Using a variable to store list items returns wrong values.

Im trying to get items from a Sharepoint list, store them all together into a variable and then send them trough an email. 

 

When the email arrives, I get this. 

 

[ {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Perez Labat Matias"}, ][ {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"Proveedor 2"}, ][ {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Perez Labat Matias"}, ][ {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Perez Labat Matias"}, ]

 

What can be causing this?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User III
Super User III

Hi @Manuel_Urizar 

 

Looks like its a multi-selected item and if you want to get the Value only then see the below post.

 

Solved: Retrieve the value from "[{"@odata.type":"#Microso... - Power Platform Community (microsoft....

 

Let me know how it goes.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

1 REPLY 1
abm
Super User III
Super User III

Hi @Manuel_Urizar 

 

Looks like its a multi-selected item and if you want to get the Value only then see the below post.

 

Solved: Retrieve the value from "[{"@odata.type":"#Microso... - Power Platform Community (microsoft....

 

Let me know how it goes.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (80,428)