Based on my knowledge and searching, I believe the answer to this question is no, but if someone can show otherwise, that'd be much appreciated.
I'm wondering if there's any way currently within ArcGIS Online to dynamically filter records (or query, or whatever language you wish to use) within one point layer based on whether or not those points fall within another polygon layer, also on the same map?
Seems like Arcade gets close, but we can't quite get there: the standard filter function in a webmap doesn't allow me to draw on the Attribute Expressions I define in the Attribute Expressions I created within the Configure Pop-Up window.
If the answer is indeed this cannot be done now in AGO, what is the next best way to approach this? To have a model that runs at routine intervals (ie daily) on an in-house server, and then draw on those layers in my webmap?
The short answer is "no", there's no off-the-shelf means of doing this. However, I could see the following method working:
Scheduling the script to run at regular intervals would keep the field up-to-date, and then the view layer can be filtered to keep out non-intersected points, i.e., those with null values in the new field.
It's not the best or most direct method, but it would work. I should say that this is specific to hosted layers. Are either of the layers on an enterprise geodatabase by chance? There are more effective means of doing this if so.