Record id Parameter Name - How to Query or map to desired alternative Table Column

(0) Share

Report

Posted on by JonathanDavey1

Hi, wow loving Power Pages!

I have BasicForm (View) using a DV Table.

I would like a QR Code URL to take Users to a specific 'Record ID' in the BasicForm.

I can for example use the following URL.Text to return the Record in the BasicForm "http://www.mydomain.com/?ID=1"

However, the "?ID=1" query is not looking at my 'Record ID' Column, its looking at my Table 'GUID' Column......

The QR Lables need to be printed. The URL's are fixed (?ID=1,2,3,4 etc). I can choose how they are fixed but not change them later.

How do I map or lookup the "?ID=1" Query to an alternative column where I have stored the 'Record ID' =1

Thanks Jonathan

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Fubar 8,352 Super User 2025 Season 2 on at

Like (0)

Report
There is not really a straight forward way to do this, as everything is based on using the internal dataverse record guid. It will also depend on what you need to do - just view something or edit or create something

create custom Web Template
in Liquid get your id from the "request"
FetchXML query based on your id from the request to get the internal record guid (and other data as required)
then either
JavaScript redirect with the internal guid to a Web Page with Basic Form, OR
Create your own Inputs etc and populate them from the FetchXML, and then use the Portals Web Api to submit (if you need to create/edit)
Web Page that uses Page Template that uses your custom Web Template
(note: as this appears to be anonymous access - i.e. not logged into the portal - be mindful that the Table your FetchXML and updating etc would need Global read/update permissions - depending on the nature of the information you are dealing with this may open a information/privacy security hole)

Was this reply helpful? Yes No
JonathanDavey1 69 on at

Like (0)

Report

Eeek, thankyou Fubar, I would have expected a 'feature' out of the box for what to me would be a routine need (low code!).
I will go-away and try and learn sufficient XML

Was this reply helpful? Yes No
JonathanDavey1 69 on at

Like (0)

Report

OK Im struggling, I only need to Fetch the Record and Display the Form.
@Fubar would you be open to some paid private work on this?

Was this reply helpful? Yes No