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 Apps / ODATA syntex for a pow...
Power Apps
Unanswered

ODATA syntex for a power Automate

(0) ShareShare
ReportReport
Posted on by 418

No idea if this is the correct place to post this.  I work with powerApps.  I have to get a subset of records from a sharepoint list.  Due to delegation in PowerApps, I know I can't do this with native filter/search functions.  I think I can create a Power Automate that takes one input from the user/powerapps and gets the filters list.  

 

I can't for the life of me figure out how to write the ODATA query.   I can't find anything useful by microsoft on this topic.  I want filter on the column "Title" where the end of the string matches the user input.  Thanks.  

Categories:
I have the same question (0)
  • SJ-15052312-0 Profile Picture
    418 on at

    Man I feel like I only run into limitations working with power Apps...  Thanks for the response.  The list can be very large, I would expect a filter array step would take too much time iterating over each record.  If the ODATA Filter query can I used contains?  I've tried writing this in ODATA syntax but can't get it to work.  

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 421

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 278 Super User 2026 Season 1

Last 30 days Overall leaderboard