We found the similar error today on Search. 'proc_MSS_GetQueryParameterSpecification
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'proc_MSS_GetQueryParameterSpecification', database xxx_Intranet_Search_Service_DB', schema '...
I can see following issues in the code:
In the line
var listEnumerator = lists.getEnumerator();
the variable 'lists' is undefined, it is not assigned/declared in your code.
where lists is a global variable
var lstObject = lists.getByTitle("...
You can use below code to get all list titles from SharePoint site using JSOM:
var clientContext = new SP.ClientContext.get_current();
var web = clientContext.get_web();
var lists = web.get_lists();
I do a test follow the document.It works well.
Yes, ticks function can be difficult to use sometimes. Instead of appending timestamp to date field on your own, you can try using:
Or before using the date field directly in ticks function, you can format it using convert date time action in Power Automate.
Read below articles for more information:
Compare dates using ...
I think there is an issue with single line of text fields in your code. Try using below code for Comments and Submitter Name:
var comments, submitterName;
comments = $('.request-text-area').val();
submitterName = $('.submitter-name').val();
addItemToSPList(specialtiesArr, regionsArr, comments, submitterName):
You could find if there is a <SharePoint:StyleBlock runat="server"></SharePoint:StyleBlock>
in your new form.You could add css code in it.
My test code:
The reason for the problem is that SharePoint will escape special characters, causing '_ ' to ' x005f '.The title will not affect the excution,but the itemType get by the function GetItemTypeForListName is wrong.
My test code works well:
Thanks all guys who helped me to solve my issue.
I solved issue by removing quotes from item and previously i was using a variable to store column data and name but now i am directly writing inside ajax.
That's now working successfully, don't know why its not working when i use variable.
For further clarification, i added screenshot also.
While you are generating the type using : GetItemTypeForListName in you machine, You should not use like this pattern. You can get the type from the rest end point. The list name with special character like _ will not have the type with proper pattern. Check the type of this list.
As per my understanding you are getting this issue because you are passing wrong type inside __metadata.
Before using the main REST call check the ListItemEntityTypeFullName of your own list and pass it in __metadata property.
You can get this property by hitting below URL in browser tab:
Is this display name of the list?
Try with %5F var listName = "Project%5FList";
/lists/getbytitle('" + encodeURIComponent(listName) + "')
The error message Method not found: '!!0 System.Array.Empty()' is related to .NET Framework 4.6 not installed correctly, please refer the similiar question here:
Method not found: '!!0 System.Array.Empty()'
You can download and install .NET Framework 4.6 here:
Microsoft .NET Framework 4.6.2 (Offline Installer)
If your column name is Folder/UniqueId,the column internal name is Folder_x002f_UniqueId.
If the column is a multi text column,the value may not be the ‘testabc’,you could use “/_api/web/lists/getbytitle('listname')/items” to get all column value.
And the a multi text column can not use filter in rest, you need to call caml to filter .