use value of item to create csv table

[alpha2beta]

I am trying to export a SharePoint list to CSV file with Power Automate.

The flow was working but with a small issue:

Column "Notes" contains lookup items. When I used get_items -> create csv table, the content of this column is like

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":108,"Value":"Note_019"}]

I know that Dynamic content "Notes Id" pointing to 108 and "Notes Value" pointing to "Note_019".

But when I chose create csv from dynamic content "value", I couldn't find "Notes Value" for column "Notes"

Thanks in advance

[Paulie78 · Accepted solution]

It is because it is an array (within your array). So you can still work with it, but you would have to use an expression. But you could reach it by putting in an expression such as item()['Notes']?[0]?['Value']

[alpha2beta]

Thanks, it works. I tried expression but haven't done it right