Unanswered

Triggering Flow when record in dataverse not modified for x days

(0) Share

Report

Posted on by Ashers82

Hi All,

I am trying to send an email when a record in Dataverse hasn't been modified for 3 days and then an escalation email at 7 days.

I can understand how to do it should the data source have been Sharepoint "Get Items" but struggling to know which Action to use, and how, for Dataverse.

Any help would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

mjburley 370 on at

Like (0)

Report

There's no trigger for nothing happened, so you could run a scheduled flow that runs every day, and it lists rows on the required table with a filter of modifiedon > 3 days and < 4 days which will produce a list of those last modified 3 days ago.

Filter would be something like
modifiedon gt var3DaysAgo and lt var4DaysAgo

where the var4DaysAgo would be like:
concat(formatDateTime(adddays(utcNow(),mul(variables('Days'),-4)), 'yyyy-MM-dd'),'T00:00:00Z').

Hope that makes a modicum of sense !

Was this reply helpful? Yes No
Ashers82 12 on at

Like (0)

Report
This isn't working for me. What do I put
concat(formatDateTime(adddays(utcNow(),mul(variables('Days'),-4)), 'yyyy-MM-dd'),'T00:00:00Z')
in please?
I either can't save or I try and use something like
modifiedon le @{addDays(utcNow(), -3)}
which gives me the following error...
' should be in format 'yyyy-mm-ddThh:mm:ss('.'s+)?(zzzzzz)?' and each field value is within valid range.

Was this reply helpful? Yes No
mjburley 370 on at

Like (0)

Report

Sorry, I just copied some code I had and pasted it, not realising there was a variable (Days) in there.
Try this,

where Compose 3 days is :
concat(formatDateTime(adddays(utcNow(),mul(3,-1)), 'yyyy-MM-dd'),'T00:00:00Z')

and compose 4 days is :
concat(formatDateTime(adddays(utcNow(), mul(4, -1)), 'yyyy-MM-dd'), 'T00:00:00Z')

Was this reply helpful? Yes No