cancel
Showing results for 
Search instead for 
Did you mean: 

Filter Collection - Expression no longer working.

JamieMcPake
Level 5

Our 'Filter Collection' action is no longer working. 

Original exception was ' The Collection has no current row' further investigation is showing that our 'Filter Collection Stage is now failing with the below error:

36621.png

The expression is valid:

36622.png

And has produced the results we need in the past, not sure what has changed or where I could be going wrong here.

Thanks,

Jamie McPake RPA Analyst & Developer Digital Technical Services Gateshead Health NHS Foundation Trust
1 BEST ANSWER

Best Answers

Hi Jamie,

Please find below my observations - 

1. In Filter Expression, "[" is missing in first Trim statement i.e., TRIM([URBN])
2.1 If [URBN Number] is Data Item, then you have to remove it from double quotes ("). Expression will be - "Trim([URBN]) = '"&Trim([URBN Number])&"'"
2.2. If [URBN Number] is collection field then Expression will be - "Trim([URBN]) = Trim([URBN Number])"

Many Thanks,
KirtiMaan Talwar

KirtiMaan Talwar
IA Consultant
Deloitte USI

View answer in original post

1 REPLY 1

Hi Jamie,

Please find below my observations - 

1. In Filter Expression, "[" is missing in first Trim statement i.e., TRIM([URBN])
2.1 If [URBN Number] is Data Item, then you have to remove it from double quotes ("). Expression will be - "Trim([URBN]) = '"&Trim([URBN Number])&"'"
2.2. If [URBN Number] is collection field then Expression will be - "Trim([URBN]) = Trim([URBN Number])"

Many Thanks,
KirtiMaan Talwar

KirtiMaan Talwar
IA Consultant
Deloitte USI