Skip to main content

Notifications

Power Pages - General Discussions
Answered

Delay in CRUD WebApi for Power Pages

(0) ShareShare
ReportReport
Posted on by 2,089

Hello everyone,

 

I know for now that the caching takes some time that's why I cannot use FetchXML or rely on the portal itself to be able for realtime data manipulation. Therefore I implemented the CRUD WebApi in hope that it works in realtime.

In my tests I still have a delay of around 20 seconds, leading to the problem that if an item is sold out the Api tells the client it's still available.

 

Does anyone know how I can make a power page truly connected to dataverse in realtime.

Goal is that if 2 people press the purchase button on the same time, only one of the requests should be able to go through. 

Categories:
  • Verified answer
    oliver.rodrigues Profile Picture
    oliver.rodrigues 9,079 on at
    Re: Delay in CRUD WebApi for Power Pages

    Hello, did you try the "date" trick that I mentioned on a previous post?

    I have an old article on Caching, but some elements are still relevant:

    http://oliverrodrigues365.com/2020/07/27/power-apps-portals-caching-tips/


    What I do for every retrieve that I want to make sure to bypass the cache, I include a "name != datetime.now" so the query is always different.

    for example:

    url: "/_api/<table>?$select=<columns>&$filter=<appIdColumn> eq " + applicationId + " and <nameColumn> ne '" + Date.now() + "'",

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard