Add advanced client-side functionality

(0) Share

Report

Posted on by AK-13121043-0

Dear Community member,

Hope you are well.

I am learning how to use JavaScript and CSS to manipulate client-side visibility and functionality of webpages to extend Power Pages websites.

I aim to:

Set up site settings and table permissions to enable portals Web API requests.
Add inline code to a content webpage to retrieve and transform the data by using the portals Web API.
Use an external JavaScript library to plot the transformed data.

The sample data for this exercise is an Account Table from Dataverse.

I seem to be having problems with enabling portals Wen API requests to the Dataverse table, I could not retrieve data from the table to plot the chat.

My outcome should resemble the first picture but the instead i got a different result(See screenshot).

What do you think could have gone wrong?

I'd appreciate your help!

Categories:

Customize & extend

chart.png

Screenshot 2025-1...

output.png

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (7)

Answers (0)

Michael E. Gernaey 53,345 Super User 2025 Season 2 on at

Like (0)

Report

HI @AK-13121043-0

Unfortunately your last picture did not come through.

However, can you share what your Enabled WebAPI's look like under Power Pages Management / Site Settings? Just so we can verify what you have.

Then can you share the Role you are using and a picture of the Table Properties assigned to that role please.

Lastly do the users have licenses or are you doing anonymous access?

Was this reply helpful? Yes No
AK-13121043-0 22 on at

Like (0)

Report

Hi Michael,

Thanks for your reply to my query.

I have shared what my Enabled WebAPI's look like under Power Pages Management / Site Settings.

I have create a Global Read table permission row for the account table with Authenticated users and anonymous users roles.

Thanks

Screenshot 2025-1...

Screenshot 2025-1...

Screenshot 2025-1...

Was this reply helpful? Yes No
AK-13121043-0 22 on at

Like (0)

Report

Hi Michael,

I have attached the output of what my Enabled WebAPI's look like.

schoolconnect.powerappsportals.com/_api/accounts?$select=name,numberofemployees,revenue

Thanks

Screenshot 2025-1...

Was this reply helpful? Yes No
Suggested answer

Fubar 8,340 Super User 2025 Season 2 on at

Like (0)

Report

Sorry, I miss read your image - you have not shown the Site Settings for the Web API in your images (they may be on the next page etc)

There should be 1 Site Setting for the Table in question

There should be 1 Site Setting for the Table' fields that are listed in your query (1 site setting with a comma separated list of fields in the value)

See the 2nd table https://learn.microsoft.com/en-us/power-pages/configure/web-api-overview#site-settings-for-the-web-api

For development you can also use an asterisk for the fields site setting value for all fields (but using an asterisk should just be for development and not for production).

Was this reply helpful? Yes No
AK-13121043-0 22 on at

Like (0)

Report

Hi mate,

I have attached the screenshots with the Site Settings for the Web API in your images.

Screenshot 2025-1...

Screenshot 2025-1...

Was this reply helpful? Yes No
AK-13121043-0 22 on at

Like (0)

Report

I am using a free Developer Plan to learn and build skills on Power Apps, Power Automate, and Microsoft Dataverse.

Was this reply helpful? Yes No
Suggested answer

Fubar 8,340 Super User 2025 Season 2 on at

Like (0)

Report

Check to see if it has something to do with the out of the box inheritance. Use the Power Pages Management app and go to the Contact record you are signing in as, and manually assign the Authenticated Web Role against the Contact and try again (after making the change you will need to Sync / Clear the portal cache for the change to take affect - or wait up to 15 minutes).

If it starts working, look at all your Web Roles and make sure only 1 has the Authenticated checkbox checked (the portal user will only inherit permission from 1 Web Role and if it finds multiple will choose 1 i.e. there can only be 1 Web Role with the Authenticated checked, and 1 Role with the Anonymous Checked)

Was this reply helpful? Yes No