You’re offline. This is a read only version of the page.
40
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
Have you tried formatting it like the example below?
Share
Report
All responses (
Answers (
Filter(Choices(ListName.FieldName); Value = "YOUR_FILTER_VALUE")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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
