Question

Creating Folder from LF Query

Workflow

Updated March 15, 2017

asked on March 14, 2017

I am trying to create folders for all my vendors. I have created a workflow that runs a query for the vendor list. I know it finds the entire list (5052 entries) however it only creates the first row entry folder. The workflow continues to run until it reaches the end of the list. however, it only creates the first folder corresponding to the first entry in the list.

What have I missed?

0 0

Answer

SELECTED ANSWER

replied on March 15, 2017

No, there should be a token in For Each Row for each column your Query Data retrieved. Based on the screenshot, you want to use the "Folder Name" one.

1 0

Replies

replied on March 15, 2017 • Show version history

It's hard to guess without seeing your workflow. Did you use a For Each Row activity (if using a Query Data) or a For Each Entry (if using a Search Repository) to go through the query results?

0 0

replied on March 15, 2017

see post of wf. Thank you for any input.

0 0

replied on March 15, 2017

Sorry I uploaded the export. I guess I need to post the screen shot. few seconds.

0 0

replied on March 15, 2017

Please see the wf I created.

vf-flow.jpg (55.08 KB)

| Download

0 0

View 2 previous replies

replied on March 15, 2017

You need to use the tokens generated by For Each Row in Create Entry (instead of %(QueryData_Folder Name) in order to get the current value.

0 0

replied on March 15, 2017

would I use 'iteration'?

0 0

SELECTED ANSWER

replied on March 15, 2017

No, there should be a token in For Each Row for each column your Query Data retrieved. Based on the screenshot, you want to use the "Folder Name" one.

1 0

replied on March 15, 2017

Okay, I have updated and tested the wf. It still doesn't work. Diagram attached.

vf-flow2.jpg (50.78 KB)

| Download

0 0

replied on March 15, 2017

Hey, got it! I need to refresh my sql connection. It works!!! Thx :-)

0 0

You are not allowed to follow up in this post.

Question

Question

Creating Folder from LF Query

Answer

Replies

Sign in to reply to this post.