Filter array assistance

(0) Share

Report

Posted on by Nickelbox

126

Hello,

I am attempting to email an established email address in a particular row if the below criteria are met:

Date in due date column matches today's date

and

Date in due date column matches today's 8601

This is what I have so far in my filter array

@And(equals(item()?['Daysdiff'], 0),equals(item()?['today8601'], 0))

It doesn't seem to be working. I can provide additional info if needed. Thanks for any assistance.

I have the same question (0)

All responses (12)

Answers (0)

v-bofeng-msft on at

Like (0)

Report

Re: Filter array assistance

Hi @Nickelbox ,

Do you want to filter out records where 'Daysdiff' and 'today8601' both equal to 0? Are 'Daysdiff' and 'today8601' number columns? What is your data source? Is it possible to provide flow and data source screenshots (please mask private information)

Best Regards,

Bof

Was this reply helpful? Yes No
Nickelbox 126 on at

Like (0)

Report

Re: Filter array assistance

I am attempting to email the address listed in the corresponding row in the Email column when the date in the Correction_Due_Date column matches today.

I was having trouble with it emailing every email address in the column instead of just the one in the row corresponding to today's due date so it was suggested to add today's 8601 to further isolate the row. This is what I have so far.

I am fairly new at this and could use the help. Thanks

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Re: Filter array assistance

Hi @Nickelbox ,

Please try:

@equals(startOfDay(item()?['Daysdiff']),startOfDay(utcNow()))

Best Regards,

Bof

Was this reply helpful? Yes No
Nickelbox 126 on at

Like (0)

Report

Re: Filter array assistance

I received this error:

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Re: Filter array assistance

Hi @Nickelbox ,

Please try:

@equals(startOfDay(item()?['The Data Column That You Want To Compare With Today']),startOfDay(utcNow()))

Best Regards,
Bof

Was this reply helpful? Yes No
VictorIvanidze 12,868 on at

Like (0)

Report
Re: Filter array assistance

Try this:

@equals(startOfDay(string(item()?['Daysdiff'])),startOfDay(utcNow()))

Was this reply helpful? Yes No
Nickelbox 126 on at

Like (0)

Report

Re: Filter array assistance

I received the below error when using your suggestion:

Was this reply helpful? Yes No
VictorIvanidze 12,868 on at

Like (0)

Report

Re: Filter array assistance

Please show the output of Select.

Was this reply helpful? Yes No
Nickelbox 126 on at

Like (0)

Report

Re: Filter array assistance

"body": [
        {
            "Correction_Due_Date": "14-02-2023",
            "Info": "2023-02-14T00:00:00.000Z",
            "Daysdiff": 21,
            "JIRA": "TIO-Test99",
            "Email": "",
            "today8601": 44992
        },
        {
            "Correction_Due_Date": "30-12-2022",
            "Info": "2022-12-30T00:00:00.000Z",
            "Daysdiff": 67,
            "JIRA": "TIO-Test1",
            "Email": "",
            "today8601": 44992

Was this reply helpful? Yes No
VictorIvanidze 12,868 on at

Like (0)

Report
Re: Filter array assistance

It seems you're missed }] in the end of this JSON array.

Assuming the JSON array you've provided is in Compose, use something like this to compare Correction_DueDate with today:
@equals(startOfDay(concat(split(outputs('Compose')[0]?['Correction_Due_Date'], '-')[2], '-', split(outputs('Compose')[0]?['Correction_Due_Date'], '-')[1], '-', split(outputs('Compose')[0]?['Correction_Due_Date'], '-')[0], 'Z')), startOfDay(utcNow()))

Was this reply helpful? Yes No