Unanswered

Checking Sharepoint list daily to see if create date is 7 days ago and a field is blank

(0) Share

Report

Posted on by FinancialCoach

I want to check a sharepoint list daily to see if the "coach assigned" column is still blank after 7 days - I figured out the recurrence but I'm struggling with the trigger that will just check the list. It may or may not have records added or modified. How do I trigger Flow to just check 2 conditions on a Sharepoint list daily? The 2 conditions will be: is create date 7 days ago AND is coach assigned field blank. both have to be true and then I want to send an email letting the list admin know so she can follow up

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yamao-msft on at

Like (0)

Report
Hi FinancialCoach,

Say you have a Date column(Date only) for Create Date, and a Person column for Coach assigned.

Then you may consider to use workflow definition language for the condition to check if the create date is 7 days ago and coach assigned column is still blank.

You may configure the Condition to something likes below:

@And( equals(items('Apply_to_each')?['Date'], formatDateTime(adddays(utcnow(),-7),'yyyy-MM-dd')), not(empty(items('Apply_to_each')?['Manager']?['DisplayName'])) )

The flow configuration for your reference, you could modify the frequency of the Recurrence to 1 day, then it will be triggered every day:

The doc for workflow definition language for your reference:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,
Mabel Mao

Was this reply helpful? Yes No
FinancialCoach 4 on at

Like (1)

Report

Mabel,

thanks so much for the guidance - I've taken the code and repalce 'Manager' with 'Assigned' and am getting this error message: The template validation failed: 'The inputs of template action 'Condition' at line '1 and column '1463' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Condition' to be referenced by 'repeatItems' or 'items' functions.'.

Any ideas? this is my code now:
@And(
equals(items('Apply_to_each')?['Date'], formatDateTime(adddays(utcnow(),-7),'yyyy-MM-dd')),
not(empty(items('Apply_to_each')?['Assigned']?['DisplayName']))
)

I do need to note that my coach assigned field is a choice field not a person field. There is an assigned date field that I could check for blank in lieu of the coash assigned field in the event a choice field will not work in this flow.

Was this reply helpful? Yes No
gtsmith 18 on at

Like (1)

Report

Hi - I just came across this thread and noticed that your last issue was unresolved. I recently came across the exact same error and managed to fix it so wanted to provide my solution.

In your code, make sure the 'Apply_to_each' field is equal to the name of your Apply to Each action. If you changed the action name or if you have multiple Apply to Each actions in your flow, you will see the "The inputs of template action 'Condition' at line '1 and column '1463' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Condition' to be referenced by 'repeatItems' or 'items' functions.have multiple Apply to each actions" error because your code is unable to reference the correct Apply to Each action.

So make sure the following bold items in your code are the same as the Apply to Each action name you are referencing.

@@And
equals(items('Apply_to_each')?['Date'], formatDateTime(adddays(utcnow(),-7),'yyyy-MM-dd')),
not(empty(items('Apply_to_each')?['Assigned']?['DisplayName']))
)

I hope this helps!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi Guys,

First of all sorry for reporting a issue here but i just joined the flow community and didn't know where to report any issue... so my sincere appologies.
i am also in a same kind of trouble. I have a SharePoint list where we have columns as state, Owner, waiting for, modified date etc...
i was trying to create a flow that if the item is not modified for 2 or 3 days, it will send email to the person in waiting for field.

my issue is first condition is not picking the state values ( closed, open, waiting for approval, rejected etc) and in the second condition where i used the expression addDays(utcNow(), -2) is not working.

i just wanted to have a flow that if a item is not modified for 2 day and the state value is not closed, send an email to the person in waiting for field.

I would be grateful if someone please help me on my issue.

Thanks!

Was this reply helpful? Yes No