Having trouble invoking a process and filling out a table. My strating variables are based on metadata.
Has anyone accomplished this?
*Update* It create a new form for each person instead of listing them in the table.
Having trouble invoking a process and filling out a table. My strating variables are based on metadata.
Has anyone accomplished this?
*Update* It create a new form for each person instead of listing them in the table.
Can you please post a screenshot of your workflow?
Nothing to it right now.
As your workflow currently stands it is invoking a forms process for every item found from the Search Repository activity.
So I need to create token that gathers the info I need than use that token in the invoking process?
You need to take the Invoke Business Process activity out of the For Each Row activity. The question I have is if you then have more than result from the Search Repository activity and tell the Invoke Business Process activity to take the token from the Search Repository and there is more than 1 result, will it automatically add additional rows? I have not tested that before, so I do not know the answer currently.
No it will only give you the first result. That's how I started then I worked my way to what I have now. I can create multiple forms. I'm wondering if this is even possible straight out the box without scripting.
So it looks like you do need a Repeat loop, but it needs to be implemented differently than how you originally had it.
It would look something like the picture above. The idea is that the search repository task would return multiple values. Then for each value it returned, you would add that value to a token that is comma delimited. After all of the values are added to the new token, you would use that token in the Invoke activity to assign to a table field. There is another post in Answers with more detail of how to do it, but I haven't been able to find it yet. When I do I will post a link to it here.
Figured it out finally Gosh! Wouldn't have got it without your help!
Glad I could help.
I've been trying to assign these values for several days now and have hit a wall. I know it is probably some little thing I am missing but hoping someone can chime in.
I am trying to assign 5 columns values to a table and it may be more than 1 row (starts at 8 rows). I have 5 different multi-value tokens
that I populate by sending through a loop (for each row as it is a SQL lookup).
I've put in a track tokens and they are populating correctly. I then attempt to assign them to a table in a form via the "Set Business Process Variables" activity. When I assign the token to the corresponding column variable in the table I am setting it as comma delimited as advised above.
Thus they are formatted
Is the token a multi-value token where you are appending the new values in the loop or is it a single value token where you are building a comma delimited string?
When you assign it to the "Starting Variable Value", are you assigning it to the table token you grabbed in the "Fields" or to the specific column token within that table?
When assigning it to the "Starting Variable Value", if it is a multi-value, how are you formatting the token?
Never mind, I figured it out. There is no need in workflow 10.2 with Forms 10.3 to separate it out. I still load it into a multi-value token but pass it in as a multi-value token and not all values separated by anything.
What is interesting is how it handles columns in the table you assign a multi-value token to but do not pass anything into because they were null. It puts the value as <Removed> which makes sense but just passing that along in case anyone else is confused by that.