Skip to main content

Notifications

Power Automate - Building Flows
Answered

Filter Dataverse List Rows by date

(0) ShareShare
ReportReport
Posted on by 6
Hi everyone,
 
My ultimate goal is to filter a column from Dataverse and push that data somewhere else.
 
This is a screenshot of the columns from Dynamics in Dataverse. I would like to filter just the "Last Visit" column to include only the last7 days.
 
 
 
 
It isn't much, but currently my flow looks like this. I added the 50-row count to limit this for testing purposes because we have too many rows and would take too long each test.
 
 
 
I can get the flow to work by equaling the string to an exact date string that is in the data below, but I need help using the correct syntax so the flow filters automatically.
 
Here is an highlight of the last visit of the "list rows" output.
 
I have tried many different expressions to filter the "Last Visit" column but am missing something. Any help is greatly appreciated.
  • AS-13011808-0 Profile Picture
    AS-13011808-0 6 on at
    Filter by date
    Thank you, David! I was able to get to the next step with that information. Much appreciated!
  • Verified answer
    David_MA Profile Picture
    David_MA 8,929 on at
    Filter by date
    If you need to filter the data, you should do that in the List rows action using filter rows. It is more efficient to do this when you get the data than afterward. Here is an example for getting the most recent approvals submitted to the approvals table:
    Filters need to use the ISO8601 date format. The expression for the date in the filter is addDays(utcNow(),-7) which would then return anything created more than seven days ago. As you can see, I have an additional filter to only return items where the source is not null.
     
    Be sure to use the logical name for the columns, which you can get if you open the table, choose the field, and check its advanced options. As you can see, the logical name for the Created On field is createdon. In the action, the values are case sensitive.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard