Major version of several sames files

Hi all.
I need that only show me the major versions of following QnA:

q: unique values of (versions of files ((pathnames of files of folders (unique values of pathnames of folders “AppData\Local\Microsoft\Teams\current” of folders of folder “c:\users”)) whose (it as string as lowercase contains “\teams.exe” as lowercase)))
A: 1.1.0.28562
A: 1.2.0.26774
T: 130.201 ms
I: plural version with multiplicity

in this case, only “1.2.0.26774”

I know that this have to be easy but i’m traying do it without results.
Thanks you in advance.

Regards.
Sergio Casado.

You can use Maximum of to get the highest version.

try

q: maximum of unique values of (versions of files ((pathnames of files of folders (unique values of pathnames of folders "AppData\Local\Microsoft\Teams\current" of folders of folder "c:\users")) whose (it as string as lowercase contains "\teams.exe" as lowercase)))

1 Like

This is the answer.
Thanks you so much.