Autopopulate fields in form of portal

[SaraRao]

Hi, 

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 !

[hardikv]

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.

$(document).ready(function(){
        $("#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: 

https://docs.microsoft.com/en-us/power-apps/maker/portals/web-api-overview

https://docs.microsoft.com/en-us/power-apps/maker/portals/read-operations

You can retrieve data using below code:

function getResponseData() {
    var response = null;
    try {
        $.ajax({
            type: "GET",
            url: "https://contoso.powerappsportals.com/_api/accounts(e0e11ba8-92f6-eb11-94ef-000d3a5aa607)",
            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!