Unanswered

Get File, Create CSV Export

(0) Share

Report

Posted on by nu2pwrautomate

Hello Power Automate Community!

I hope I have a simple problem that folks can help me with. I have a flow that runs without errors. I am taking an export of a SharePoint list and creating a nightly CSV for different uses. The issue I am having is the data I export has so many extra fields (i.e. "@OData.et" and similar fields) that are not in the SharePoint list I'm exporting. Also, the data that get returned has an odata string attached to it: i.e. {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1676,"Value":).

Any help on this matter would be greatly appreciated. The list I'm exporting has many fields and it would not make sense to use the manual function to isolate the fields I want, but even so I have tried the manual function and isolated 2 or 3 fields, but I have the same problem with the odata string. Thanks in advance for any insight on this issue.

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@nu2pwrautomate

Create a view that contains only the column that you want. Then, select that view in the Get items action under Limit Columns by view in advanced properties.

Was this reply helpful? Yes No
nu2pwrautomate 10 on at

Like (0)

Report

Scott, thank you so much for your feedback. That does not solve my issue as I am already using a view. after you suggestion, I created a new view to try again but still the output file is not easily consumable.

Annotation 2023-0...

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Use a select action to create an array of objects with only the required columns.

Was this reply helpful? Yes No
nu2pwrautomate 10 on at

Like (0)

Report

are you referring to the attached image? selecting the fields in the csv step?

Annotation 2023-0...

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

No, it's about inserting a new action (a Select action) that takes an array (the list items) and converts it to an array of objects with only the column you want:
E.g.
If you use the Select's output as Input of the Create CSV action, you will only get the columns "Title" and "Severity" there.

Was this reply helpful? Yes No
nu2pwrautomate 10 on at

Like (0)

Report

Chriddle, thank you for the advice, but unfortunately that still spits out an undesirable value. Please see attached sample xls.

Sample.xlsx

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Instead of e.g. "Name" use "Name value" from the dynamic content.

Was this reply helpful? Yes No
nu2pwrautomate 10 on at

Like (0)

Report

Chriddle, thank you for you continued added value! this definitely worked, but would you have an idea as to why the "Name value" doesn't exist for all the fields in the list?

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Your field returned this object because it's a lookup field.

Was this reply helpful? Yes No
nu2pwrautomate 10 on at

Like (0)

Report

okay, so I guess there's no way around that. but since that is the, what's the best way to import a file, or read the data with that kind of odata string? can power automate read that file and import into a new SharePoint list? because if that's the case then I can work with that.

Was this reply helpful? Yes No