
Filter(Choices([@'Table1'].'SubmitttedUser'),'User Type'="Member")
This formula filters the list to show only those with the 'User Type' equal to "Member". However, there is still a lot of noise, and I would like to add an additional criterion to filter out everything that ends with "@gmail.com".Filter(Choices([@'Table1'].'SubmitttedUser'),'User Type'="Member", "@gmail.com" in 'Email Field', Status = "Open")
If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!