Field doesnt exist within this collection

[FrankieTEWV]

Hello,

my automation involves reading a mobile number from a system and then i want to throw this value from the object level up into my process level to store it in my data item collection so it can be added against the work queue item.

I've done this before in previous automations with no issues but this one is giving me an error to say " The Field 'Mobile Number' doesn't exist within this collection.

It does exist within the collection so I'm really confused as to why I'm getting this error - please see below screen shots 

Object - 

Process - 

Any help i would appreciate it - thanks

Frankie

[RoopkiranBevara]

Hi @FrankieTEWV , Above steps looks fine, but please make sure/crosscheck in Item Data collection at least one row should be exist to pass/save the values. Before passing the value to the collection please include Add ROW action & try it once. 

Kindly crosscheck if any spaces exist in the filed name : Mobile Number.

Before using the Object just take some dummy data & try it in Process level collection. Hope these steps will sort out your issue.

Regards,

Roopkiran.

[SayeedBinAbdullah]

Hi @FrankieTEWV 

Under Collections Properties the Current Values tab is greyed out which indicates the collection is not initialised,

As Roopkiran suggested add a row in the collection first and try to run the page from Start stage in which the collection Item Data is stored to initialise the collection.

Best Regards,
Sayeed Bin Abdullah

[FrankieTEWV]

Thanks for getting back to me, in my automation i use the get next item action in my executor to pull the data collected in my collector from the work queue which is the patient ID and Date next KIT due into the item data collection...  so there is a current row in the item data collection once those are pulled through - see below

but the mobile number just wont pass into into it? Do I still need to do the add row action even if there is a current row in the collection ? Like i say I've done this in another automation passing in a value back to the collection without using a current row. I've also checked the spelling and made sure there are no spaces before or after.

Thanks

Frankie

[RoopkiranBevara]

Hi @FrankieTEWV  Yes please use the Add row action before passing the values into the collection & try it once.

Regards,

Roopkiran.

[FrankieTEWV]

Thanks ive tired the add row but it still doesn't pass it  back unfortunately - il keep on digging and hopefully get it to work 

thanks for your help so far 

Frankie

[david.l.morris]

@FrankieTEWV, to me it looks like what is happening is that you have your Item Data collection defined with 3 fields, but then your work queue item data doesn't actually contain all three fields. Instead, the queue item data contains 2 fields. When you do Get Next Item, it overwrites your Item Data collection with just the two fields and drops the Mobile Number field. You don't get an error at this point because Blue Prism allows overwriting a collection using either the same fields or a subset of the same fields.

There are a few ways to solve this, but I think the easiest way would be to handle adding the Mobile Number field when adding to the work queue. Make sure that all 3 of the fields are there when initially adding to the work queue, and then your problem should go away since Get Next Item will overwrite the Item Data collection with all 3 fields after that.