How can I run a flow with a record producer?

Abigail
Tera Expert

I'm trying to run a flow when a record producer is executed
find_real_file.png

I created a record producer for the table Schedule Entries (cmn_schedule_span).
I added PTO option, so only when schedules entries with PTO type should execute the flow.

But when I run the record producer is not going through

find_real_file.png

I'm trying to run a flow that requires approval from the current user's manager prior to inserting the record on the person's personal schedule

 

It's my first time creating a flow so I am open to any suggestions

Thanks

1 ACCEPTED SOLUTION

ShubhamGarg
Kilo Sage

Hi @Abigail ,

Is your flow expecting the schedule record to get created before running?

How are you linking your approval to your schedule record?

Why I am asking this is - Record producer creates task based records. On submission, it has to anyhow create a record on cmn_schedule_span table. However, using flow you are restricting its creation (basis on approval). Both are working opposite to each other.

For this type of flow, I would suggest you to rather go for catalog item,  submission it will create REQ, RITM and flow will start running. Basis on approval you can create cmn_schedule_span record.

Let me know if issue persists.

Mark this as Correct/Helpful if applicable.

Regards,

Shubham

View solution in original post

3 REPLIES 3

ShubhamGarg
Kilo Sage

Hi @Abigail ,

Is your flow expecting the schedule record to get created before running?

How are you linking your approval to your schedule record?

Why I am asking this is - Record producer creates task based records. On submission, it has to anyhow create a record on cmn_schedule_span table. However, using flow you are restricting its creation (basis on approval). Both are working opposite to each other.

For this type of flow, I would suggest you to rather go for catalog item,  submission it will create REQ, RITM and flow will start running. Basis on approval you can create cmn_schedule_span record.

Let me know if issue persists.

Mark this as Correct/Helpful if applicable.

Regards,

Shubham

Hello @Shubman

What I'm doing is creating the record and not assigning any schedule, so when is approved must be added the personal schedule of the user.

I added a new field to link the approval to my schedule

 

Thanks 

 

 

 

Uncle Rob
Kilo Patron

I'm a little late to the party here, but for any others who found this thread via search, there's a good way to reliably trigger Flow from Record Producer without code.