How and where to use Collection Filter in Flow with example

[@Subhodsf]

Very well explained Pratima. Not only for the collection filter, why and when we should use the loop and assignment elements- that part was great. Thank you and keep going.

[@ImNotUrKind]

Your video was really helpful. Thank you so much, Pratima!

[@VishalSharma-lo5ol]

Great Content, Thankyou ! I always dreaded Flows, these tutorials are helping me very much.

[@PratimaShri]

Glad to hear that! Let me know if there are other topics that can be helpful for a beginner.

[@ndf731]

Ty, didnt know that i have to deal with filter like a collection.

[@IgorBertelli-y2b]

If I filter for only one record specifically, am I able to access it directly, or do I still need to create a Loop element?

[@DavidStella]

It seems silly, but the answer is yes. You'd have to iterate the item through a Loop element to access the filtered record.

[@IgorBertelli-y2b]

@@DavidStella Thanks

[@annjo2371]

Hi Pratima - I have a CollectionFilter that filters out 1 specific record each time (inside a loop) - that I then assign as a value for the CurrentLoopItem (LookupObject__c = currentItem_filterObject>recordID) OR CurrentLoopItem (LookupObject = varID [ varID = currentItem_FilterObject>recordID] but debug always says that its NULL even though there is a record. What is the correct way to do this?

[@hetilemabunda9705]

Did you figure this out? Having the same problem

[@ronrocksall]

Thank you for the video. I just want to check is there anyway we can send email to user from parent role whenever user is inactive. Like I want to send email with list of opportunity (open) when opportunity owner is inactive to their manager but this needs to be user from parent role (and not Manager field). Also need to send email with list of opportunity or report not per record. Do you have any idea how can we send email to user from parent role?

[@lizflynn9957]

Hi Pratima, I have created a custom object that creates a record when a contact has MQL timestamp field filled. This works moving forward, but I need to collect all contacts that already have this field populated and do a one time multi record creation from this collection. Do you have a video I can follow for this use case?

[@sarabjeetsingh8178]

Hi Pratima, how to check if the filtered list is null or not without loop on filter? Standard way of (ISNULL equal FALSE) doesn't work on the filter element list. Thanks

[@PratimaShri]

That’s interesting … so you are saying that using isnull decision doesn’t work on filtered list? I would try other functions like the size of the list.. I will need to check in my org.

[@mathewap2704]

Hey Pratima, Good lectures as always! I have a question. For Get Element optimization, is it better to use more than one Get Element with specific filters on an object in flow, or use just one Get Element of all records, or with filter and then loop through that one Get element to get the specific record value to update the field? I find it easy to use several Get Element from an object with specfic filter on each, but wanted to understand the difference, as Loop is not my favorite! Appreciate your expert advice. Thanks

[@PratimaShri]

Hey! I definetly don’t recommend getting all records with a get records because you may run into issues if you are expecting a lot of records back. I think it depends on your scenario and in total how many get you are using for the entire process. Know that all the automations that get fired on an update or Insert and all gets in that transaction count against that limit. So if you have 2 get with specific condition to get desired result that’s better than querying all the records and using loop. But if you are going to do get for 150 different variations that’s not good. I would also suggest loooking into filter element. It was introduced after this video I think. But filter let’s you filter form a collection without looping through.

[@mathewap2704]

@@PratimaShri - Thank you so much. I was of the same approach as you suggested above, but read elsewhere using less DML operations in Flow not to hit the limit. Since I have only 4 filtered Get records from 2 each objects, I think I am okay, and will not hit the limit. Thanks again, and appreciate your quick and expert advise. You are a great help. Best.

[@irenegds]

unable to fetch date field in the assignemnet. Any idea on how to handle that?