none
External Content Type Fields available for formula column in calculated field RRS feed

  • Question

  • I have an external content type with 5 fields. One is type System.int the rest are System.string. I have a list using the external content type. In that list I also have a calculated field using one of the External Content fields (System.String) in the formula. I am trying to recreate this in another list but the only External Content type field I can get to show up in the calculated field formula is the System.Int field. Can't get the same System.String field I am using in one calculated field to show in the new one.
    Tuesday, April 25, 2017 10:06 PM

All replies

  • Hi,

    Are you using the same external content types?

    If not, please compare the differences between the fields inside each external content type.

    And you also test with a new external content type with same fields as the first one to see how it works.

    Best Regards,

    Victoria

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, April 27, 2017 12:23 PM
    Moderator
  • Hi,

    How is everything going?

    Is there any update about this issue?

    Best Regards,

    Victoria


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Wednesday, May 3, 2017 1:37 AM
    Moderator