How to filter excel array data and send email

[KUMAR_BFL]

I have a collection file which contains 

Loan account no

Customer name

Product Segment

Receipt no

PAID DATE

Paid Amount

Collected by

I am successful in formatting the Paid date as 'dd/MM/yyyy' using adddays('1899-12-30',int(item()['PAID DATE']),'dd-MM-yyyy')

but further i want to filter Paid date column to only current month which is April. Please find herewith the flow. When i try to insert it between select and create html table step, I am getting error. 

Error: The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@contains(adddays('1899-12-30', int(item()['PAID DATE']), 'dd-MM-yyyy'), 'utcNow(''MM'')')' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Detailed Process:

In below i am using above adddays('1899-12-30',int(item()['PAID DATE']),'dd-MM-yyyy') criteria to check whether date contains any current month payment details. Here i am getting an issue. 

Below compose step is just formatting table code. 

Please help how to correct filter step. 

[v-duann-msft]

Hi @KUMAR_BFL 

Thank you for posting.

According to your description, you would like to find out the related records from excel based on date. If any misunderstanding, please kindly let me know.

Here is my excel:

I simplified part of your steps for data filtering. Flow overview:

Expressions:

formatDateTime(addDays('1899-12-31', int(item()?['Contract End Date'])), 'yyyy-MM')

formatDateTime(utcNow(),'yyyy-MM')

formatDateTime(addDays('1899-12-31', int(item()?['Contract End Date'])), 'yyyy-MM-dd')

Once tested, I’m able to get records in this month.

Hope the content above may help you.

Best regards,

Anna

[KUMAR_BFL]

Thanks for correcting the expression. I replicated the expression in my flow and able to get the expected results. 

but i am not able to fetch other columns in create html table. I am wondering how did you get the contract name column in purple (highlighted below)

In my case column names are listed under "List rows present in a table'. If i select the column names, then apply to each step is automatically applied. I don't know how to get columns names from the filtered current month output. 

[v-duann-msft · Accepted solution]

Hi @KUMAR_BFL 

Thank you for your quick reply.

You can't directly select it from the dynamic list. Please input item()?['column name'] one bye one manually.

Hope it helps.

Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Best regards,

Anna

[KUMAR_BFL]

Thank you very much. Its now 100% working. 

[KUMAR_BFL]

Just a small correction in expressions - ('1899-12-31' should be '1899-12-30') to get correct results. 

Expressions:

formatDateTime(addDays('1899-12-30', int(item()?['Contract End Date'])), 'yyyy-MM')

formatDateTime(utcNow(),'yyyy-MM')

formatDateTime(addDays('1899-12-30', int(item()?['Contract End Date'])), 'yyyy-MM-dd')

[tom2623]

Could you help me please? I have the same task, but html show me formula which I entered .