I’m interested to know the best approach to building an auto-complete data entry field that is searching two separate data sources (source A and source B) - but I want remove any redundant data. In other words - the auto-complete shows possible results from both source A & B but any duplicates are removed.
Maybe create a global formula taking the searched string as parameter. The global formula will concatenate, search and eliminate duplicated elements. You can try to use Copilot to generate the formula 
Interesting. I will explore this. I need to better understand global formulas in general anyway.