{"id":459,"date":"2016-02-18T12:25:21","date_gmt":"2016-02-18T17:25:21","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=459"},"modified":"2016-02-18T12:25:21","modified_gmt":"2016-02-18T17:25:21","slug":"submitting-datetime-with-infopath-to-web-services","status":"publish","type":"post","link":"https:\/\/markwheeler.com\/?p=459","title":{"rendered":"Submitting Date\/Time with InfoPath to Web Services"},"content":{"rendered":"

I created an Infopath for users to request teleconference numbers.
\nI have two lists; Schedule and Conference List.<\/p>\n

Schedule list had these columns: Title, Start Date, End Date, Attendees, Status, Assigned.
\nConference List had these columns; Source (which will be set to Title above), Title, Phone Number, Start Date, End Date<\/p>\n

Users get a standard request form which pulls and updates from the Schedule list.
\n\"ConReq\"<\/a><\/p>\n

Admin\/Operators receive workflow email that a request was placed and get an expanded form. <\/p>\n

\"ConOpView\"<\/a><\/p>\n

The magic is on the Assign button on the Operator section.
\nRules are set to submit 5 values to the Conference List using a Web Service.<\/p>\n

There are many good blogs that detail this process.
\nReference with Screenshots: http:\/\/jaliyaudagedara.blogspot.com\/2011\/03\/submitting-data-to-sharepoint-2010-list.html<\/a><\/p>\n

The first step is to create an “Add List Items.xml.” This is the data to be inserted into the Conference List:<\/p>\n

\n\n\n    \n        <\/Field>\n        <\/Field>\n        <\/Field>\n        <\/Field>\n        <\/Field>\n    <\/Method>\n<\/Batch>\n<\/pre>\n
The easy part is submitting text fields. Date\/Time fields will fail due to invalid type errors. A common problem I’ve seen reported is that you won’t get an error on submit and no data will be posted to your list.<\/p>\n
This the workaround for Date\/Time.
\nCreate a textbox on your form; you can hide this later.
\nSet the value to your original form’s time value with the following formula.<\/p>\n
\nconcat(YourTimeField,\"Z\")\n<\/pre>\n
\"TimeField\"<\/a><\/p>\n
This is the important piece. The UpdateListItems call needs that “Z” appended to the Time portion.
\nYour modified time output will look like YYYY-MM-DDTHH:MM:00Z.<\/p>\n
When creating your Submit to Web Service rule; add the Submit portion first. In my example the rule is “AssignNumber”.
\nGo to Publish and Export Source Files. You will need to edit the manifest.xsf. Find your submit rule by name and paste the following BEFORE the submitAction.<\/p>\n
\n<\/xsf:assignmentAction>\n<\/xsf:assignmentAction>\n<\/xsf:assignmentAction>\n<\/xsf:assignmentAction>\n<\/xsf:assignmentAction>\n<\/pre>\n
This allows you to set your Add Item CAML to push the correct values to the Web Service Submit. <\/p>\n
From InfoPath Designer; open the manifest.xsf file. Your rules may look like this.<\/p>\n
\"ConAsnRules\"<\/a><\/p>\n
You can edit the value of these rules as necessary. Note that I point my Start and End Date columns to the concat fields I created earlier.<\/p>\n","protected":false},"excerpt":{"rendered":"
I created an Infopath for users to request teleconference numbers. I have two lists; Schedule and Conference List. Schedule list had these columns: Title, Start Date, End Date, Attendees, Status, Assigned. Conference List had these columns; Source (which will be set to Title above), Title, Phone Number, Start Date, End […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[10,11],"tags":[58,99],"class_list":["post-459","post","type-post","status-publish","format-standard","hentry","category-sharepoint","category-software","tag-infopath","tag-sharepoint-2010"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=459"}],"version-history":[{"count":0,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/459\/revisions"}],"wp:attachment":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}