Filter html table where date should be equal to current date

(0) Share

Report

Posted on by Ashish2605

Hi,

I have created a flow where it will list rows from excel table, select columns 'LoggedinDate' & 'DeveloperName'.

Next, I have used compose, where I used 'union' function so that I get only unique rows. Now, from the output of this compose data operation, I want to filter out 'LoggedinDate' property value which equals to Current date in format mm/dd/yyyy, and print the html table for that date only - pls see red highlighted box. I am not able to filter out this.

How do i use filter array, before html table operation, in this?

Kindly help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Ashish2605

As per my understanding, you want to filter the column "LoggedinDate" with the current date (today). For that, you can use 'Filter array' action, iterate through the output of 'Select' action and compare the "LoggedinDate" with the current date.
Please refer the below screenshot:

here, "From" with the output of 'Select' action and add the below condition to filter:
@equals(item()?['LoggedinDate'], formatDateTime(utcNow(), 'MM/dd/yyyy'))
Note: the above expression will be added using "Edit in advanced mode"
Post filtering, you can create a html table with the result obtained from 'Filter array' action.

Please let me know in case of any problem & remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
Ashish2605 27 on at

Like (0)

Report

Thank you! It worked, appreciate your prompt response!

Was this reply helpful? Yes No