web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Server Logic - Retrive...
Power Pages
Suggested Answer

Server Logic - RetriveMultipleRecords limitations

(1) ShareShare
ReportReport
Posted on by 93
Hi All,
 
I've had some success with switching some client-side JS to server logic with GET and PUT, but I've found a few errors when using get RetriveMultipleRecords. I can't get the syntax right, especially when using a filter or top, which the sever returns as not supported.
 
If there's a quick answer, that's great, but hopefully we can discuss to try and figure out where the docs stop.
 
Any help is appreciated.
I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    1,300 on at
    you can share your syntax , that will be helpful to give right suggestion.
     
    Meanwhile below code could help you : 
    Xrm.WebApi.retrieveMultipleRecords(
        "contact",
        "?$select=fullname,emailaddress1&$filter=contains(fullname,'John')&$top=3"
    ).then(
        function success(result) {
            console.log(result.entities);
        },
        function (error) {
            console.log(error.message);
        }
    );
     
    Generally I use xrmtoolbox to create query. try to use.
  • Suggested answer
    Valantis Profile Picture
    3,258 on at
    Hi @RK2021,
     
    The documentation for Power Pages Server Logic is still quite thin since it is in preview, so you are hitting real gaps.
     
    Here is what is confirmed and what is not.
    The additionalParameters argument in Server.Connector.Dataverse.RetrieveMultipleRecords maps to OData query string options passed to the Dataverse Web API. The syntax should follow standard OData format starting with ? and then the query options. For example:
    Server.Connector.Dataverse.RetrieveMultipleRecords("contacts", "?$select=firstname,lastname&$filter=statecode eq 0&$top=10")
    The not supported error you are getting on filter and top likely means one of these things:
    1. The additionalParameters value is being passed incorrectly. It needs to start with ? and the options need to be URL-encoded where necessary. Special characters like spaces in filter values must be URL-encoded.
     
    2. The Server.Connector.Dataverse connector in server logic may not support the full set of OData options that the standard Dataverse Web API does. Since this feature is in preview the supported subset is not fully documented. Based on what the docs show, the second argument is passed through as an OData query string but there are known cases where certain options may not be supported depending on the preview version.
     
    3. Table permissions on the Power Pages site must also allow the read operation. If table permissions are too restrictive, filters that rely on fields not covered by the permission scope can fail.
     
    What to try:
    - Confirm the exact error message from Server.Logger.Error to see what the server returns
    - Try a minimal filter first: "?$top=5" only, to confirm top works in isolation
    - Then add "?$select=name" to confirm select works
    - Then add "?$filter=statecode eq 0" to confirm filter works
    - If individual options work but combined ones fail, this is a preview limitation worth reporting via the Power Pages feedback
     
    Also worth knowing: if Server.Connector.Dataverse proves too limited for complex queries, the alternative is to call the Dataverse Web API directly using Server.Http (if available in your preview version), which gives full OData flexibility.
     
    What exact error message are you getting and what does your additionalParameters value look like?
     

     

    Best regards,

    Valantis

     

    ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

    ❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

    🏷️ For follow-ups  @Valantis.

    📝 https://valantisond365.com/

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 71

#2
DP_Prabh Profile Picture

DP_Prabh 36

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 32 Most Valuable Professional

Last 30 days Overall leaderboard