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:

here is my progress ...

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

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

condition:
and
status column is equal true

I block at the YES function.
I want to obtain the date of modification of the state via the history.

If the date is greater than 7 days.
Send a follow-up email every 7 days.

Categories:

item date modificated on list sharepoint