web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Problem to filter by V...

Power Automate

Unanswered

Problem to filter by VersionNumber

(1) Share

Report

Report

Posted on by angelsansev

23

Hello,

I'm trying get files with the {VersionNumber} greater than 5 for example.

the odata filter always show error "Creating query failed.", the VersionNumber property has a special characters "{" and "}".

I have try with _x007bVersionNumber_x007d_ but dont work

somebody can help me?

Regards

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report
Hi @angelsansev,

Can you try the below for the VersionNumber?

OData__UIVersionString gt '5.0'

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (1)

Report

Another option is to use OData__moderationStatus eq 'Approved' if you only want to get major versions of files.

Was this reply helpful? Yes No
angelsansev 23 on at

Like (0)

Report

Thanks guys both works fine.

Regards

Was this reply helpful? Yes No
HKICE 237 on at

Like (0)

Report
I had a SharePoint document library with a File with 8 versions (1.0, 2.0, etc)
This only works in getting the most current version. I cannot get older versions using this.

I tried specifying a particular version using
OData__UIVersionString eq '5.0'
and it returned nothing/empty
Next I tried:
OData__UIVersionString lt '5.0'
and it returned the latest version (for me version 8.0) only

Was this reply helpful? Yes No

Join the conversation