Did you figure this out? If yes, please post your solution here. Thanks in advance.

Thanks @Kurt_Jones for the detailed explanation. This does shed some light onto my problem but not fully. The field I am querying is Project Name and not a Dropdown Field Option Value and so it is not possible for me to write calculated logic for individual items. But with your answer I will try to ...

I am trying to fetch the Program associated to a Project. The Project is selected using a typeahead and the name of the Project is used in the URL to fetch the associated Program. The issue is that the External Lookup field is not returning any value when the Project name has special characters. Thi...