Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

InfoPath 2010 Document Information Panel - Error: "This file cannot be saved because some properties are missing or invalid"

Posted on 2011-03-17
2
Medium Priority
?
1,090 Views
Last Modified: 2012-05-11
Afternoon all,

I’m building a customised Document Information Panel for a custom content type within my SharePoint 2010 site and am generating an error upon trying to save the document using it.  The DIP is being designed to allow for cascading drop downs, or filtered look ups, in that the selection of one drop down box will determine the contents of the next.  A screenshot of the DIP in word is below

 Custom DIP Screenshot
When I try to save a document into SharePoint it, I get the following error message.  

 Custom DIP Error Message
My steps to this point are: -

1.      Create a list that contains my data
2.      Create 2 site columns look up into different columns for this list.  These columns are metadata level 1, and metadata level 2.  The third column in the DIP is linked to a taxonomy list in the managed metadata service
3.      I create my content type, upload my template and generate the DIP XSN from the Document Information Panel Settings
4.      On the first drop down box (via the Drop Down List Box Properties,  I’m making the following changes
   a. Change Value to my first look up column
   b.      Change Display name to my first look up column

 Drop Down box Properties
5.      On the first second down box (via the Drop Down List Box Properties,  I’m making the following changes
   a.      Change Value to my second look up column
   b.      Change Display second to my first look up column
   c.      Applying a filter, on the XPath, so that entries are only shown if the value for drop down box 1 (via the main data source) matches the value in the second data source (secondary data source).  A screenshot of this is below: -

 InfoPath filter properties
7.      Testing this works, I deploy it to my content type just fine.  A user can open the document just fine, the selections work but when they try and save, I generate the error message in the first screenshot.  My DIP look-up columns show a red dotted boundary, indicating an invalid property.

Fixes tried so far
Changing the Value in the Drop-Down List Properties back to ID, as I suspect that this needs to be passed back.  Doing so, breaks my filter, and I can’t think of another filter to apply.  I’m assuming that by applying a filter on the "Title" field only, the ID Field values aren’t being retrieved in the query for the dropdown entries, and hence not assigned to the Lookup in SharePoint.  I’m not sure how to fix this yet.

I have found the link in the forums to this thread http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Infopath/Q_23553083.html and noted the fix, however, this user had a different filter from myself and I've been upable to adapt this to my solution.

I've set this as a 500 point question due to the nature and scacrity of viable answers when researching this.

All/any pointers are appreciated.
0
Comment
Question by:backpackerd00d
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Accepted Solution

by:
backpackerd00d earned 0 total points
ID: 35322319
I managed to sort this one by adding a second data binding to the second drop down box and filtering on this.  It changed the @ID to "Title" but changing back the reference to ID, ensured the cascading drop down worked.
0
 

Author Closing Comment

by:backpackerd00d
ID: 35322324
2 weeks of working this out meant I finally hit the solution.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

715 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