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.