
Hi @Dsa2,
I would suggest to have a look at Power Apps instead. You want to filter on the input side of things, you can use a Power Apps forms customisation for this.
There is a lot of great content on this kind of filtering online. I would recommend taking a look at one of Shane Young's videos: PowerApps set default value based on another field from a dropdown, https://www.youtube.com/watch?v=1Q8L2H8cpEo