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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard