I'm trying to run a Visual Flow in Salesforce that runs through all of a custom objects records called Cross Sells (~1,000,000 records) and updates a lookup field. This flow is failing due to the query being great than 50k records.
I have looked online but have been unable to come up with a clear answer. Some forums have advised using the 'Wait' element, others have advised that the Visual Flow can bulkify requests. My current Flow is using a Fast Lookup to create a list of the all the Cross Sell records, and then passing it through a Loop element.
Any advice on how I may be able to structure this visual flow to manage a large dataset would be much appreciated.