cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alanfallow1958
Helper II
Helper II

Please any help with formula.

I have been jumping from data source to data source so now after being put off excel I have went to sharepoint.  I have a basic ledger with 100 records.  I also have a Trial Balance which works fine with excel but with MSlists I get an exclamation and error.  This is the formula.                       TEXT =      "£" & Sum(Filter(Mainledger, Account = "Campsout"),Debit)

 

Any help would be just great.

2 ACCEPTED SOLUTIONS

Accepted Solutions

If Account is a choice column then try using Account.Value instead of Account.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Jeff

You are a genious that worked thanks very much.

Watched a video on delegate by Shane somebody.  Still not a clue.😁

Thank you

View solution in original post

9 REPLIES 9
Jeff_Thorpe
Super User
Super User

You are probably getting a delegation warning because the Sum() isn't delegable by SharePoint. If your SharePoint list is below the delegation limit in your app settings then you will be fine. By default the data row limit (delegation) is 500 and you can increase to 2000.

 

There are some data sources like Dataverse and SQL where the Sum() is delegable.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Hi Jeff thanks for reply.

Not quite sure what that means but.  I am getting exclamation mark but no figures show for the calc.  The sharepoint only has about 150 records prob only another 50 at the most.  How do I sort the sum delegable whatever that is?🤔😁  All works ok on excell but was recommended to stay clear of that..

Thank you again.

v-xiaochen-msft
Community Support
Community Support

Hi @alanfallow1958 ,

 

It worked for me. Please share the screenshots for troubleshooting.

vxiaochenmsft_0-1650353429390.png

vxiaochenmsft_1-1650353439275.png

 

Best Regards,

Wearsky

Good morning thanks for getting back.  Have attached screen images.  The Trial Balance is just a screen with text boxes and the calculations it gets from Mainledger a Sharepoint list.  I dont have any output on image 3 from the calculations.  Can share app if needed.  Thanks very much.

Another image with error

The accounts column is a choice field does that matter.

If Account is a choice column then try using Account.Value instead of Account.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Ok will try and get back.  Thank you.

Jeff

You are a genious that worked thanks very much.

Watched a video on delegate by Shane somebody.  Still not a clue.😁

Thank you

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,399)