Power Platform Community Forum Thread Details

I have a Data Table that displays data from a Sharepoint List. I am trying to do a data validity check by comparing the total sum numbers (in one specific criteria) between what is showing in PowerApps and what I have in Sharepoint.

To approach this, I created 2 text boxes next to each other - one that is pulling the total sum number from SP, and the other one pulling it from the the data table.

Sharepoint Summation Textbox Formula:

Text(Sum(Filter(RevenuePlannerSP, Year = "2022" && Period = "June" && ROFOvsActual = "Forecast" && RigGroup = "Offshore Oil"), BaselineRevenue90) , "$#,##0.00")

PowerApps Data Table:

I put the needed criteria in the Items property of the data table, then inserted the text box above (Data Table Below:) and put in the summation formula.

Items property for data table is

Filter(RevenuePlannerSP,RigGroup="Offshore Oil"&&Year="2022"&&Period="June"&&ROFOvsActual="Forecast")

Textbox formula to summarize the BaselineRevenue90 column in the data table is (errored)

Text(Value(Sum(TestTable_1.AllItems,Value(BaselineRevenue90_TestTable_1.Text)) & "000"), "[$-en-GB]#,##0")

It keeps returning "The function 'Sum' has some invalid arguments." error but does not specifically underline what could be wrong.

Also, when I try to type in the formula from the beginning, it does not show an '.AllItems' property for the data table - is it only applicable to galleries and data sources? what would be the suitable alternative here? the only data-related option is '.NoDataText' which I guess implies that the table is empty.