Answered

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

Like (1) Share

Report

Posted on 17 Jul 2019 10:10:07 by Community Power Pla...

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

Categories:

Business Process Flows

I have the same question (0)

All responses (8)

Answers (1)

WHSBPjM 59 on 30 Jan 2024 at 22:36:42

Like (0)

Report

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

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

Was this reply helpful? Yes No
kz88 6 on 27 Oct 2023 at 00:49:06

Like (2)

Report

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

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"}]

Was this reply helpful? Yes No
Ahemed 21 on 28 Mar 2023 at 10:26:07

Like (4)

Report

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

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()'), ', ')

2 people found this reply helpful.

Was this reply helpful? Yes No
RamMaddela on 18 Aug 2022 at 03:32:39

Like (2)

Report

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

Remove the 0 and it should work

Was this reply helpful? Yes No
jkb6011 122 on 19 Apr 2022 at 13:24:43

Like (0)

Report

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

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.'.

Was this reply helpful? Yes No
NHes 9 on 12 Jan 2021 at 20:58:49

Like (0)

Report

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

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

Was this reply helpful? Yes No
mode7 8 on 20 Nov 2019 at 19:42:06

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on 18 Jul 2019 at 02:04:19

Like (6)

Report

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

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,

1 people found this reply helpful.

Was this reply helpful? Yes No