Unanswered

Pre-populate a Power Pages form using existing data

(0) Share

Report

Posted on by Community Power Pla...

Hi there,

I have a simple Power Pages website that contains a single form. The form simply inserts "Access Log" records into a table.

I would like to pre-populate a subset of fields on this form (Full Name, Vehicle Registration, Certificate Number, etc) by executing a query. This query will check for previous records created by the user and use the last record added by the user to populate the form. This should allow the user's information to be "remembered" by the application, so they don't have to fill out the entire form each time. This is only for signed-in users.

Is this possible in Power Pages? If so, how can it be achieved? I have tried using Basic Form Metadata and also fluid templates to try adding the functionality without much luck.

Thanks,
Jason.

Categories:

Design & build

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report
Several ways it could be done
Custom Web Template with Liquid to run a FetchXML query, load the results into JavaScript variable(s) or Object/Array etc and then when the Form loads populate the fields from the JavaScript, OR
Use the Portals Web Api functionality to populate the fields, OR
Depending on what you are doing could combine 1 & 2
If the user only needs to view the data, then could make use of a Quick ~~Create~~ View form embedded on your Portal Form.
Create a record in Dataverse to hold latest details (or modify the Contact form), only have 1 record per Contact (user) - linked to the Contact via lookup field, when someone updates it write the update to another table (so you have a running history). Use a Table permission with a Scope of Contact on the latest details table.
Variation of this would be to create a Lookup in the Contact to the new latest details Table, and then create a Basic Form and set its record source to Record Associated to Current Portal User and then select the relationship that is the Lookup.

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

these links might help:

Portals read operations using the Web API - Power Apps | Microsoft Learn

Using FetchXML in a Power Apps Portal Web Page Template - Carl de Souza

Was this reply helpful? Yes No