Skip to main content
Community site session details

Community site session details

Session Id : xLJN9RDxXOf0cKU3zQUvhr
Power Apps - Microsoft Dataverse
Unanswered

OData query for virtual table fails (url too large)

Like (0) ShareShare
ReportReport
Posted on 19 May 2022 11:42:04 by

I have set up a virtual table and an OData source for these entities but sometimes the queries the power app makes are too large to do a GET from the api. Maybe it needs to lookup 250 UIds at the same time and that is too long to put in the url for a GET.

 

I want to know if there is a way to make the power app POST the query instead?

My OData api supports this.

Categories:
  • ChrisPiasecki Profile Picture
    6,397 Most Valuable Professional on 19 May 2022 at 13:03:07
    Re: OData query for virtual table fails (url too large)

    Hi @KristianDahl,

     

    To have full control over the request being sent such as a POST instead of GET for a retrieve, you'd have to look at writing your own custom provider which would involve writing plugins for Retrieve and RetrieveMultiple messages.

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics

Loading complete