You’re offline. This is a read only version of the page.
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
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"}]
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()'), ', ')
Remove the 0 and it should work
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.'.
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:
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
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (