Hi @Anonymous ,
What is the column type of your "Spent" and "Amount" column? Are they both Nmuber column?
Where do you want to display this "Total" column?
I assume your "Spent" and "Amount" column are Number column, and you want to display this “Total” column inside a DataTable. You can do the calculation inside PowerApps. I will give you the detailed steps about how to achieve this:
1. Create a new list called “subtract” with two Number column named “Spent” and “Amount”:
2. Go to your app and add a DataTable, set the Items property of this DataTable as below(remember to replace your own SP list name):
AddColumns(subtract,"Total",Spent-Amount)
3. Go to the Properties pane of this DataTable, click “Edit fields” to add the new column added in step 2.
4. This time, check the results in your Data table:
If you create a new list item in SP list, and refresh your data source inside the app, you will see the new added record in the DataTable:
Note:
- AddColumns() function don't modify the original SP list. Instead, it takes that table as an argument and return a new table with a transform applied. So you cannot see the new added columns in your SP list.
- You can also use this formula in a Gallery if you want to display records in a gallery.
Best Regards,
Allen
