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
