You’re offline. This is a read only version of the page.
223
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
Share
ReportFilter('Configs Inventory App', Value(Min_Qty_Column1.Text) > Value(Total_Qty_Column2.Text))
the error
Ok great that worked
Filter('Configs Inventory App',Value(Total_Qty) < Value(Min_Qty))
i do get a Delegation Waring but my rows will never reach 2000 so it will be fine.
Thanks you for your help.
Please try adding back the Value() before each column. If that doesn't help, try to create the same table in a different screen with the same Item logic - If it works, simply delete and re-create the table you are using (maybe it got cached).
they are spelled correctly
Maybe there is a different way to filter the Data table.
this is a small part of my data i want this table to only View record 19. because the amount is lower
Are you sure the columns are spelled the correct way? Could you please add a galary and set it's items property to 'Configs Inventory App'. After that check if these columns are visible when you start typing 'thisitem. ...' in one of the labels in that gallery. Check how they are spelled - there might be a difference between how SP is displaying them and how powerapps is reading them.
I'm using SharePoint
data source = 'Configs Inventory App'
data table = LowQtyItemsDataTable
both columns are number
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?
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
they are columns names in the data table. they reference the column in this table
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
All responses (
Answers (
