Filter Dataverse List Rows by date

(0) Share

Report

Posted on by AS-13011808-0

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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
AS-13011808-0 6 on at

Like (0)

Report

Thank you, David! I was able to get to the next step with that information. Much appreciated!

Was this reply helpful? Yes No