topic RE: Invalid expression - the collection has no data in Product Forum

Invalid expression - the collection has no data

SamAssaf — Wed, 22 Jul 2020 18:36:00 GMT

Hi BP community.

Ever since the last update I've been noticing what appears to be an annoying little bug:

If I loop over a collection which will be filled at some point (an input parameter in my case), and somewhere in that loop, I use a Write stage with values from that collection, it flags it as a validation error "Invalid expression - the collection has no data" (or something like that; I'm using BP in French).

Well obviously it has no data before it actually runs. The thing is, if I refresh the page and validate again, the validation errors disappear, only to come back the next time I open this object. Adding dummy initial data does not suppress the issue.

I know I could simply disable this validation type, except it's pretty useful in other cases and just seems to be broken in the case of Write stages with collections. This problem might very well not be unique to Write stages but I have yet to notice it anywhere else.

Thoughts, anyone?

RE: Invalid expression - the collection has no data

John__Carter — Wed, 05 Aug 2020 16:36:00 GMT

Hmm that does sound odd. Is the collection dynamic and could the error be referring to a missing field rather than missing data? Apologies if that is an obvious question.

Maybe also check if there is another collection with the same name that might be confusing the validation logic. Another possibly dumb question.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Invalid expression - the collection has no data

John__Carter — Thu, 06 Aug 2020 07:58:00 GMT

Is the message related to dynamic fields in the collection rather than data? And maybe check there isn't another collection with the same name (I know this is unlikely).

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Invalid expression - the collection has no data

John__Carter — Thu, 06 Aug 2020 14:06:00 GMT

Sorry about the double response, I was having issue submitting the form.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Invalid expression - the collection has no data

_Amlansahoo — Fri, 21 Aug 2020 04:28:00 GMT

Hi John,

This is a issue. If collection is empty and we are using that collection any where then it's showing it as an error but it is a dynamic collection.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Invalid expression - the collection has no data

spalkar1 — Fri, 21 Aug 2020 13:53:00 GMT

I am seeing the same 'Error'.
1) I am using pre-defined collections to save some labels titles in a structured manner.
2) Previously [ and even now] the code itself works fine.
3) However there a nagging 'error' that shows up for these methods...

------------------------------
Saurabh Palkar
------------------------------

RE: Invalid expression - the collection has no data

Barendde_Villie — Fri, 09 Oct 2020 07:03:00 GMT

Hi BP Community,

I am experiencing the same error. I am on version 6.8. Will updating to 6.9 resolve the issue?

Regards,
Barend

------------------------------
Barend de Villiers
Robotics Specialist
Nedbank Namibia Ltd
Africa/Windhoek
+264816222724
------------------------------

RE: Invalid expression - the collection has no data

AvinashRamkumar — Wed, 14 Jul 2021 22:15:00 GMT

Hi Sam,

Could you confirm if having an empty Initial Row of data solves this issue? If your values are coming In as parameter, the empty row would get overwritten as well.

------------------------------
Avinash Ramkumar
------------------------------