
I need to create a flow on Power Automate that needs fields from two different objects on Salesforce, includes conditions, and adds the SF records that meet the criteria to a SharePoint List.
I believe the steps should be a flow that somehow:
How should I do that?
I appreciate any feedback.
While you can run SOQL queries you can't run child queries. That means you have to query each object separately, and then do an intersection on the result arrays.