Filter datatable by values in two colums

(0) Share

Report

Posted on by Chrisguff12

229

I need help filtering a data table.

I have a data table with two column's 'Total_Qty' and 'Min_qty'. I want to only show the records where the total qty is less then the min qty. I am getting an error with my current code. can you please let me know if i can fix this to make it work.

MY code

Filter('Configs Inventory App', Value(Min_Qty_Column1.Text) > Value(Total_Qty_Column2.Text))

the error

Categories:

General Questions

I have the same question (0)

All responses (14)

Answers (2)

PTBBSolutions 691 on at

Like (0)

Report

Re: Filter datatable by values in two colums

@Chrisguff12

Can you share the code behind 'LowQtyItemsDataTable'.'Items'?

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Filter datatable by values in two colums

The code I provided is the only code I have on the data table under property 'Items'

Filter('Configs Inventory App', Value(Min_Qty_Column1.Text) > Value(Total_Qty_Column2.Text))

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

Re: Filter datatable by values in two colums

@Chrisguff12

What about the text input controls? Have you set any default properties to them, and if yes - please share the code.

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Filter datatable by values in two colums

I don't have any text inputs. I was going to also filter the table with a dropdown that would filter by the Category column. but i havent set that up yet.

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

Re: Filter datatable by values in two colums

@Chrisguff12

Then what are Min_Qty_Column1 and Total_Qty_Column2 and whey are they coming from?

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Filter datatable by values in two colums

they are columns names in the data table. they reference the column in this table

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

Re: Filter datatable by values in two colums

@Chrisguff12

You are trying to filter the source from the output - this is causing a circular reference. If your columns are numeric, you don't need the Value() as well.

In the Filter statement, refer to the columns from the data source directly, without adding .text

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Filter datatable by values in two colums

Ok so I changed my code to Filter('Configs Inventory App',Total_Qty < Min_Qty)
Now when I type the Last ")" in the code shows that it is working, after a few seconds the string turns red and gives me this error.

do you know why its failing?

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report

Re: Filter datatable by values in two colums

@Chrisguff12

What is your data source? What are the types of these 2 columns?

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Filter datatable by values in two colums

I'm using SharePoint
data source = 'Configs Inventory App'
data table = LowQtyItemsDataTable
both columns are number

Was this reply helpful? Yes No