Answered

Update Overdue Task List

(0) Share

Report

Posted on by mhtedford

I have a SharePoint Online task list, and I want to update a field called "Task Progress" if tasks are overdue: http://imgur.com/a/0G5It

I have developed a Flow that will update this task list: http://imgur.com/a/c3Ux9

However, when my Flow runs, the logic returns false, even if the tasks are overdue, and the task list is not updated: http://imgur.com/a/PCP4z

Please advise. Cheers!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

v-micsh-msft on at

Like (1)

Report
Copy link

Link copied!
Hi @mhtedford,

I think the issue here should be caused by the Due Date condition.

Please click the advanced mode of the Due Date condition, if possible, share a screenshot about that.

Modifying the formula into the following format should make it work:

@lesstOrEquals(formatDateTime(item()?['Due_x0020_Date'],'yyyy-MM-dd'), utcnow('yyyy-MM-dd'))

I saw the screenshot under the Compose Action, AddDays function adds 0 to UTCNow(), if you would like to just format the current Date, then we could take use of UTCNow('Format')

Besides, The formula I shared above may not show the proper Due Date content, make sure the Due Date part matches.

Check to see if this would make it work.

Function reference:

Workflow Definition Language

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

mhtedford 10 on at

Like (0)

Report
Copy link

Link copied!

@v-micsh-msft
Michael,

I input your logic into my Due Date condition, as you can see here: http://imgur.com/a/IsDoi

However, when I run my flow, I receive this error:
Unable to process template language expressions for action 'Check_Past_Due_Date_Condition' at line '1' and column '2051': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Here is a picture of the error within my flow management: http://imgur.com/a/v31tW

Cheers!

Was this reply helpful? Yes No