web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Generating a HTML Tabl...

Power Automate - Building Flows

Unanswered

Generating a HTML Table to Email Filtering Out Dates

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi there,

I've generated a HTML table to email notification from a Sharepoint list. But I want it to do three things;

1) Filter by date so date closest to today is at the top

2) Change the date format to UK standard

3) Filter out any entries that are in that past

End result, which is fine and acceptable but I can't figure out the three changes above.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: Generating a HTML Table to Email Filtering Out Dates

@Anonymous

1) Filter by date so date closest to today is at the top: I believe you mean sort by date

on the Get Items you can use the order by property as

Created desc

2) Change the date format to UK standard

You can use the convert Action as below

3) Filter out any entries that are in that past

To filter out entries you can use the Filter Query something like below

Created gt '2021-01-01'

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Generating a HTML Table to Email Filtering Out Dates

Hi Mira,

Sorry I'm new to flow. I don't understand.

Point 1 I've added but nothing is happening?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans