Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Column sum using Sharepoint list

(0) ShareShare
ReportReport
Posted on by

Hi, I have a column X with calculated value : [column_Y] * [column__Z]. 

In my app I want to display the sum of all the rows of this column X. How can I make this ? 

I try to do this with this formula : Text(Sum(Inventaire;Value(TotalValue)))

But I have this error : "Failed to convert the value '3.75000000000000' to a number."

Thanks in advance

  • ProtoSup Profile Picture
    ProtoSup on at
    Re: Column sum using Sharepoint list

    I still haven't solved the problem

  • ProtoSup Profile Picture
    ProtoSup on at
    Re: Column sum using Sharepoint list

    @AndrewR1, In my list the values ​​are noted such as: "12,345" while power apps retrieves a string: "12,345"... it transforms "," into "." the formula that you propose cannot logically work... it will be necessary to transform the syntax upstream...

  • AndrewR1 Profile Picture
    AndrewR1 1,518 on at
    Re: Column sum using Sharepoint list

     

    As long as the total value is text data type this will work not sure if the '' on your environment is set to be text or if "" is? 

     

    Sum(Inventaire;Value(Substitute(TotalValue)".";","))

     

     

     

  • ProtoSup Profile Picture
    ProtoSup on at
    Re: Column sum using Sharepoint list

    ok for this : 

    ProtoSup_0-1693386649818.png

    but how can I use my origin formula to have the sum of my column ? 

  • AndrewR1 Profile Picture
    AndrewR1 1,518 on at
    Re: Column sum using Sharepoint list
    Sum(3.0,Value(Substitute("3,750000000",".",",")))
  • AndrewR1 Profile Picture
    AndrewR1 1,518 on at
    Re: Column sum using Sharepoint list

    Ok my bad sorry! you could maybe try substituting the . for a , ? 
    Replace and Substitute functions in Power Apps - Power Platform | Microsoft Learn

  • ProtoSup Profile Picture
    ProtoSup on at
    Re: Column sum using Sharepoint list

    No sir @AndrewR1 , my powerapps is configure with ";" not "," : 

    ProtoSup_0-1693386042685.png

     

  • AndrewR1 Profile Picture
    AndrewR1 1,518 on at
    Re: Column sum using Sharepoint list

    You need to change the ; to a , 

     

    Sum(3,Value("3.750000000"))
  • ProtoSup Profile Picture
    ProtoSup on at
    Re: Column sum using Sharepoint list

    Ok sir ! I have a potential issue ! please see my screenshots ! 
    with your formula : 

    ProtoSup_0-1693385675619.png

     After that i try with comma instead of point and it works !

  • AndrewR1 Profile Picture
    AndrewR1 1,518 on at
    Re: Column sum using Sharepoint list

    Hi @ProtoSup this is something to do with the fact that the 3.750000 is warped in single quotes '3.7500' this should be wrapped in double quotes  "3.7500" maybe try setting the data type back to text and then use the following formula:

     

    Sum(3,Value("3.750000000"))

     

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard