Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Autopopulate fields in form of portal


Is it possible to automatically populate fields based on data selected in the other fields in the Power Portal Forms ?
Eg: I have table ProductID, Name and Price. When the user selects ProductID, Name and Price should be filled in automatically.

Thanks in advance !

Solution Sage
Solution Sage

Hi @SaraRao 


Yes, it is possible. You have to trigger onchange event of ProductId field. When user select/change the ProductId field, you can retrieve data of Name and Price fields.

        $("#new_logicalname").change(function () {
        // Get value of your trigger field
        let currentVal = $("#new_logicalname").val();
	//Retrieve data using WebApi based on your requirements


Please refer this links:


You can retrieve data using below code:

function getResponseData() {
    var response = null;
    try {
            type: "GET",
            url: "",
            dataType: "json",
            cache: false,
        }).done(function(json) {
            response = json;
    } catch (e) {
        console.log("getResponse :: " + e.message);
    return response;


If you like this post, give a Thumbs up. Where it solved your query, Mark as a Solution so it can help other people!




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Users online (2,814)