Unanswered

Filtering issue

(0) Share

Report

Posted on by Russorusso

Hi.

I have a canvas app displaying a table data of defects. I have two basic sort filters setup pulling in all data. One is to sort by year 2019/ 2020 and the other is to sort by state. When I set my first filter to all years, it works correctly, I see all my data. But when I set it to filter just by state, Some states are not showing the 2020 defects but other states display correctly. So, the filter is working correctly for most all, but some not.

Is there a known PA filtering issue or a performance issue that might be causing this?

Categories:

Governance & administering

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Russorusso ,

This looks like a delegation issue.
When using non-delegation functions, only the firstN pieces of data can be processed.
Hope this link will help you: Here

Could you tell me:
How many records do you have in the data source?

If this is a delegation issue and your number of records is greater than 500 and less than 2000,I suggest you modify the setting and change its value to 2000.

If your number of records exceeds 2000, please provide the formula.
Maybe you could use delegation functions instead of non-delegation functions.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Russorusso 6 on at

Like (0)

Report
Copy link

Link copied!

I have 600 records, yes I have that set to 2000.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Russorusso ,

So does it work?
If it doesn't work, could you provide more information?

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Russorusso 6 on at

Like (0)

Report
Copy link

Link copied!

Sorry I already had that set the 2000. No it does not work. What other information Do you think would be helpful for me to share?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Russorusso ,

Could you provide your formula and the data type of the columns mentioned in the formula?

Best Regards,
Wearsky

Was this reply helpful? Yes No
Russorusso 6 on at

Like (0)

Report
Copy link

Link copied!

I’m using the collect formula and the table records are text.

thank you for helping with this issue

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Russorusso ,

I’m afraid it’s difficult for me to help you through the information you gave.
Please provide specific formula and data type.

Best Regards,
Wearsky

Was this reply helpful? Yes No