I have a very locked down Sharepoint environment where I can use only the Sharepoint Designer or the Sharepoint web interface. I cannot deploy code.
I have list A and list B. User Robert starts a workflow from list A and I need to populate the workflow email with a value from list B (lookup user Robert in List B and give me the ID value).
Is there a way to do that in a constrained environment such as the one I'm using?
Thanks