Create multiple records through Flow Designer from Record Producer

[mballinger]

Hello,

I have a record producer with multiple Multi Row Variable Sets. I need to create a flow, when a record is created from the Flow, it needs to grab all the line items from each MRVS and create a new record.

How can I do this?

Thanks!

[Ankur Bawiskar]

Hi,

I believe Flow won't trigger for Record Producer.

Are you able to trigger it against the record submitted via record producer?

Regards
Ankur

[mballinger]

Thanks for your response @Ankur Bawiskar. I may have to add another variable to differentiate the record. Once I do that, how would I loop through each of the MRVS and create records? There might also be multiple line items for each MRVS so I would need to account for those as well.

Thanks!

[Ankur Bawiskar]

First question are you able to configure flow on trigger of Record producer?

[Ankur Bawiskar · Accepted solution]

@mballinger 

You can also use after insert BR on your record producer target table

Sample Script below

I assume your MRVS has name and email variable

(function executeRule(current, previous /*null when async*/ ) {

	var value = current.variables.variableName;
	if(value){
		var parser = JSON.parse(value);

		for(var i=0;i<parser.length;i++){
			var gr = new GlideRecord("tablename");
			gr.initialize();
			gr.u_name = parser[i].name;
			gr.u_email = parser[i].email;
			gr.insert();
		}
	}

})(current, previous);

Regards
Ankur