none
SharePoint list InfoPath form not showing updated column information

    Question

  • I am working with a SharePoint site where I am using custom site columns to update multiple lists. When I update the column information in Site Columns the modifications push to the lists and they update as expected, however, their InfoPath forms do not and they still reflect old column information in the available Fields. Typically the form notifies upon opening that the list has been updated, and then updates the available form fields to match. Versioning is set to automatically update the template and to automatically upgrade existing forms. Does anyone have any ideas as to why the form would not pull the updated list columns? Thanks for any guidance!
    lundi 18 août 2014 15:58

Réponses

  • Hi,

    List\library column in InfoPath is stored differently from site column. InfoPath stores the list of Fields that are published to SharePoint document libraries in a local manifest along with the columns which these fields are associated to. This is accomplished by referencing the column ID in SharePoint (a unique GUID value) with the InfoPath Field. While the site column ID will not change.

    You could refer the link below for the scenario related to this difference:

    http://support.microsoft.com/kb/2554288/en-us

    Regards,


    Rebecca Tu
    TechNet Community Support

    • Marqué comme réponse Rebecca Tu mardi 9 septembre 2014 07:24
    mardi 19 août 2014 09:26
  • I'm operating in SharePoint 2010, and the InfoPath forms were originally created by implementing customized forms directly from SharePoint.  Reading the prior posts, and gathering that there was a possibility that InfoPath interprets/treats Site Columns differently than list columns, I had a hunch and created a dummy single line of text column on the list in question.  I then opened the form and voila, now it recognizes not only the dummy column, but it also pulled all of the other modified Site Columns from the SharePoint site.  Any ideas why it would exhibit this behavior?  This certainly isn't a solution, but it was a workaround that worked for me.
    • Marqué comme réponse Rebecca Tu mardi 9 septembre 2014 07:24
    jeudi 4 septembre 2014 15:02

Toutes les réponses

  • Hi,

    List\library column in InfoPath is stored differently from site column. InfoPath stores the list of Fields that are published to SharePoint document libraries in a local manifest along with the columns which these fields are associated to. This is accomplished by referencing the column ID in SharePoint (a unique GUID value) with the InfoPath Field. While the site column ID will not change.

    You could refer the link below for the scenario related to this difference:

    http://support.microsoft.com/kb/2554288/en-us

    Regards,


    Rebecca Tu
    TechNet Community Support

    • Marqué comme réponse Rebecca Tu mardi 9 septembre 2014 07:24
    mardi 19 août 2014 09:26
  • I read through that and I'm not fully understanding its application to my situation.  I understand how InfoPath recreates columns, but in my case the columns are created/updated on the list first (through updates in Site Columns), and then InfoPath is opened.  InfoPath should recognize the updates to the columns, but it isn't.  It doesn't "know" that the columns have changed.  What am I missing?
    jeudi 21 août 2014 16:17
  • Hi,

    I am trying to involve someone familiar with this topic to further look at this issue.

    Thank you for your understanding and support.

    Regards,

    Forum Support

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


    Rebecca Tu
    TechNet Community Support

    vendredi 29 août 2014 01:03
  • Hi,

    According to your description, can you share more steps of creating your infopath form,or add some screenshots about your infopath form? you created your infopathform by sharepoint designer,right? Here is an article about this, it may help you.

    http://www.appvity.com/blogs/post/2013/06/16/How-to-configure-and-publish-InfoPath-to-SharePoint-2013.aspx

    Paul Shui
    Microsoft Online Community Support

    Please remember to click “Mark as Answer?on the post that helps you, and to click “Unmark as Answer?if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread


    lundi 1 septembre 2014 10:55
  • Hi,

    How things are going on?

    Paul Shui
    Microsoft Online Community Support

    Please remember to click “Mark as Answer?on the post that helps you, and to click “Unmark as Answer?if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread

    mercredi 3 septembre 2014 06:15
  • I'm operating in SharePoint 2010, and the InfoPath forms were originally created by implementing customized forms directly from SharePoint.  Reading the prior posts, and gathering that there was a possibility that InfoPath interprets/treats Site Columns differently than list columns, I had a hunch and created a dummy single line of text column on the list in question.  I then opened the form and voila, now it recognizes not only the dummy column, but it also pulled all of the other modified Site Columns from the SharePoint site.  Any ideas why it would exhibit this behavior?  This certainly isn't a solution, but it was a workaround that worked for me.
    • Marqué comme réponse Rebecca Tu mardi 9 septembre 2014 07:24
    jeudi 4 septembre 2014 15:02
  • Hi,RevWorker

    It is so good that you find the workaround to fix the issue, and if you want to find the solution about this case, I suggest that you can open a case to microsoft, thank you!

    Paul Shui
    Microsoft Online Community Support

    Please remember to click “Mark as Answer?on the post that helps you, and to click “Unmark as Answer?if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread

    mercredi 10 septembre 2014 07:27
  • See if this helps...

    In InfoPath after you have created the columns and added any rules (optional), save the form and click File.  Click Form Options, Property Promotion, Add, Select Field, Type correct Column name and apply. Save and Re-Publish.  Enter you SharePoint Site and modify view. 

    Hope that helps

    jeudi 28 juillet 2016 19:33
  • I tried the same and worked for same issue where updated column name was not getting updated in Infopath.

    After creating dummy column, InfoPath opened with correct column name, then I had to publish it to save changes to Infopath. Then deleted the Dummy column I created, re-opened form in InfoPath, and published again.

    If Dummy column is not an issue, can be left alone, and if same issue occurs, it can be deleted. Deletion of a column should also force InfoPath to prompt for popup that asks if you want to accept the changes.

    lundi 19 juin 2017 16:29
  • Something painfully simple can help with this issue. Be sure to choose PLAIN Text for the text options when creating the multiple line text column. Choosing Enhanced or Rich Text will cause issues when using the append feature with an info path form.

    Stowner

    vendredi 8 juin 2018 18:31