For Each on a format token

asked on March 21, 2016

Having an issue with a token that is formatted to date and iterated with a For Each.

The problem seems to be happening on the Create Entry activity. We are creating a folder by last, first, dob under a specific spot.

However it seems to create two folders and not just one. One folder is the formatted date, the other is the standard date.

In our create entry we have the following:

%(QueryData_ppllastname#[%(ForEachValue_Iteration)]#), %(QueryData_pplfirstname#[%(ForEachValue_Iteration)]#), %(QueryData_ppldob#[%(ForEachValue_Iteration)]##"MM//d//yyyy"#), %(QueryData_peopleid#[%(ForEachValue_Iteration)]#)

However, if we remove the date format in the ppldob so it is just %(QueryData_ppldob#[%(ForEachValue_Iteration)]#), then it works fine and only creates one folder.

Workflow shot:

Tokens show that it only went through one loop (which it should as I only entered one person).

Any ideas as to what the issue may be?

Thanks,

Chris

0 0

SELECTED ANSWER

replied on March 21, 2016

Do you have a later activity that routes some other entry INTO that folder? If so, in that other activity, do you apply the same date formatting as the original create entry? I would bet the second folder may be getting created as a part of the path of a different activity...

0 0

replied on March 21, 2016

Yes, you are correct. I forgot about the Invoke workflow we had at the very end. The invoked workflow created documents inside that folder and the dates were not formatted there. Found that right after posting but the whole process is about 8 forms and 10 workflows so to test it takes awhile. Thanks for the suggestion!

0 0

Question

Question

Answer

Replies

Sign in to reply to this post.