Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Power Automate - Salesforce Connector

(0) ShareShare
ReportReport
Posted on by

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.

  • Keith-Sayer Profile Picture
    Keith-Sayer 48 on at
    Re: Power Automate - Salesforce Connector

    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'

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics