web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Sum problem in gallery...

Power Pages

Answered

Sum problem in gallery, not supported for evaluation

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a Gallery.
In a textfield :
Text( First(ThisItem.'Order Details').'Unit Price' , "[$-en-US]$ #,###.00" ) work.
Text( First(ThisItem.'Order Details').Quantity , "[$-en-US]$ #,###.00" ) work.
But
Text( Sum(ThisItem.'Order Details','Unit Price' ), "[$-en-US]$ #,###.00" ) does not work.
Text( Sum(ThisItem.'Order Details',Quantity ), "[$-en-US]$ #,###.00" ) does not work.
Text( Sum(ThisItem.'Order Details',Quantity*'Unit Price' ), "[$-en-US]$ #,###.00" ) does not work.
This formula is uses scope, wich is not presently supported for evoluation.
???

Categories:

Power Apps portals

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Please try this:
1. remove all CDS connection
2. turn off the 'Improve data source experience and Common Data Service views',
3. re-add the entity to data source,
4. save the app and exit
5. re-edit the app, the formula will work.
Sik

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

You're Invited to Keeping It Real with the Power Platform

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

oliver.rodrigues 30 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