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.

[FrankieTEWV]

Thanks - ive managed to fix it now - so in my collector it did have all 3 fields before adding to the work queue - however the only data populated in those fields were the the patient id and the next date kit due ...  it didnt have any data against the mobile number before adding to queue  as it got that in the second part of the automation in my executor, and i think that was where the issue was.

So ive added a full stop to the mobile field before it gets added to the work queue so it has some kind of data in there - and then in the executor it can now pass the mobile number into that field and overwrite the full stop.

Not sure if there is a better way but it works!

Thanks everyone 

[RoopkiranBevara]

Hi @FrankieTEWV , One final crosscheck as per the above screenshots. Mobile number inputs bubbling from Object level & storing in Item Data collection. Instead of that please store in separate data variable & add it into the Item Data Collection along with remaining fields.

Please follow below steps once:

1. 1st Method to add one blank row in initial values & store the values:

2. 2nd Method: Follow Below steps

Object level - receiving Mobile Number (Output param) - Store in one data variable name like (Mobile Number)

Next take an action called Add Row from collections VBO.

Use a Multi Calculation stage to pass the (Mobile Number, patient ID & Date Next KIT Due) values in Respective fields in Item Data Collection.

Hope these methods will be helpful to you😀

Regards,

Roopkiran.