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
Øyvind Borgersen 10Øyvind Borgersen 10 

FLOW - Soql

Hi,

I working with lightning flow and needs to run a SOQL with IN clause. Does anyone have an apex sample to be used in flow which can use a variable flow the flow and return a collection to be used as a picklist?
 
AbhishekAbhishek (Salesforce Developers) 
https://forcepanda.wordpress.com/2019/05/07/workaround-for-in-clause-in-flows/

Try this it might help you.

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

Thanks.
Øyvind Borgersen 10Øyvind Borgersen 10
HI Abishek, 

Thanks, but this does not quite solve it. We have a more complex scenario where we need to use extensive query where a apex class should be able to cover this. Also we need to have the results populated as a picklist.
AbhishekAbhishek (Salesforce Developers) 
It's complete customization.

Apologies I don't have a code snippet or developer discussion to fulfill it.

 
Kyle DudleyKyle Dudley
The Execute SOQL component in this package will run any valid SOQL query that can be run in apex.
https://unofficialsf.com/tutorial-schedule-a-flow-to-delete-old-files-contentdocuments-featuring-new-addquotestofields-action-executesoql-and-extractstringsfromcollection-v2/