Export to a specific item in sharepoint list to csv using power automate (Get item)

(0) Share

Report

Posted on by Community Power Pla...

I am having difficulty to export a specific item in a sharepoint list to csv using power automate.

I am able to export all items on a sharepoint list to csv using "get items". However, when I use "get item" to create a csv table, it says it is an object, but requires an array to work with. How do I convert "get item" (to an array) as an input to "create csv table"?

The issue is "Get items" return an array (with square brackets), "Get item" returns an object (with curly brackets).

Thank you

Stephen

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (1)

Report

Re: Export to a specific item in sharepoint list to csv using power automate (Get item)

Thank you. Indeed. Didn’t think of that.
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

Re: Export to a specific item in sharepoint list to csv using power automate (Get item)

Hi @Anonymous,

The quickest workaround is just typing those square brackets in the From field.

Below is an example