function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jiahao Zheng 33Jiahao Zheng 33 

Need help to design this flow

Hello Salesforce developers, 

I have a parent object (Renewal Applications) and a child object (Renewal Details). This child object has a lookup field to the Product object. I wanted to create an automation to achieve: 

1. Get a Renewal Application record where the "Company" field is not null 
2. Find all Product records with the same "Company" field 
3. Add all these Product records to the Renewal Details object. 

Is that something we could accomplish using Flows? I attach chart here to help understand the object relationship. Thank you all very much! User-added image
AnudeepAnudeep (Salesforce Developers) 
You can fetch parent records in a flow using GetRecords element so it is possible to achieve what you are looking for through flow

I suggest reviewing this blog post for setting up the flow

You can create a Salesforce record as well in flows

Let me know if this helps, if it does, please close the query by marking it as solved. It may help others in the community. Thank You!
RituSharmaRituSharma
Yes, you may achieve it using flows. It gives you flexibility to loop on the records and do bulk DMLs. Refer the URL to get overview of flow operations -> https://help.salesforce.com/articleView?id=flow_build_data_create.htm&type=5