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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Automatically Update B...
Power Pages
Unanswered

Automatically Update Balance Quantity in Item Table when Creating a New GRN Item

(0) ShareShare
ReportReport
Posted on by sindhu2

I have two tables in my Power page - GRN Item table and Item master  table. In the GRN Item table, there is a lookup field for Item Id, along with a 'Qty Delivered' column. The Item table contains a 'Balance Qty' column.

I want to implement an automatic update mechanism so that when I create a new GRN item, the 'Balance Qty' column in the Item table gets updated automatically (i.e., Balance Qty = Balance Qty + Qty Delivered).

How can I achieve this using Web API in Power page? 

Categories:
General topics
I have the same question (0)
  • Lucas001 Profile Picture
    Lucas001 2,529 Super User 2026 Season 1 on at

    Hi @sindhu2,

     

    I believe you used a normal view to show your tables.

    PowerPages have a caching which can take up to 15 minutes. To deeper understand that have a look at this post: https://powerusers.microsoft.com/t5/Power-Apps-Portals/Portal-caching-issue/td-p/783644

     

    You can use a normal form to let users add a new item. If the column is a formula column in some way it is updated automatically. If it is just a field and you calculate it on your page itself use the approach in the thread above + the webApi read and write it into the field.



    --------------------------------------------------------------------------------------

    Hope that helps.

    If the post solves your problem, please mark it as solution. If it helps, consider 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

News and Announcements

Welcome to the Power Platform Communities

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 February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 21 Super User 2026 Season 1

#2
CN-06091549-0 Profile Picture

CN-06091549-0 18

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 17 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans