web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataflow error: Error ...
Power Apps
Answered

Dataflow error: Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

(0) ShareShare
ReportReport
Posted on by 401

Hello!

I have a complex dataflow that has been running smoothly for over a month... until this morning. It is a Standard V1 dataflow.

 

Starting today, I have begun getting failed upserts, with the following error message:

Error code: 0x80040265, Message: String was not recognized as a valid Boolean.

 

I am importing data into Yes/No columns (fields). This is an example of what I am loading: 

"cra0c_shipcomplete":"false"

 

Anyone else suddenly getting this issue?

I have the same question (0)
  • Charles Seguin Profile Picture
    401 on at

    @KSven : I'm thinking you have some experience with dataflows... have you had issues lately importing Yes/No (Boolean) values into Dataverse?

  • KSven Profile Picture
    182 on at

    Hi @CharlesS ,

     

    actually I'm working with Dataverse / Dataflows like a Data Warehouse incl. some ETL / ELTL processes, so yeah I guess I got some experience, but unfortunately I haven't used True or False with standard v2. Just choice columns with the regarding number.

    But anyway one of the following columns should work as a dataflow column, cause these are the results out of dataverse connector in Power Bi (or ODatafeed connector as well):

     

    Yes/No :

    I guess you have already tested datatype String/boolean? You could also try simple Yes / No as string...

    KSven_0-1613027623190.png

     

    Choice:

    Acutally works fine for me with the ID (e.g. 0 or 4)

    KSven_0-1613028061729.png

     

     

     

    Hope it helps little bit. Regarding to dataflows Ive already 2 open support tickets..

     

    BR,

    Sven

  • Verified answer
    Charles Seguin Profile Picture
    401 on at

    After much troubleshooting, I was able to find the cause of the error and solve the problem. It turns out that this message had nothing to do with importing yes/no fields, but was rather related to a problematic business rule.

     

    If ever you have a similar problem, here are the steps to solve it:

    1. Start by checking your business rules for the relevant entity.

    2. Pay particular attention to any conditions including numeric comparisons for fields that are imported using the dataflow, such as FieldA is greater than X.

    3. If, when importing this field, it sometimes includes null values, you will receive this error in your dataflow log and the record upload will fail.

    4. To solve this problem, add a new condition before your numerical comparison condition in your business rule. The new condition should be as follows : IF FieldA Does not Contain Data. 

    5. Place your previous numerical comparison condition under the FALSE branch of the newly created IF FieldA Does not Contain Data condition.

    6. Refresh your dataflow again.

    7. Rejoice.

     

    Basically, the "String was not recognized as a valid Boolean" error refers to the fact that the business rule was unable to get a valid TRUE/FALSE value from the numerical comparison of a null value.  Indeed, IF null < 3 = error.

     

    Hope this explanation can help others!

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Cheers for the update @CharlesS. I've experience similar issues with Dataflows as backend updates occur, what I've done unfortunately is simply re-create them...

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 993

#2
Valantis Profile Picture

Valantis 675

#3
11manish Profile Picture

11manish 545

Last 30 days Overall leaderboard