web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Best way to interact w...

Power Pages

Answered

Best way to interact with Dataverse

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Power Apps portals

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

oliver.rodrigues 33 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans