Importing SharePoint Data - Boolean Problems

[Roystreet]

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

[AhmedSalih]

Hello, @Roystreet, Did you created the Dataverse tables first then used a Dataflows to load the Data?

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

[Roystreet]

Imported first

[Roystreet · Accepted solution]

Since I couldn’t figure out how to get it correctly, I exported the Sharepoint list to an excel file.  Removed all data, just keeping the columns so I don’t have to resign the whole thing, except the Boolean columns.  Created booleans fields in the new table.

Then…Using powerapps patched data into the table.  I don’t know why it has an issue with the columns and I know I did more work than necessary, but I tried over and over what should’ve worked.  I tried multiple methods to no avail.

Dataverse looks promising, but it does have other challenges as well.