Power Platform Community Forum Thread Details

Hello, in a sharepoint list with two columns

example: a column (choice) of status that can change and a column that automatically indicates the date of modification of the status.

I am looking for this operation:

if the item of a column has been in the "quote done" state for more than 7 days, I send a reminder email every week:

trigger conditions: ok @equals (triggerOutputs ()? ['body / Etat2/ Value'], 'Quote done')

get changes for an item or file (property only): sub (int (triggerOutputs ()? ['body / {VersionNumber}']), 1)

condition: and

status has column change is equal true

I block at the YES function.

I want to obtain the date of modification of the state via the history. (see below)

If the date is greater than 7 days.

Send a follow-up email every 7 days.

Categories:

obtain the modification date of an item by the history