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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!