Task needs to be generated if user is present in the table

suuriyas
Tera Contributor

HI Community,

 

I have a requirement, task needs to be created only when the user is subscribe to mau service offering present in service_subscribe_sys_user_list table.

when a request is raised and the requested for user is present in the service_subscribe_sys_user_list table then task needs to be created.

service_subscribe_sys_user_list is the service subscriptions by user table and if the user name is present with service offering as mau task needs to be created

How can we achieve this in flow designer?

I have used look up records but im stuck 

 

 

 

 

 

 
1 REPLY 1

JenniferRah
Mega Sage

Do a look up record to try to look the user up in the table. Be sure to check the "Don't fail on error" checkbox. 

JenniferRah_0-1746459197642.png

 

Then create an "If" statement after it and add the condition that points to the Look up Record action and checks the Status. The values will be Error if the record wasn't found or Success if the record was found.

JenniferRah_1-1746459256382.png

 

If the lookup was successful, then you can create your task.