Infopath and Calculated columbs in Sharepoint

Posted on 2009-04-30
Last Modified: 2012-05-07

I've created a data connection in Infopath to a Sharepoint List. Problem - I've got a calculated columb in the Sharepoint list which I want to show in my Infopath control, but it doesn't appear in the available fields.

I thought it might be because I hid the columb in my default SharePoint view so I added it back in, still not displaying as an available field.

Is this a known limitation; if so, does anyone know of an alternaive meathod of displaying a calculated SharePoint columbs contents in an Infopath control? Thanks in advance!
Question by:VantaBods
    LVL 25

    Accepted Solution

    One way would be to use a workflow to set a seperate column to the same value as the calculated column every time it changes. You should then be able to select the value of the standard column in the form.
    LVL 6

    Expert Comment

    Unfortunately, calculated columns in Sharepoint are not stored values, so they do not populate as a drop down in InfoPath forms.
    LVL 25

    Assisted Solution

    That's why setting another column to the same value by way of a workflow should allow you to select the column from within InfoPath.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
    Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now