Power Platform Community Forum Thread Details

Hello, We are trying to use the salesforce connector within power automate. Is it possible to get any records from salesforce where the date is equal to today's date? We've tried using various expressions but can't get it to work.

Categories:

Using connectors

I don't have access to a Salesforce sandbox, but I've done something very similar in Business Central. I think the key is going to be the "Get Records" action and then you will have to write an OData expression to filter records returned.

Check out the documentation on this action: Salesforce - Connectors | Microsoft Learn

Tips: you can get the current date/time using the expression utcnow()
You will likely need to format it to match the way Salesforce stores the date. That might take a little research. One easy way to figure that out is to run your flow with no filter and see what you get back in the flow test results.
You'll need to know the internal name of the date column that Salesforce returns. Again, don't have access, so can't say for sure. You can get this from running the request with no filters also.
Then your ODATA filter should look something like this:

SALESFORCEDATECOLUMNNAME eq 'CORRECTLYFORMATEDDATETIME'