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 / Shopping Order within ...
Power Pages
Answered

Shopping Order within power Pages

(0) ShareShare
ReportReport
Posted on by Lucas001 2,595 Super User 2026 Season 1

Hello everyone,

 

I am currently working on an easy form to submit an order.

Fields are Object, Price, Amount and Total.

 

Total is a formula column in dataverse which multiplies price and amount.

Is there any possibility to show that calculation directly on the power page? Currently the field is displaying nothing at it is no yet stored in dataverse.

 

Thanks for your help.

Categories:
General topics
  • Verified answer
    ragavanrajan Profile Picture
    ragavanrajan 7,044 Most Valuable Professional on at

    Hey @Lucas001 

     

    Yes it is possible. I have tested it, and it works fine. Below is the screenshot 

     

    With the new PowerFx Formula column 

     

    In Make.powerapps.com 

    1. Choose the right table( shopping) 

    2. Add a column called "Total" and the type as Formula 

     

    ragavanrajan_1-1685526362311.png

     

    3. Hit Save and Publish

     

    In Power Pages 

     

    1. Create a page with List ( Shopping List) 

    2. When you add a new record > by default > The total will be read-only. meaning the formula is applied 

    Output: 

     

    ragavanrajan_0-1685526271529.png


    Hope it helps. 
    ------------

    If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

  • Lucas001 Profile Picture
    Lucas001 2,595 Super User 2026 Season 1 on at

    Hi @ragavanrajan,

     

    thanks for the explanation. Unfortunately I still faced the issue as the prices are not coming form the table itself but are referenced from other table. It seems that in some occurrences the table formula column is "slower" than my flow and I get a null value. The workaround I had is to get the referenced price in a formula column with a lookup lie Table.Field and reference that field inside my flow.

     

    Thanks for you help. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
M Bilal Khan Profile Picture

M Bilal Khan 114

#2
sannavajjala87 Profile Picture

sannavajjala87 30 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 24

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