Stuck trying with automation to find a managers manager in Assets

[Steven Lees-Smith]

Hi there,

I was hoping to come up with an automation that will come up with a 2nd Level Approver.

Basically in Assets I am storing a users manager, I am trying to come up with an automation that will come up with the managers manager and store it as a Lvl2 Manager.  Ideally just an automation that would update Assets after the AD import is done so the field is always there.

I am just not sure how to structure the update to go from a person, to the manager record to get their manager but then update an attribute for the original person.

Thanks.