I am trying to set up a flow to send an email to newsletter subscribers in a custom object (Newsletter) filtered by industry.
Currently industry is a picklist field, not a multi-select picklist, though I could change that if it would somehow circumvent the problem I have outlined below.
I set up a screen at the beginning of the flow for recipient selection. It displays a checkbox group allowing the user to select multiple industries. It outputs to a screen component (Choose_recipient_by_industry).
The next step in the flow is Get Records, which is currently set up to filter Newsletter records by CONTAINS Choose_recipient_by_industry. This works perfectly when only one selection is made. When two or more boxes are selected, the flow results in an error.
I am well aware that this error is due to the limitations of the CONTAINS operator, which will only filter for records that contain all of the selected industries. This would still be a problem if I changed industry to a multi-select picklist.
What is the simplest way to set up this functionality?