In your first example you're using the '-match' operator. The regular expression you're using is actually looking for the string "apvdp100ProfileTestP1088100.txt" (where the "." represents "any character", not the literal value "."). I doubt that's what you intend. Because you intend to match the literal value "\" and ".", change that regular expression to: "\apvdp100\Profile\TestP1088\100.txt"
The "\" in a regular expression is an escape character. You need to escape the escape!
The "." in a regular expression means "match any single character".
If you intent to match the entire $_.Path value, you should be intentional and add "anchor" characters at both ends of your regular expression to avoid partial matches: "^\apvdp100\Profile\TestP1088\100.txt$"
If you're going to post your question in multiple forums, please make note of that by linking it in both places. Here's your question from ServerFault: why-get-smbopenfile-losses-the-lock-when-file-still-opened-at-remote