Is it possible to look-up multiple tables in one flow design?

[jeffreygard1127]

Hi,

I am trying to create 1 flow design that will check if the user has pending task, member of any group, or owner of a service offering before we deactivate them. In doing so, I will need to look-up the following tables:

• sys_user table
• sys_user_grmember table
• service_offering table

Is it possible to look-up multiple tables in one flow design?

[Yashsvi]

Hi @jeffreygard1127 ,

YES, definitely you can look up into multiple tables in a flow.

1. You need to use "LookUp Record" Action, three times and look into each table one by one.
2. Then you can use the results of each action, and perform an if condition followed by deactivation of the user if conditions match.

Thank you, please make helpful if you accept the solution.