Use the SFTP Query Home Directory action to request the path to the user's home directory.

Username
Specify the username for which the home directory is requested
Save to variable
Specify a variable to save the home directory information into.
Use Long Pathname
Specify to return a long listing. The long listing includes the permissions, size of file, ownership and other properties.