Unanswered

Accessing Dataverse/Power App Data on external Public Website via API

(0) Share

Report

Posted on by Clinch

Hello - I am stumped trying to find a similar idea on how we can achieve this.

We are currently using a model-driven power app/Dataverse to house school applications. Once an application is submitted, our representatives will begin updating the application record "Application Status" custom field as they are going through the various steps.

Our partner wants to create a external website (just simple HTML/CSS/JavaScript) to display an application lookup where applicants can type in their application ID or send applicants direct-links to view the status of their application. (example: domain.com/application-status/?appid=1234)

This external, public website would have to connect to our dataverse/power app via the web api to make the request and display it to the applicant searching/viewing the website.

How can this be achieved? All I have read is that the user looking up data will need to have a Microsoft account and authenticated in our environment to view the data.

Can someone point me in the right direct on how to get this done (article or existing thread). Your help is highly appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @clinch ,

Have you reviewed the following? These are full examples that show how to use the Web APIs to retrieve information from the Dataverse. This should get you started... https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/web-api-samples-client-side-javascript

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
Clinch 2 on at

Like (0)

Report
Copy link

Link copied!

hi @dpoggemann

I actually have review these examples and this is strictly if you're running an application inside of the solution (web resource, etc). I am stricly speaking about querying data outside of the enviornrment via api.
a standalone HTML/CSS/JS website connecting via api to grab data stored in dataverse table.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @clinch ,

This article has videos that will help you from front to back on this process from creating and registering an application in Azure Active Directory to calling the APIs etc.

https://crmchap.co.uk/exam-pl-400-revision-notes-working-with-the-microsoft-dataverse-web-api-and-processing-workloads/

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No