I have a Sharepoint Document Library form in my PowerApp. One of the fields is a lookup column to a list with over 5000 records. I need to filter the choices by ID number. I know the lookup returns Value and ID. Not sure how to write this properly. Here is what is in my head. If there is another way to do this just let me know.
Filter(Choices([@'MyList'].columnname), ID > "3000")
If there is either a way to fix my formula or if there is another way limit the number returned just let me know.
Thanks!
