SCCM application file detection in AppData folder

 So you created an application, and you need to detect a file in the user's AppData folder. YOu can't do this directly with a file detection path because SCCM doesn't recognize %AppData%. To do the detection, you need to create a powershell script similar to this one:

if (Get-ChildItem ($Env:Appdata + "\1C\1CEStart")|Where-Object {$_.Name -eq "ibases.v8i"}) {
    return 0
}

Take the script above, and replace the path and the name ofthe file you are detecting to verify the application installation.

Source: https://social.technet.microsoft.com/Forums/en-US/f4a8e9ef-c2ba-4eb1-bbdc-6d2d19fac225/file-detection-method-fails-path-contains-appdata?forum=configmanagerapps