Flow Designer - Ask for Approval from field by dot walk

[Nisha30]

Hello Experts,

I am stuck at this point to select Approver from a table .

i have a variable which points to custom Table = u_warehouse

Table = u_warehouse has another field = 'WH Manager'.

In request we need the approval to go to 'WH Manager'' against the data filled in that variable (WH Code)

Example: if LT1 is selected in Variable (WH Code) the Approval should go to Anker Bamah

WH Code                   WH Manager

LT1                              Anker Bamah

BS4                             Amita Sarkel

But in ''Ask for Approval'' there is only option for User, Group,

Please help how to generate this approval step guidance needed please need to avpid as much script if not at all feasible.

Thanks

[Uncle Rob]

Is there a table that stores your WHCodes and the desired WHManager?
Have you ever used Decision Tables before?

[Nisha30]

Hi @Uncle Rob 

We have hundreds of records for them in custom table .

we have custom table which stores all these WH codes and WH Manager

Table = u_warehouse

Field 1 = WH Code

Field 2= WH Manager

Thanks

[Uncle Rob · Accepted solution]

So you need to do 2 things before the Ask for Approval action.
1)  Get Variables - this will give you access to the wharehouse variable you said is on the catalog item
2)  Look Up Record - (singular not plural) Look up to the wharehouse table where WH Code matches the variable you retrieved in (1)

3)  Ask for Approval - Pull the WH Manager field from (2)

Have you done those steps already?

[Nisha30]

Thanks @Uncle Rob 

Did not explored LookUp Record. Thanks for highlighting. Yes used that It worked without scripting or Inputs/Outputs

Thanks a lot