Filtering and display of multiple choice list based on pre-populated value

Question

Hello,
I have this survey123 connect xls form, it has nearest_pipeline name field that display pipeline that is closest to the event_point_point geopoint location and fill dynamically from calculation. I have another field called "Opername" that dynamically display the multiple choice values in appearance column. So here I want to make connection between the values of "nearest_pipeline" and "Opername" that if the value displays in nearest_pipeline, I don't want it to be displayed again but other values in multiple choice list of "Opername".

For eg. If nearest_pipeline box displays "ENBRIDGE" value, I want other choice list except the one displayed in nearest_pipeline box.

I've attached the SurveyTest xlsx file. Looking forward to any help/suggestions in this regard. Thanks!

SurveyTest.xlsx

Amanda__Huber_0-1742924131582.png

KushShah · Answer

Thanks @DougBrowning for the link.

The problem is that both the fields 'nearest_pipeline' and 'Opername' are calculated (one using search expression) dynamically displayed by using distance intersection. Populating the list values in the choice tab filter the value but it doesn't give desired output, I believe.

dougbrowning · Answer

If I am reading this right I think you want Choice Filters  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-p/894046

Hope that helps