Hello,
I am using a DataTable to display data from my datasource, howerver i have a column that is a Yes/No data type but it is showing a check mark and i want it to display as a yes or no. I am displaying how it looks like. Any suggestions?
Thank you,
Solved! Go to Solution.
Hi @patty789 ,
Did you make sure that your data source is SharePoint list? I just tested with SharePoint Yes or No column and by default it shows as below in a data table control:
Try to delete this field from data table and add it again to test.
Regards,
Mona
You can remove the check box and just put in a label and put =If(ThisItem.ColumnName=true, "Yes","No")
There are a few ways you can do basically the same way but this is a quick and easy way.
@rebeccas Thank you for your reply howerver i am unable to remove the check mark as it is pulling straight from the datasource.
I am using a combo box to filter and using the DataTable to diplay based on the address. I tired to go to the Text property of the column and modify it there but it does not take the change it still shows as a checkmark. If(ThisItem.ColumnName = true, "Yes", "No")
Sorry...I didn't catch the "Data Table" part that you had clear as day..lol.
I don't think there is a way to change that in there. Only two options I know would be to change your column to a text and then control where it gets put in to allow only Yes/No to go in (by using a control) but where it is stored as text or to use a gallery instead of the data table.
You can make a gallery do just about anything a data table can with alot more customizing options. That is the route I would take if it were me. Best of luck!
Hi @patty789 ,
Did you make sure that your data source is SharePoint list? I just tested with SharePoint Yes or No column and by default it shows as below in a data table control:
Try to delete this field from data table and add it again to test.
Regards,
Mona
@v-monli-msft Thank you for your response. I end it up changing the column in the SharePoint list to a choice type and that worked for me. I had it as a YES/NO type in the sharepoint list. Thank you for all your help
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |