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.
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?
I'm not sure if I understand your problem correctly:
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?
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.
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?
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.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!