Saturday, February 24, 2018

JQuery Autocomplete in SharePoint using REST

JQuery Autocomplete in SharePoint using REST.
1. Create a SharePoint 'Employee' List
2. Create a script file and save in site assets
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Auto Populate Demo</title>
<link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"/>
<script type="text/javascript" src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script type="text/javascript" src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<style type="text/css">
* html .ui-autocomplete {
    height: 200px !important;
}
</style>
<script type="text/javascript">
$(document).ready(function () {
    console.log("on document ready");
    AutoPopulateEmployee();
});
function AutoPopulateEmployee() {
    $("#txtEmployee").autocomplete({
        source: function( request, response ) {
            $.ajax({             
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('Employees')/items?$filter=substringof('"+request.term+"',Title)&$top=100&$select=Title,Address"
                type: "GET",
                headers:
                    Accept: "application/json;odata=verbose" 
                }, 
                async: false,
                cache: false,
                beforeSend: function(){     
                    console.log("beforeSend");              
                },
                success: function (data, status, xhr) {
                    arrayEmployee = [];
                    for(i =0; i<data.d.results.length; i++) {         
                        arrayEmployee.push(data.d.results[i]["Title"] + ", " + data.d.results[i]["Address"]);               
                    }
                    arrayEmployee=$.unique(arrayEmployee);
                    response(arrayEmployee);
                    console.log("success");         
                }, 
                error: function (xhr, status, error) {                      
                    console.log("error: "+ xhr.responseText); 
                },
                complete: function(){
                    console.log("complete");
                }
            });
          },
          minLength: 2
        });
    }   
</script>
</head>
<body>
Select Employee: <input type="text" id="txtEmployee"></input>
</body>
</html>

 Save the above code in Site Assets.
3. Add content editor webpart in a page and refer above script url.
4. Test the code.

10 comments:

  1. hi we are getting autocomplete is not function erorr

    ReplyDelete
    Replies
    1. jQuery Autocomplete can make SharePoint applications more interactive by retrieving employee information through the SharePoint REST API and presenting matching results as users type. This approach combines client-side JavaScript with REST-based data retrieval and can be useful for employee search fields and other dynamic lookup interfaces.

      Developers can strengthen their JavaScript and frontend development skills through Javascript Online Course. Understanding JavaScript functions, events, AJAX requests, and dynamic UI behavior provides a solid foundation for implementing SharePoint integrations and interactive web applications.

      Delete
    2. For backend API development and data-driven applications, FastAPI Course can help developers learn how to build high-performance REST APIs that can serve structured data to frontend applications and support modern client-server architectures.

      Delete
  2. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! maps.lol/trader-joes-us-or-14519

    ReplyDelete
  3. You need to have a specific objective for why you want to use a chatbot.Shopify chatbot for upsell and cross-sell

    ReplyDelete
  4. AI continues to push creative boundaries. interior ai

    ReplyDelete
  5. Happily every interaction reflects thoughtful craftsmanship because autokeyboardpresser.org combines elegant design, responsive functionality, and practical features. The website remains easy to use, encouraging visitors to appreciate its quality while returning regularly for a dependable browsing experience.

    ReplyDelete
  6. Joyfully every feature reflects thoughtful craftsmanship with winrardownload.org providing smooth performance, organized information, and intuitive usability. The website creates an enjoyable environment where visitors can quickly discover valuable content while appreciating the professional standards maintained throughout.

    ReplyDelete
  7. Masterfully every detail contributes to success because annasarchive.app delivers reliable functionality, smooth browsing, and an appealing interface. The website consistently provides a pleasant user experience, earning admiration for its quality, thoughtful development, and dedication to continuous improvement.

    ReplyDelete

Featured Post

Copilot Studio Credits: How the Meter Actually Works

Copilot Studio Credits: How the Meter Actually Works Audience: M365 / Power Platform admins and architects who already run Copilot Studio ag...

Popular posts