We are excited to announce the General Availability (GA) of Power Apps portals support for Query data using portals Web API that was introduced in November 2021 release as a preview feature.

Feature capabilities

This feature provides the following capabilities:

• Query records
• Apply system query options
• Request specific properties
• Filter results
• Order results
• Aggregate and grouping results
• Retrieve a count of rows
• Column comparison
• Retrieve related table records with a query

Note

Preview feature site setting WebAPI/enableReadOperationPreview is no longer required as this feature will be GA and enabled by default with portals version 9.4.1.x.

What’s new

Column permissions support for Web API

Table permissions are used to apply security in portals to individual Dataverse table records. You can add column permissions to individual table columns. Column permissions are an optional configuration that are associated with web roles.

When evaluating the permissions, table permissions are evaluated first. If a user has access to table then respective table’s column permissions will be applied. If the user doesn’t have access to table, then any column permissions configuration will be ignored.

Column permissions are optional configuration, and if it is not defined, then related table permission will be applied to all the columns.

To learn more about Column permissions, see the documentation.

Pre-requisites

This feature requires the following versions for starter portal package and portal version:

• Portal host version 9.4.1.x or later.
• Starter portal package version 9.3.2201.x or later.

We are looking forward to your feedback

Your feedback will help us continue to build on and improve the capabilities of this feature. We want to hear from you!

For Web API read operations details, see the documentation.

Thank you,
Neeraj Nandwana