Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

OData query for virtual table fails (url too large)

(0) ShareShare
ReportReport
Posted on 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,389 Most Valuable Professional on at
    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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics