web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ODATA Filter help needed
Power Automate
Unanswered

ODATA Filter help needed

(0) ShareShare
ReportReport
Posted on by 1

Hi team,

 

I have two column in a SharePoint list (Last Maintenance & Current KM) which not a calculated columns.

i need to filter this list by these two columns like what i mention below,

 

((Last Maintenance +10000) - (Current KM)) le 1500

or
(Current KM +2000) gt (last Maintenance + 10000)

 

I just need to add this filter to let the flow send an email with the filtered items which will be the vehicles that needed to be maintained.

Categories:
I have the same question (0)
  • manuelstgomes Profile Picture
    6,625 on at

    Hi @Essam 

     

    In SharePoint I don't think that's supported:

    Screenshot 2021-03-29 at 14.41.16.png

    You can do comparisons but math operations are not supported according to the documentation.

    https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests

     

    Cheers
    Manuel

    -------------------------------------------------------------------------
    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard