You need to sign in to do that
Don't have an account?
Aidel Bruck
How to filter a collection in a flow based on another collection
I have a collection of a custom object 'payments' that stores all the payments with a certain status.
Then these payments are displayed in a datatable and users can select multiple payments.
As a result I now have another collection with the selected record Ids.
How can I get a third collection of only payments with Ids that do not appear in the selected collection without using multiple loops- I keep on hitting limits.
I tried creating an apex class but it seems like invocable methods cannot get and return lists.
Then these payments are displayed in a datatable and users can select multiple payments.
As a result I now have another collection with the selected record Ids.
How can I get a third collection of only payments with Ids that do not appear in the selected collection without using multiple loops- I keep on hitting limits.
I tried creating an apex class but it seems like invocable methods cannot get and return lists.
John Hillstrom
Winter 23 supports this using the IN operator. Use In and Not In Operators in Flows to Find Related Records (salesforce.com) https://help.salesforce.com/s/articleView?id=release-notes.rn_automate_flow_builder_in_notnot_operators.htm&release=240&type=5 (https://help.salesforce.com/s/articleView?id=release-notes.rn_automate_flow_builder_in_notnot_operators.htm&release=240&type=5)