Help with Flow Designer

Ak8977
Tera Expert

Can anyone help me on this

 
I created a catalog item which contains 2 questions from the x table. 
Now based on their selection I need to insert records into the y table.
the following steps I used
Step1- triggered the service catalog
Step2- update the request item
Step3- get catalog variables
Step 4- loop up records from x table
Step 5 - I need to insert records into y table based on look up records.
How I can do the 5 th step
--I used create record action but it only insert single record at a time and the lookup records are grayedout in step5
8 REPLIES 8

Ankur Bawiskar
Tera Patron
Tera Patron

@Ak8977 

please use Lookup Records and then use For Each action to iterate and then use Create Record action

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hello @Ankur Bawiskar ,
I can use lookup records and use for each loop, but the issue is I cannot use the condition in it. 
For suppose I need to test the following condition- 
there are two questions in the catalog of list collector type country and state.
In the condition it need to fetch from the table - only the records matches those filters need to be look up, which I am unable to do it through data pill picker in flow designer.

Mohith Devatte
Tera Sage
Tera Sage

Helllo @Ak8977 ,

you can try adding for each action after your look up records action like below

 

In this example i looked up incident records and then in for each i just used the pill and added incident records looked up in first step and below for each action you can drag in one more action create record which can create a record in your Y table 

Screenshot 2023-08-25 at 16.34.24.png

Hope this helps 

Mark the answer correct if it helps you 

Thanks

 

hello @Mohith Devatte ,

I can use lookup records and use for each loop, but the issue is I cannot use the condition in it. 
For suppose I need to test the following condition- 
there are two questions in the catalog of list collector type country and state.
In the condition it need to fetch from the table - only the records matches those filters need to be look up, which I am unable to do it through data pill picker in flow designer.