2013 – How to listen for an Infopath submit dialog in Sharepoint using Javascript

I know I shouldn’t be using Infopath. I don’t have a choice. We’re not in a new Sharepoint environment yet and we don’t have PowerApps yet. It will happen and we’ll have to redo all of this but we need Infopath in the meantime.

I created an infopath form attached to a form library because the user wanted to be able to add multiple attachments and that wasn’t possible with the list form. We needed to add custom scripting behavior to the form submit page but we couldn’t edit the existing form submit page that Sharepoint creates by default for the library so we created a new page and added the form and a script editor webpart for the Javascript.

My user wants the form to go to the list when she pushes the save button. Its set to close in infopath but currently it does nothing, the form just sits there. I have some say over what is in the query string and I heard that if you put Source= that the submit button will take you to the source URL when the submit is done but I’m not sure that’s going to work for my page. I haven’t tested it yet.

What I need to know is, using Javascript, how do I listen for positive confirmation that an infopath form successfully submitted to a Sharepoint list? In case I need to write a script to do this.

Please I know this is all an ugly hack but its what I have to work with. My tools are Javascript, Sharepoint (and only the front end) and Infopath.

SharePoint Designer 2013 Workflow HTTP Web Service on POST: Error – The given key was not present in the dictionary

Thank you for reading this. This is a bit long, but I’m trying to be as detailed as possible. Any help would be greatly appreciated. If more info is needed, please let me know. As info, I am not a (JavaScript) developer. I’ve been tasked to do as many things as possible OOTB.

Environment: SharePoint Online and SharePoint Designer 2013 (for workflows).

Scenario: Have a Team Site and a Subsite to it. When an item is added to a Custom List in the Subsite, the workflow is to find the matching task in the Task List on the Parent Site and mark the Task Status as “Completed”. (A variable is created in the workflow to match the item added to the list with the task.)

Success: Using the HTTP Web Service action to GET Task items via the Workflow. Evidenced by logging the response in a custom list using Create Item in List workflow action.

Issue: Using POST to add or update a Task to the task list. Continue to get the error {“error”:{“code”:”-1, System.Collections.Generic.KeyNotFoundException”,”message”:{“lang”:”en-US”,”value”:”The given key was not present in the dictionary.”}}}

Pre-conditions: Because we were going between site and subsite, we followed the articles to create elevated workflow permissions for use of the App Step. Did this on both the site and subsite. https://msdn.microsoft.com/en-us/library/office/jj822159.aspx, http://www.fabiangwilliams.com/2014/06/19/gotcha-on-sharepoint-designer-workflows-in-app-step/

Because this error seems to sometimes be illusive, decided to create the workflow on lists within the same Team Site to remove any possibility of authorization issue. Therefore the example shown below is not using APP Steps.

Trouble-shooting: Used Fiddler with Chrome to walk through and did not receive any errors. https://cann0nf0dder.wordpress.com/2016/09/12/getting-fiddler-to-work-with-sharepoint-online/. Viewed many, many articles also.

Workflow:

  1. Hard-coded a Variable = TempMatchString to match with a value in the Task List to bring back specific Task(s). Ignore first two lines of the workflow – will be used once the issue is resolved.

enter image description here

  1. Get Matching Task(s)

    • Build GET_RequestHeader Dictionary.
      Accept = application/json;odata=verbose as String and
      Content-Type = application/json;odata=verbose as String

    • Perform the GET HTTP Web Service request with URL: https://mycompany.sharepoint.com/HumanResourcesTS/_api/web/lists/getByTitle('ProgressReportTasks')/Items?$filter=(Title eq (%Variable:TempMatchString%)

    • Create Item in the SPListGETContent list to view the response.

    • Store the array returned in Variable “ListDataSet”. Note: I am using Get valueinstead of d/results. If I do the GET Call from the subsite I get the JSON returned with d/results as seen in most all articles online, but value when used on the parent site. I am not sure why this differs.

    • Count to number of items returned.
      enter image description here
  2. Get FormDigestValue

Read several articles stating need to set the X-RequestDigest to the FormDigestValue to POST.

Thank you!!

Sharepoint 2013 Version History Export

I have a follow up question regarding this solution:
Exporting item list version history

I used this method and it worked on a very small list, maybe 10 items.

I tried the same method on a large list, 4000 items and I get and error:

Error
Cannot complete this action.

Please try again.

Troubleshoot issues with Microsoft SharePoint Foundation.

I don’t have powershell access so I’m looking for any other suggested solutions. Perhaps using MS Access? or simply figuring out why the solution above works for small lists and not large lists, even when the view is limited to only 100 items.

Thanks.

EDIT 1:
Upon further investigation, it appears to be a limit based on the number of columns in the SharePoint list. Not the columns in the view, but total columns in the list. I’ve tried the method on a list with 1000+ items but only 4 columns, this worked without any issue. My understanding is that the XML Version history option only works on lists with fewer than 30 columns. I also believe this includes the default columns that are pre-populated by SharePoint depending on the type of list you created.

I’m going to test this in about 10 days when I am able to delete some columns from the list I am working with. If it works, I will report back.

2013 – SharePoint Image Map Tooltips

In order to show a tooltip, you can use the title HTML attribute attribute

For example:

<area title="Texas" href="...">
...

This is another example:

<map name="workmap">
  <area shape="rect" coords="34,44,270,350" alt="Computer" href="computer.htm" title="computer!">
  <area shape="rect" coords="290,172,333,250" alt="Phone" href="phone.htm" title="phone!">
  <area shape="circle" coords="337,300,44" alt="Cup of coffee" href="coffee.htm"  title="coffee!">
</map>

enter image description here

2013 – SharePoint Custom List – Column Tooltip to Transparent

I hope someone can help.

I am currently using the following snippet to remove the automated tooltip from ‘ms-input’ and ‘ms-long ms-spellcheck-true’ custom list column input fields:

    $(document).ready(function() {
$("tr td input(class='ms-input')").attr("title","");
$("tr td input(class='ms-long ms-spellcheck-true')").attr("title","");
});

I would also like to remove the automated tooltip from ‘ms-RadioText’ fields (choice columns) but I can’t do it by clearing the title because the title is being used to hide/show child questions depending on the choice the user makes on the parent question.

Is there any way that I can use CSS to make the tooltip on the ‘ms-RadioText’ fields transparent? So the title can still be used to drive the dynamism, but the tooltip itself becomes invisible?

My coding skills are quite limited so apologies in advance if I’m asking a question that is impossible to solve!

Thanks

sharepoint server – SP 2013 Configuration Wizard stuck at step 9 / 10 with SPUpgradeException at SPIisWebSiteWssSequence

I am trying since multiple days installing SharePoint 2013 Foundation farm (no standalone development environment), but the Configuration Wizard stucks doggedly at step 9 of 10. Now I am at the end of my wisdom and my nerves.

Please help me with a solution for this issue. Thank you very much in advance.

  • Windows 2008 R2 Enterprise with IIS version 7.0 (is this IIS version correct?)
  • SQL Server Express 2008 R2 ADV (ADV = Advanced Services)
  • SharePoint 2013 Foundation with Service Pack 1 and really all possible updates
  • My virus protector is off
  • My firewall is off

The Error (in German)

Wizard error message at step 9 of 10

in brief:

Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 4.0.3.0 of
Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed

The log file says:

Task upgrade has failed with an unknown exception Exception:
Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 4.0.3.0 of
Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed. —>
System.NullReferenceException: Der Objektverweis wurde nicht auf eine
Objektinstanz festgelegt. bei
Microsoft.SharePoint.Administration.SPAspSiteMapFile.MergeAspSiteMapFiles(XmlDocument
xmldocSiteMap, String strSrcFilePath, String strMergeFilePattern)
bei Microsoft.SharePoint.Administration.SPAspSiteMapFile.Copy(String
strSrcDir, String strSrcDirPrevious, String strSrcLeaf, String
strDestDir, Boolean bMergeMaps, Boolean bBackupExistingFile) bei
Microsoft.SharePoint.Administration.SPWebApplication.CopyAppDomainDirectories(DirectoryInfo
vrPath, OverwriteSetting overwrite) bei
Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() — Ende
der internen Ausnahmestapelüberwachung —

I tried:

  • Deleting cache files and editing cache.ini
  • Starting configuration wizard from command line:
  • stsadm -o execadmsvcjobs
  • PSConfig.exe -cmd upgrade -inplace b2b -force
  • Removing SharePoint and SQL Server and re-install them again

and much more from a hundred of Google findings

BUT NOTHING WORKS!
Please help me with a solution for this issue. Thank you very much in advance.