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

(0) Share

Report

Posted on by ragavanrajan

7,034 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:

Using Apps Using Formulas

All responses (6)

Answers (1)

ragavanrajan 7,034 Most Valuable Professional on at

Like (0)

Report

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

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.
Verified answer

WarrenBelz 146,609 Most Valuable Professional on at

Like (0)

Report

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

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?
ragavanrajan 7,034 Most Valuable Professional on at

Like (0)

Report

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

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.
WarrenBelz 146,609 Most Valuable Professional on at

Like (0)

Report

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

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.
ragavanrajan 7,034 Most Valuable Professional on at

Like (0)

Report

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

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

Is this possible in DataTable ? Please advise
WarrenBelz 146,609 Most Valuable Professional on at

Like (0)

Report

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

@ragavanrajan ,

Where are you putting this formula?

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