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

Building a flow that take items from list and exports to csv

I'm building a flow that takes items from a list and puts them into a CSV. The issue im having is I have four fields I want. 

 

E-Mail Address

First

Last

Custom (yes/no) (labeled kids360)

 

When it runs the output instead of saying yes or blank it says false on some of them and doesnt appear to be picking up the data. What am I missing?

 

Flow

 

 

4 REPLIES 4

Re: Building a flow that take items from list and exports to csv

I'm not sure if I understand your problem correctly:

 

  • The input data is a list of objects containing each an email adress, a first and last name and a custom label that should be "yes" or "no".
  • When you run your flow, a CSV Table is created
  • For some of the entries, the "custom" field is not correctly filled. Instead of the expected "yes/no", you get "false".

Correct sofar?

 

Can you please show an example of the input and output you get? How does the data looks like in your list and how does it look like in the CSV table?

rdalrymple
Level: Powered On

Re: Building a flow that take items from list and exports to csv

Yes one of the fields is Kids360 and the data that is in the field is a yes/no option. Allot of the fields currentlly say no or there blank but I need that data to be exported. Below is a screenshot of the list and a screenshot of what is currentlly being exported with the flow.

 

gof6BupbACbDl6

Re: Building a flow that take items from list and exports to csv

Hum... ok. Do you have access to the underlying data? 

 

If I remember well the Yes/No datatypes in sharepoint can be interpreted from Yes/No, 0/1, True/False and On/Off. If you additionally have a default value to "no" in Sharepoint, it could it be that you have different data in your column, including "no", "false" and " ", that all those get interpreted by sharepoint to "no" in the UI.

 

Does it makes sense?

Community Support Team
Community Support Team

Re: Building a flow that take items from list and exports to csv

Hi @rdalrymple,

 

Could you please share a screenshot of the flow run details when the flow run failed?

Could you please share more details about the error message?

 

Please share more details so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,712)