New Scheduled Flow error

(0) Share

Report

Posted on by sutekh

509

Afternoon all

Thanks to @Rob Elliott and this thread. I managed to get a scheduled flow working. I've tried to repeat this for a library and I'm getting an error.

It's basically the requirement I'm trying to repeat. A document is added with an Expiry Date. If it's within 30 days and email gets shot off and the status gets changed to amber and 'Will Expire' after the 30 days an email gets fired off and the status gets changed to 'Expired'.

I thought it would be fairly simply, but....

I think it's down to the Compose Review Date Action:

The Compose Day expression is:

formatDateTime(utcNow(),'yyyy-MM-dd')

Here's the Compose Expiry Date action: Compose ExpiryDate.png

If set the Condition to 'Compose' Day' is less than or equal to ' Compose Review Date' I get hundreds of emails. If I set it to equals I get the error below after about 7 minutes.

I checked the values that Compse Day and Compare Review Date were bringing back and I get:

Compose Day: 2020-02-10

Compre Review Date: 2020-11-06T00:00:00.0000000

So I guess that the problem is that I'm not getting the correct value in the Compre Review Date Value?

All help apprteciated

Is Equal To Error
Unable to process template language expressions in action 'Compose_ReviewDate' inputs at line '1' and column '2803': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#adddays for usage details.'.

Categories:

General topics

All responses (12)

Answers (0)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

hi @darrenfloyd666 cloud you give us the output from Compose Expiry Date?
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @darrenfloyd666
I hope this POC helps you out.

Additionally you can have the Update Item, action to change the field to "Expired" or anything you want. Do this in the if yes shape.

Regards.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
sutekh 509 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I changed it around as your POC and I get the same results.

With this condition I just get a ton of emails.

Here are some examples of the output which I get on the emails:

Expiry Date:2020-11-15
Compose Day: 2020-02-11
Compre Review Date: 3000-12-01T00:00:00.0000000
Compose Expiry Date: 3000-12-31

Expiry Date:2020-07-15
Compose Day: 2020-02-11
Compre Review Date: 2020-10-15T00:00:00.0000000
Compose Expiry Date: 2020-11-14

Expiry Date:2020-11-29
Compose Day: 2020-02-11
Compre Review Date: 2020-04-12T00:00:00.0000000
Compose Expiry Date: 2020-05-12

Compose Expiry Date just has the Expiry Date field from the Library

Any ideas?
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Try changing the if condition to is equal to.

Thanks

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
sutekh 509 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried that and after four minutes I got the following error on the Compose ReviewDate:

InvalidTemplate. Unable to process template language expressions in action 'Compose_ReviewDate' inputs at line '1' and column '2802': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#adddays for usage details.'.

Help!

@RobElliottany ideas?
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Please post the exact expression that you are using for Compose Review date.

Thanks

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
sutekh 509 on at

Like
a
(0)

Report
Copy link

Link copied!

addDays(outputs('Compose_Expiry_Date'),-30)
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Please try and use the expression from the pictures I had uploaded. To get the date that is -30 days we use:

Adddays(utcnow(),-30,’yyyy-MM-dd’)

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
sutekh 509 on at

Like
a
(0)

Report
Copy link

Link copied!

I made the change and when I set the condition to equal it runs but I don't get any alerts. Anything other condition just returns everything.

This is how I've got it set up:

Compose Day:
formatDateTime(utcNow(),'yyyy-MM-dd')

Compose Expiry Date:
Expiry Date

Compose Review Date:
addDays(utcNow(),-30,'yyyy-MM-dd')

Compose
formatDateTime(outputs('Compose_ReviewDate'),'yyyy-MM-dd')

Condition
Compose is equal to Compose Expiry Date

Where am I going wrong?
sutekh 509 on at

Like
a
(0)

Report
Copy link

Link copied!

The Compose Expiry Date for every item is coming through as: 2020-12-06 ?