cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alpha2beta
New Member

use value of item to create csv table

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

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

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

View solution in original post

2 REPLIES 2
Paulie78
Super User
Super User

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

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,397)