Auto populate a basic form lookup field in Power Pages using JavaScript

In this blog post we’ll take a look at how you can pre populate a lookup field on a basic form in Power Pages using some JavaScript. We’ll assume that we’ve already got values for the following pieces of data that we’ll need about… READ MORE [https://lewisdoes.dev/blog/auto-populate-a-basic-form
hands typing on a laptop keyboard
Photo by cottonbro studio on Pexels.com
In: Low Code Lewis Content 🚀

In this blog post we’ll take a look at how you can pre populate a lookup field on a basic form in Power Pages using some JavaScript. We’ll assume that we’ve already got values for the following pieces of data that we’ll need about the lookup record…

  • Value for the primary name field on the lookup tables record that we want to populate
  • GUID for the record
  • Logical table name for the lookup table

Opening the JavaScript file to create the function

In Power Pages, first we need to go to the page where we’ll apply some JavaScript, then we can open Visual Studio Code to apply our JavaScript by clicking ‘Edit code’

Where now?

So how do we now get to the write file to pop our JavaScript into? Lets select the one in our workspace which has a JS at the start of it signalling to us that the file is written in JavaScript

The function

Now we can start to write our function… Lets use the following syntax and then we’ll focus on replacing some elements.

$(document).ready(function AutoPopulateLookup(){
    $("#lcl_product_name").attr("value",ProductName);
    $("#lcl_product").attr("value", ProductId);
    $("#lcl_product_entityname").attr("value","lcl_product");
});

In the above example I’m populating a lookup to my product table with a record retrieved through some data held in variables ProductName and ProductId, where ProductName holds the primary name value for the product and ProductId holds the GUID for the record.

We need to also replace the following values though…

  • lcl_product_name
  • lcl_product
  • lcl_product_entityname

To find the relevant values we need to use here we need to inspect our field in the preview mode of our site to get a few things.

Once you’re in preview mode, right click anywhere on the page and select ‘Inspect’.

Now we need to select the following tool to hover over an element and select it which will then select it in our elements pane.

Now select in the field input for your lookup field. The control will be selected in the elements pane and you’ll see three parts of our control. Now we need to use the id of each of these to replace our values above in matching order between the list and what we see in the elements.

Here is the selected input group where I’m coping the id from each element of the group. Replace my references with the ones you have in each id element on your selected control.

Now ensure you’ve replaced the variables I used for the values corresponding to each attribute, and save your file by using CTRL+S or CMD+S on MacOS.

Sync Configuration and Test

Very simply now sync the configuration and ensure things are working… they should be! 🙂

Written by
Lewis Baybutt
Microsoft Business Applications MVP • Power Platform Consultant • Blogger • Community Contributor • #CommunityRocks • #SharingIsCaring
Comments
Great! You’ve successfully signed up.
Welcome back! You've successfully signed in.
You've successfully subscribed to LewisDoesDev.
Your link has expired.
Success! Check your email for magic link to sign-in.
Success! Your billing info has been updated.
Your billing was not updated.