Hello, I’ve imported data from SharePoint 365 to Dataverse and it seems like a straightforward process. As I view the data in power query during the import process all of my data looks good. But after the import, the Boolean fields are missing all of their values. The fields exist, but they aren’t true or false. I can open the table and give it a value or I can update it in PowerApps, so I know the fields “work”. I’ve tried multiple ways to no avail. I’d hate to have to change my data architecture to use Dataverse.
Any thoughts on why?
So, as a workaround, I created a couple fields in my SharePoint list:
Calculated field name IsCompleted_Number and would have the numerical value of 1 if IsCompleted = true, else 0
The fields worked perfectly and imported as a number into Dataverse as numbers just fine. Then, I used PowerApps and ran code similar to below to update the newly created IsCompleted field
UpdateIf(NewTable,
IsCompleted_Number = 1,
{IsCompleted: true});
It updates some of them. There seems to be a delegation limit here, but one of list has less than 2000 records and I have delegation set to 2000 now. Delegation shouldn’t be a problem. It still updates some of the rows. I can see the IsCompleted_Number field = 1 and the IsCompleted Boolean field never change to true or false.
Some of them updated just fine. I have had this tested on around 5 or so Boolean fields and still have the same problem. I also see no rhyme or reason as to which fields it does update either. Some here and some there
