PowerApps- Datatable with SharePoint list adding columns by subtracting two number fields

(0) Share

Report

Posted on by ragavanrajan

7,044 Most Valuable Professional

Hi PowerApps Experts,

I have a SharePoint list where few of my fields are defined in SharePoint as "Number Field Type" . I am trying to perform a simple subtraction operation by using those fields and add it in a DataTable as a "AddColumn".

Below are my fields in SharePoint list

Field Name	Field Type
Start(m)	Number
End(m)	Number

The below is displayed on DataTable columns

And in my datatable Formula :

I am getting Invalid argument type.

How do I achieve this simple arithmetic operation? Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@ragavanrajan ,

Where are you putting this formula?

It should work in a Gallery if both fields are numeric.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi @WarrenBelz This formula is currently in DataTable - items property.

Is this possible in DataTable ? Please advise

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @ragavanrajan ,

Just did some testing and got a data table to accept the syntax, but the field was not added - so it appears it is not possible.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi @WarrenBelz , thanks for confirming that. much appreciated. I am really disappointed to do simple arithmetic operation in datatable it seems like not possible.

Happy to get your advice on what is the alternative way for this. I am really open here for out of the box thinking.

Awaiting for your inputs.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @ragavanrajan ,

You can make a gallery look like a data table with a bit of formatting and the code would certainly work in one of those.

Is there any particular reason you want a data table?

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

thanks again @WarrenBelz . I will try the gallery now. The only reason I wanted to use Data table is to perform lookup to another sharepoint list with reference to my current data table. If that is possible in Gallery then I am happy to use Gallery.

Was this reply helpful? Yes No