CODEWITHSUNDEEP
salesforceazure-logic-apps
Steve Moro
Steve Moro

Reputation: 93

How to use a Salesforce Connector on Azure Logic App to get Change Record using a dynamic filter query

I have a logic App which starts with a Salesforce Trigger where it checks for Account updates. I want only records where createdate is >= today-20days.

enter image description here

 "queries": {
                        "$filter": "CreateDate ge '@{formatDateTime(addDays(utcNow(), -20), 'yyyy-MM-dd')}'"

If I enable this filter I do not get any records. If I delete this filter I get records where CreateDate is more than 20 days ago which I want to filter.

Upvotes: 0

Views: 781

Answers (1)

SwethaKandikonda
SwethaKandikonda

Reputation: 8252

After reproducing from my end, I can see that the mentioned filter is working fine.

I used the same query provided by you. enter image description here

queries": {
"$filter": "CreateDate ge '@{formatDateTime(addDays(utcNow(), -20), 'yyyy-MM-dd')}'"
}

Results:

enter image description here

If I enable this filter I do not get any records.

The above expression retrieves the results of records that are 20 days ago. Since, you aren't receiving any data or error, that indicates there are no records that are in the last 20 days.

Upvotes: 1

Related Questions