cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mterry
Level: Powered On

Trouble creating csv file from SharePoint list

I'm having issues creating a csv table from a SharePoint list  - everything works fine except the data that comes from a drop-down list. For those fields I get the below where the final part of the string is the real data I want - 2017 in my example. 

 

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"2017"}

 

I tried to solution in the post below and it didn't work, wondering what my options are?

https://powerusers.microsoft.com/t5/Building-Flows/Exporting-SharePoint-List-as-CSV-template/m-p/137...

 

Here's my flow for reference:flow.png

1 ACCEPTED SOLUTION

Accepted Solutions
RookieI
Level: Powered On

Re: Trouble creating csv file from SharePoint list

If the field type is Choice, Dynamic content you need to use is the value.

 

For example, if the field name is drop-down, then you need to select drop-down Value.

22.PNG

4 REPLIES 4
RookieI
Level: Powered On

Re: Trouble creating csv file from SharePoint list

If the field type is Choice, Dynamic content you need to use is the value.

 

For example, if the field name is drop-down, then you need to select drop-down Value.

22.PNG

mterry
Level: Powered On

Re: Trouble creating csv file from SharePoint list

I don't have the option for 'drop-down Value' in the dynamic content, not sure why. However, I did find a 'Benefits_Year Value' option, which appears to have worked. Any idea why I don't have the drop down option but do have the value option?

Super User
Super User

Re: Trouble creating csv file from SharePoint list

The post above was using Drop Down Value as an example, since they don’t have a replica of your SharePoint list.

Obviously your list has a column called Benefits_Year (that will be the internal name) so ‘Benefits_Year Value’ works for you.
mterry
Level: Powered On

Re: Trouble creating csv file from SharePoint list

I've now noticed that the csv file that gets exported is omitting certain items from the SharePoint list. I'm looking through to see what the omissions have in common, right now all I can tell is that for some of the items in the list there aren't always values for all of the columns I've chosen to have exported - would that cause the export job to leave those rows out entirely?

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 204 members 4,990 guests
Please welcome our newest community members: