Flow Designer - Ask for Approval from field by dot walk

Nisha30 · ‎12-03-2024

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 · ‎12-04-2024

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?

View solution in original post

ChadWilhelm · Wednesday

Hello Uncle Rob,

I am trying to do the same thing however I am able to dot walk to the reference on my custom table. Is there some ACL I need to add to the table in order for it to read?

Thanks,

Cha