You’re offline. This is a read only version of the page.
Announcements
4
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 !
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.
Share
Report
All responses (
Answers (
$(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!
