You need to sign in to do that
Don't have an account?
OlavoZapata
Fast lookup distinct records on Flow Design
Hi guys,
I'm trying to create a flow based in a fast lookup + Loop + assigment (sum value) + load back to the object.
But on my Fast lookup it brings me same records duplicated because I'm looking in an object with Date identifier. So, sometimes the ID get repeated but in a different date.
I would like to know if there is a way to get just the Distinct ID from that month per example or how could you suggest me to do?
Thanks.
I'm trying to create a flow based in a fast lookup + Loop + assigment (sum value) + load back to the object.
But on my Fast lookup it brings me same records duplicated because I'm looking in an object with Date identifier. So, sometimes the ID get repeated but in a different date.
I would like to know if there is a way to get just the Distinct ID from that month per example or how could you suggest me to do?
Thanks.
In fast lookup, you can able to use the AND. OR condition on filtering ?? will that won't work ??
Yeah, I mean unique values from the select.
But on fast lookup flow I'm not able to config filter logic. It is always AND (in specific cases of the same field it automatically change for OR).
But there is no unique operator or I don't know how to use. (I didn't find anything related to this).
Bests,
Hi Lily,
Yes, I found. Actually is kind of simple I just didn't think it before post here.
What you need to do is make a previews step that filter in a collector the last reference period and after another fastlookup that match with the record that you want.
Bests,
This is actually a day by day problem with Salesforce, it's not possible to do an INNER Join between objects or group in Flow.
I think you can do in this case is.
1. Instead, use get records to look to opportunity use it to look to Accounts.
2. On Accounts create a field that counts opportunities with the match that you want.
3. At the Flow you can filter based on that field.
I hope it helps you.