[Last Call] Learn how to a build a cloud-first strategyRegister Now


Infopath and Calculated columbs in Sharepoint

Posted on 2009-04-30
Medium Priority
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
  • 2
LVL 25

Accepted Solution

Robbie_Leggett earned 2000 total points
ID: 24278857
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.

Expert Comment

ID: 24361749
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

Robbie_Leggett earned 2000 total points
ID: 24363676
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month18 days, 1 hour left to enroll

830 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