Unanswered

Edit Form Filter

(0) Share

Report

Posted on by Kai Adler

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

VishalJhaveri 1,167 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kai Adler 46 on at

Like (1)

Report

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.

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

Like (0)

Report
Have you tried formatting it like the example below?

Filter(Choices(ListName.FieldName); Value = "YOUR_FILTER_VALUE")

Was this reply helpful? Yes No
Kai Adler 46 on at

Like (0)

Report

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

Was this reply helpful? Yes No