Retrieve the value from "[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":5,"Value":"Reporting"}]"

[Anonymous]

Hi All,

I'm trying to create a flow that runs every Monday at 10am. This flow, gets the items from a SharePoint list, filters it to Status = Open and then, I would like to send the results by email.

This is the chain of actions I've been using:

1 - Reccurrence: runs every Monday at 10am

2 - Get items: go to the list, filter it to Status = Open

3 - Create HTML Table: this is where things go wrong, I then receive the email, but the fields I chose come as "[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":5,"Value":"Reporting"}]" and I just want to select the actual "Value". I've tried using the expression item()?['Service']?['Value'] but Flow doesn't recognize it

4 - Send HTML by email

Can you help me out please?

Kind Regar

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

I suspect that this field is allowed to be multiple-selected, so the output of this field is an array.

If you want to use the expression to get the value of this field, you should add array index to get the element, like item()?['Service'][0]['Value'].

If this choice filed is radio option, it is recommended that you could set this field to Radio Buttons, then you could use item()?['Service']?['Value'] directly to get field value.

Best Regards,

[mode7]

I have a similar problem and I have a question about step 2

2 - Get items: go to the list, filter it to Status = Open

I'am retrieving all the lines in one step and filtering in another.

Is it possible to use an equivalent odata expression to get only what I need? I want to filter based is an entry inside the object:

        "Status": {

        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

        "Id": 5,

        "Value": "Execute"

        }

I want to do it all in the "get item" step, so I tried it with an odata filter expression like this :

         status.value eq 'Execute'

but doing the above fails. Would someone with more knowlege guide me please.

[NHes]

I think you can now simply use the Value type dynamics field vs the Column type only like below:

[jkb6011]

Unable to process template language expressions in action 'Populate_a_Microsoft_Word_template_2' inputs at line '0' and column '0': 'The template language expression 'item()?['STATE'][0]['Value']' cannot be evaluated because property '0' cannot be selected. Object properties can only be selected by names. Please see https://aka.ms/logicexpressions for usage details.'.

[RamMaddela]

Remove the 0 and it should work

[Ahemed]

Add this expression into power automate and replace your column name (internal name)

Expression

join(xpath(xml(json(concat('{"body":{"value":', item()?['COLUMN NAME'] , '}}'))), '/body/value/Value/text()'), ', ')

[kz88]

Hello, can you help me understand how where to use/write item()?['Service']?['Value'] ?

I have a simple flow to get data from SharePoint List, put it into a csv table format, and save it into a csv file. 

Everything works great except for one field, which is an array/multi-select field that allows the user to select more than 1 of the choices. 

When this field gets saved into csv file, I only want to have the value, but there's a string of information that comes attached to the value:

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"ProductB"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"ProductZ"}]

[WHSBPjM]

Thanks @Ahemed, your expression was the perfect solution to my needs. Helped as soon as I plugged it in.