"Disjunctions not supported" - Why Custom Metadata and Flow Don't Mix
Error Occurred: This error occurred when the flow tried to look up records: Disjunctions not supported.
When you define multiple filters, the filter logic usually defaults to AND. However, if multiple filters have the same field selected and use the equals operator, the filters are combined with OR.
In other words, when multiple records go through the Flow in a transaction, the system will combine your queries into a single query behind the scenes, and when it does that, it likes to use "OR".
When this happens, you have a few options.
- Use a non-metadata type to store your data - a regular custom object, in other words. But this has a lot of drawbacks such as security and portability.
- Code it.