Answered

daily update of list items with 'days until due'

(0) Share

Report

Posted on by Community Power Pla...

Suppose I have an MS List of 10 items with 4 columns: title (string), due date (date formatted mm/dd/yyyy), days til due (number), task lead (person name). I want to automate two tasks. One is a daily task, the other is a one-time task:

Daily task:

-for each item in the list, update 'days til due' field (due date minus today) as an integer

One time task:

- for each ‘due date’ subtract 45 days to produce T-45 date

- put placeholder T-45 meeting on Outlook calendar

- send courtesy email to person in the ‘lead’ column as a heads up.

I have reviewed similar topics but I have not found a single coherent explanation of how to do this. When I try dynamic content, the fields I want never seem to be there, and I don't understand the choices that I see.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Hi @Anonymous ,

Your daily task and One-time task should be deployed to two flows.
1. Create a Scheduled flow to run one time each day.
Below is function we will use to calculate days till due. Remember to change time zone to your place.

first(split(dateDifference(formatDateTime(convertFromUtc(utcNow(),'China Standard Time'),'yyyy-MM-dd'),formatDateTime(item()?['Duedate'],'yyyy-MM-dd')),'.'))

2. As for One-time task, advice is to set a manual flow. Below are functions used in my test. You can change time for meeting whenever you like.
addDays(item()?['Duedate'],-45)
startOfDay(outputs('Compose==T-45'))
addHours(startOfDay(outputs('Compose==T-45')),1)

Here are my result:

Best regards,
Wenjuan Zou

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

Like (0)

Report
Thank you Wenjuan Zou. I was on the right track. Your solution seems correct, but I am getting an error:

Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'dateDifference' expects its second parameter to be of type string. The provided value is of type 'Null'.'.

I checked to make sure my second parameter in the dateDifference function (my end date) was a string, but I still get the error. Here is my second parameter:

item()?['T-0'])

Part of my problem is I do not understand that syntax. Since it is already a string in the correct format, I did not think I needed to recast its format. 'T-0' (a string, MM/dd/yyyy) is the name of my due date field

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

Like (0)

Report

By the way, 'T-0' (a string, MM/dd/yyyy) is the name of my due date field

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Hi @Anonymous ,

You may refer to this document to convert your parameter to a string:
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Best regards,
Wenjuan Zou

Was this reply helpful? Yes No