Power Platform Community Forum Thread Details

Hi all

I have to Sharepoint lists: 1 with Complaints an another with the status of the complaints. Both lists contain an Complaint-ID.

Status can be "Registered", "Action due", " Action taken" ,"Closed". In the status list there can be several statusses for one Complaint-ID.

Now i want to send an email if an action hasnt been taken (Status= " Action due") within a week. Tried to get the items from the status and detect if the given status is not present , but i cant get it working.

Any help would be very much appreciated.

Huub Keulartz

Categories:

Building flows

Hi @Huub100759,

Could you please share a screenshot of your flow's configuration (via uploading screenshot or providing a link about the flow screenshot)?

Could you please show a bit more about the Status column in your Status list?

Further, could you please share more details about your two SharePoint lists?

I have created a Status SharePoint list on my side and the data structure of it as below:

Note: The Cmplaint-ID column is a Single line of text type column. The Status column is a Choice type column and available values of it are "Registered", "Action due", " Action taken" and "Closed".

I have made a test on my side and please take a try with the following workaround:

Add a "Recurrence" trigger, Interval set to 1 and Frequency set to Week.
Add a "Get items" action, specify Site Address and List Name.
Add a "Apply to each", input parameter set to output of "Get items" action.
Within "Apply to each" action, add a Condition, click "Edit in advanced mode", type the following formula:

@and(lessOrEquals(formatDateTime(addDays(items('Apply_to_each')?['Modified'], 7), 'MM/dd/yyyy'), utcNow('MM/dd/yyyy')),not(equals(items('Apply_to_each')?['Status']?['Value'], 'Action due')))

Within "If/yes" branch of Condition, add a "Send an email" action.

Image reference: