Best way to interact with Dataverse

(0) Share

Report

Posted on by Community Power Pla...

Hi!

I'm building the power apps portal with data located in the Dataverse.

One of the users stories requires a calculations based on the information present in multiple tables of the database.

I have an html button on the portal page which is calling the JavaScript function. But from this function i need to do some operations on the data and save it to database. I see two options here.

1. Create an API using Powerapps flows, but all actions to get the data and update it requires premium subscription.

2. Build all the logic in JavaScript using datavesrse web API to get the data and to write the data (https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-data-web-api), so everything is on the client side, which doesn't seem very secure to me.

Is there any other option that I'm missing?

All responses (1)

Answers (1)

Verified answer

Fubar 7,995 Super User 2025 Season 1 on at

Like (0)

Report
Re: Best way to interact with Dataverse

It really depends on the specifics of what you need to do
Structure what you are doing so there is a Submit/Next (e.g. could use a Web Form, or redirect on success) that moves the user to another page and then handle it with realtime workflows or plugins and present the results on the next page; or
Build a custom Web Template and load what you need into it (via fetchxml) and populate JavaScript variables etc (this assumes that you don't have a huge amount of other data e.g. static lists); or
Use the Portals oAuth 2 Implicit Grant Flow and call it (Ajax) from your page; or
Setup an Azure App and call it from your page