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 Apps
Unanswered

Edit Form Filter

(0) ShareShare
ReportReport
Posted on by 46

Hello Community.

 

i got an edit form connected to a sharepoint list containing a Choice column. I'd like to filter the Dropdown in the edit form, which got the items "Choices([@'Maschinen Glasfertigung'].Maschinenart)". Here i'm having trouble. When i try to use a regular filter expression with expressions containing [@something] i can't figure out the correct syntax. i tried to use a workaround by using a simple Filter formula directly getting the required items from the database without using the Choices function, but in this case i get an error when i try to submit the form saying somthing like "given datasource is invalid for the function". By now all i can think of is not using the form at all anymore and using Patch() instead which is quiet annoying. 

 

Do you guys have any solution for that matter? Help is much appreciated

Categories:
I have the same question (0)
  • VishalJhaveri Profile Picture
    1,167 Moderator on at

    Patch function will help you to achieve this kind of dynamic requirements.
    Refer this Blog: Master CRUD Operations in Power Apps : Part 4 (inkeysolutions.com) to achieve your requirements. 

    This is a blog from a 5 part blog series of using PATCH function in Power Apps with SharePoint as backend.

  • Kai Adler Profile Picture
    46 on at

    Thanks for the reply @VishalJhaveri. Do i read that correctly as "doesn't work with edit forms, use patch() instead"? For now i can't imagine that something that simple like filtering in an edit form is not possible.

  • Fredrik_A Profile Picture
    3,482 Super User 2026 Season 1 on at

    Have you tried formatting it like the example below?

    Filter(Choices(ListName.FieldName); Value = "YOUR_FILTER_VALUE")
  • Kai Adler Profile Picture
    46 on at

    @StretchFredrik: same error message as mentioned in my first post

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 Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard