Hi Nitesh,
Let me try to explain you when you get this error exactly. Suppose you have a collection called as 'Input Collection' with one field named as 'Field1' as shown below:
Scenario I:
Now, if you use the 'Append Field (Text)' action with this collection and try to append a field name with some field apart from what is available in it which is 'Field1' in our case like shown below:
Here, I am trying to append a field called as 'Field2' which is not available in the 'Input Collection'. If I try to execute the workflow now, I will get the same error:
The question is why does this happen? This happens since we are using a defined collection with a defined schema.
Scenario II:
If I used the same logic with an undefined collection, I would just have the column added but not the value as shown below:
Here why we are not seeing the value is because, this action does not adds any row and since we have an empty collection by default, we won't have any value updated in it.
Scenario III:
If you had a row added to this collection beforehand then append text action would have appended the data value to it as well.
So here if I had a collection with a field name and also a row included as shown below:
Then, I can use the append text action to add a value to that field properly:
So, to conclude remember the following points while using this action:
1) If you are using a defined collection, your field name that you are going to append should always match to one of the field names that is present in it's fields definition or schema otherwise you will get the exception as mentioned in this thread.
2) If you are using an undefined collection, you can use this action as a technique to add new columns or fields of text type (it's a hack we use a lot!)
3) If you want the data to be appended to the given field, ensure that you always have a row in your collection along with the appropriate field available beforehand when you want to use this action.
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
Let me try to explain you when you get this error exactly. Suppose you have a collection called as 'Input Collection' with one field named as 'Field1' as shown below:
Scenario I:
Now, if you use the 'Append Field (Text)' action with this collection and try to append a field name with some field apart from what is available in it which is 'Field1' in our case like shown below:
Here, I am trying to append a field called as 'Field2' which is not available in the 'Input Collection'. If I try to execute the workflow now, I will get the same error:
The question is why does this happen? This happens since we are using a defined collection with a defined schema.
Scenario II:
If I used the same logic with an undefined collection, I would just have the column added but not the value as shown below:
Here why we are not seeing the value is because, this action does not adds any row and since we have an empty collection by default, we won't have any value updated in it.
Scenario III:
If you had a row added to this collection beforehand then append text action would have appended the data value to it as well.
So here if I had a collection with a field name and also a row included as shown below:
Then, I can use the append text action to add a value to that field properly:
So, to conclude remember the following points while using this action:
1) If you are using a defined collection, your field name that you are going to append should always match to one of the field names that is present in it's fields definition or schema otherwise you will get the exception as mentioned in this thread.
2) If you are using an undefined collection, you can use this action as a technique to add new columns or fields of text type (it's a hack we use a lot!)
3) If you want the data to be appended to the given field, ensure that you always have a row in your collection along with the appropriate field available beforehand when you want to use this action.
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
