Infopath and Calculated columbs in Sharepoint

Hi,

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!
VantaBodsAsked:
Who is Participating?
 
Robbie_LeggettConnect With a Mentor Commented:
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.
 
:-)
0
 
ramuar1981Commented:
Unfortunately, calculated columns in Sharepoint are not stored values, so they do not populate as a drop down in InfoPath forms.
0
 
Robbie_LeggettConnect With a Mentor Commented:
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.
 
:-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.