Use the SFTP Query Home Directory action to request the path to the user's home directory.
Query Home Directory
SFTP connection
Reconnect if disconnected
Username
Specify the username for which the home directory is requested
Home directory
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.