Filter by date being sent in quotes

(0) Share

Report

Posted on by nksse

Hi all

I'm using the Salesforce connector to display data in a Canvas App. We have thousands of records, but I only need to work with any modified in the last seven days. To avoid delegation, I've got this function, which filters from the Grants Salesforce Table:

UpdateContext(
    {
        newGrants: Filter(
            Grants,
            'Last Modified Date' >= DateAdd(
                Today(),
                -7,
                TimeUnit.Days
            )
        )
    }
);

But it is getting this error:

Salesforce failed to complete task: Message: wrdd_Dt__c FROM Grant__c WHERE (LastModifiedDate >= '2024-03-18T00:00:00.000Z') ^ ERROR at Row:1:Column:2032 value of filter criterion for field 'LastModifiedDate' must be of type dateTime and should not be enclosed in quotes

I've also tried enclosing the DateAdd in DateValue and DateTimeValue functions with no avail...

Can anyone shed some light on how I can filter by date?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@nksse -

Have you considered removing the single quotes with Substitute prior to running the DateValue function? E.g.

UpdateContext( { newGrants: Filter( Grants, DateValue( Substitute( 'Last Modified Date', "'", "" ) ) >= DateAdd( Today(), -7, TimeUnit.Days ) ) } )

Was this reply helpful? Yes No