Assign a request to USER based on the dynamic attribute in Update User Form

[userr]

Hi,

Need to send approval based on the value selected in dynamic attribute on Update User Form.

Query used for custom assignment:
select userkey from users where userkey = '${dynamicAttributes.get('secondaryManager')}'

secondaryManager - Attribute Name in Form.

Request is getting assigned to Admin.

Thanks for your response!

[NM · Accepted solution]

Hi @userr, 

Select customquery from dropdown instead of user group in custom assignment block 

2) try this 

select userkey from users where userkey = '${secondaryManager}' 

Or this 

select userkey from users where userkey = ${secondaryManager}

Hope secondary manager attribute in form shows userkey.

[userr]

Hi @NM 

Thanks for the prompt response!

1. I'll change the dropdown value.

2. We need to assign the approver based on the Dynamic Attribute.
like there is scenario where user is allowed to change the Secondary Manager from From then request should go to the New User selected from the 'Secondary Manager Attribute'

[NM]

@userr share the secondary manager DA

[NM]

@userr having trouble opening the file .. please share ss

[userr]

select username as ID, email as inlinedescription from users where customproperty22 in ('WL2','WL3','WL4','WL5','WL6') and statuskey = 1 and regioncode = 'Employee'

[NM]

@userr try this

select userkey from users where userbame = '${secondaryManager}' 

Or 

select userkey from users where username = ${secondaryManager}

[userr · Accepted solution]

Hi @NM 

After changing it to below. It is working

Select customquery from dropdown instead of user group in custom assignment block