cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaraRao
Frequent Visitor

Autopopulate fields in form of portal

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 !

1 REPLY 1
hardikv
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.

$(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!

 

 

 

Helpful resources

Announcements
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)