Answered

Lookup field not auto-populating via query string on Power Pages form (works on another form)

(1) Share

Report

Posted on by CU03042123-0

Hi everyone,

I'm facing an issue with a lookup field not auto-populating in a Power Pages form, even though the same setup works on another form.

I want to auto-populate a lookup field in a form (let's call it Certifications) using a query string that passes the ID of a record from another table (let's call it MainTable):

This works perfectly on another form (TraceabilityForm), but not on Certifications, even though both forms share the same logic and lookup setup.

✅ Setup:

Certifications table has a lookup column to MainTable (N:1 relationship).
In the form configuration:
- "Set table reference on save" is enabled.
- Query string is selected as input.
- Parameter name is id.
- "Query string is a primary key" is checked.
- The correct logical name of the lookup field is selected.
The record ID passed in the URL exists and is accessible anonymously.

🧪 What I’ve tested:

Replicated the lookup field multiple times with the same result.
Double-checked permissions and form mode (Insert).
Compared against the working form where this setup is functional.
In the Certifications form, the lookup field still shows a search box instead of auto-filling.

❓ What I need:

Why would the lookup field auto-populate on one form but not another, despite the same setup?

Could this be due to:

Metadata caching?
View setup?
Form/field permissions?

🔗 Example :

✅ Working:
https://[mysite].powerappsportals.com/TraceabilityForm/?id=VALID_GUID
❌ Not working:
https://[mysite].powerappsportals.com/Certifications/?id=VALID_GUID

Any help would be appreciated 🙏
Happy to share further details if needed.

Thanks in advance!

Categories:

General

Capture d’écran ...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

All responses (2)

Answers (1)

CU03042123-0 4 on at

Like (1)

Report
Lookup field not auto-populating via query string on Power Pages form (works on another form)

Hi @Michael E. Gernaey,

Thanks a lot for your guidance!
You were spot on regarding the use of JavaScript to handle the URL parameter.

Indeed, I ended up implementing a custom button with a dedicated script to capture the id from the URL and control the form submission and redirection manually. Without this, as you correctly pointed out, simply having the id in the URL wasn't enough to populate the lookup field as expected.

Here’s roughly the approach I took:

I added a manual button under the form.

On click, the script captures the id from the URL.

I force the form submission via JavaScript.

After a short delay to ensure the data is saved, I redirect to the next page while keeping the original id in the URL to maintain the correct relationship.

It works perfectly now 🎉

Thank you again for your insightful advice! I've marked the post as resolved and gave it a like 😊

Cheers!
Verified answer

Michael E. Gernaey 38,794 Super User 2025 Season 1 on at

Like (1)

Report

Lookup field not auto-populating via query string on Power Pages form (works on another form)

Hi @CU03042123-0

What does the javascript look like that you are using to do the save? Did you remember to add that to the other page as well? Just having that at the end of the Url won't make it do what you want. You have to capture that ID value and then populate the lookup with it.

I am guessing you should have some javascript, which is there for the one that works but not there for the one that doesn't.

That or its there but there is something in it that makes it not work with the second one.

If this solves your problem, Please mark as Resolved and maybe a like :-)

Cheers let me know how it goes

Community site session details