cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mkujalowicz
Level: Powered On

Re: Sum of DataField in BrowseGallery

Hello,

Im not sure if there was an update for this topic, but none of the above solutions worked for me as I imagine that I delegate the 'Sum' opertation to the data source with the filters applied in the gallery. The error message I get is the following:

Part of this formula cannot be evaluated remotely.'Sum' operation is not supported by this connector/service.

 

What I try to achieve is to sum gallery items based on the filters set in two dropdowns, something similar to SUBTOTAL in Excel.

Please help.

Thanks!

Magda

Highlighted
mkujalowicz
Level: Powered On

Re: Sum of DataField in BrowseGallery

Hi, 

I think I have found the solution.

It's a matter of using Allitems in the sum formula:

 

Text(Sum(GalleryMain.AllItems,LEstimate),"[$-en-US]$##,###")

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 108 members 6,006 guests
Please welcome our newest community members: