Hello Community,
I want to copy rows from excel to the list page, but I cannot
If I have a boolean value as YES/NO in excel grids then I can easily copy/paste in list page.
When I export the data from the list page to excel, the boolean fields come as TRUE/FALSE
Good thing is that I import the data with boolean values from excel to the list page through code for both TRUE/FALSE and YES/NO, and it is working fine.
Hence I cannot validate the boolean value as TRUE/FALSE when I copy it from excel, I can only do it for YES/NO.
There are thousands of rows and I cannot make every value as YES/NO if it is exporting in TRUE/FALSE.
Is it possible for me to export the boolean values in excel as YES/NO instead of TRUE/FALSE?? Or what is the solution for my problem..
Regards.