Unanswered

Powerpages, Dataverse and HTML Quesry

(0) Share

Report

Posted on by rachid1977

I have just started to create a portal with Power Pages and Dataverse, actually I have Data in Dataverse: Table Customer: First Name, Last Name, Phone number.

Now I need to read the information and have it in a HTML page (see screenshot), which commands I need to connect to my Dataverse Table, and to read informations, like I need to select a Customer Name from The table and I will have the Phone number of this line (customer phonennumber as a return value).

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Lorne_PEI 39 on at

Like (0)

Report
Copy link

Link copied!

Create a Basic form that points to your table. On that form you can place your customer name and phone number fields and it will render on your Portal.

Was this reply helpful? Yes No
rachid1977 4 on at

Like (0)

Report
Copy link

Link copied!

it was already created, now I'm trying to find how can I get the Information with Liquid scripting, did you have some code to get User from a Dataverse DB name: Users? this is my first project with powerpages and Dataverse, need elementary instructions and examples

Was this reply helpful? Yes No
Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You can retrieve data in a number of ways
Liquid fetchxml - https://learn.microsoft.com/en-us/power-pages/configure/liquid/template-tags#fetchxml
Portals Web API - https://learn.microsoft.com/en-us/power-pages/configure/web-api-overview
Liquid direct access to records - https://learn.microsoft.com/en-us/power-pages/configure/liquid/liquid-objects#entities
To create/update you are limited to the out of the box form submission and Web API.

Was this reply helpful? Yes No
rachid1977 4 on at

Like (0)

Report
Copy link

Link copied!
So, I can now have some ideas and I can reach the dataverse Table, but it's still not working, I know I have some Errors in my script

can somebody help me to correct that and to retriev Data with liquid scripting?
<h1>Dataverse Access Example</h1> <table> <thead> <tr> <th>Customer Name</th> <th>Phone Number</th> </tr> </thead> <tbody> {% for record in records %} <tr> <td>{{ record.custom1 }} {{ record.custom2 }}</td> </tr> {% endfor %} </tbody> </table> {% assign endpointURL='/api/data/v9.2/1metadata#crdc1_smscustomers'%} <script> // Retrieve records from Dataverse //var url = "/api/data/v9.2/1metadata#crdc1_smscustomers?$select=custom1,phone1,custom2,phone2"; portal.request(url).then(function (response) { var records = JSON.parse(response.responseText).value; var html = ""; records.forEach(function (record) { html += "<tr><td>" + record.custom1 + " " + record.custom2 + "</td><td>" + record.phone1 + " " + record.phone2 + "</td></tr>"; }); document.querySelector("tbody").innerHTML = html; }); </script>

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @rachid1977

Please follow the links from @Fubar . If it is only read-only data, I would use the FetchXML builder and build your query and render it in HTML.

1. FetchXML Builder: https://www.xrmtoolbox.com/plugins/Cinteros.Xrm.FetchXmlBuilder/

2. Official micorosoft link

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No