Forum Discussion

Jeffrey2's avatar
Jeffrey2
Icon for Helper I rankHelper I
4 years ago

Expression.Error: We cannot convert the value 1110011 to type Text.

We have a daily report that we run with no issues. Today we received the "Expression.Error: We cannot convert the value 1110011 to type Text." message and it doesn't make sense. The source spreadshee...
Need Help
Jeffrey2's avatar
Jeffrey2
Icon for Helper I rankHelper I
4 years ago

Thank you for the response. I did not know about that feature so that was good to know. 

 

However, strangely enough, every column shows Valid 100%. When I select "Keep Errors", I still get the Expression.Error: We cannot convert the value 1110011 to type Text. message.

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Create a duplicate query and before the final step, Home, remove rows, remove blank rows and then see what final step is giving.

  • Jeffrey2's avatar
    Jeffrey2
    Icon for Helper I rankHelper I
    4 years ago

    Same error message

    • Jeffrey2's avatar
      Jeffrey2
      Icon for Helper I rankHelper I
      4 years ago

      Let me add this... I already have a step where it is supposed to remove any IDs that DO NOT begin with two letters. Even after that step, the IDs similar to 12345 are appearing.