How to filter "Multi table" lookup field via JavaScript in MDA

(0) Share

Report

Posted on by ThareLyn

Hi,

I tried to use the addCustomFilter but it is not working.

No error being thrown, but when you click on the lookup field it will says the you have a invalid XML format

I am confident that my XML is correct. So my suspicion is that this error is being thrown because there are multiple tables inside the look-up field.

I tried to search about javascript filter to a multi-table lookup field but I can't find anything helpful on the internet.

Does anyone know how to do this? Thank you very much

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Guido Preite 1,490 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

the code looks correct (I assume the rest of the code will show the closing of the presearch function).
Personally I would try 2 things:
1) convert the addCustomFilter row inside a separate function and call the named function inside your presearch (probably you get the same error but it's an easy test)
2) create a normal lookup pointing just to account and change the code to point to the new lookup, if you don't get an error means that there is a bug inside the platform (you didn't specify if this multi-table lookup is a Customer or a Polymorphic one) and you can open a ticket to MS support
also make sure your xml is in a single line, the encoding of new line can eventually mess up (you can test it together with number 1)
hope it helps

Was this reply helpful? Yes No
Diana Birkelbach 3,072 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ThareLyn ,

I might be wrong, but I have the strong feeling that in your fetchXml, between operator='eq' and value='77...' there is a space (blank) missing.

Was this reply helpful? Yes No