add days to sharepoint list date element

[Enrico1109]

Hey all,

may just a small and simple problem.

I made a date element (called "date of shipping) in my sharepoint list and want to give myself a reminder if the date is 14 days ahead.

I need a condition and wrote this:

"date of shipping" is equal addDays(utcNow(),14)

This is not working.

any slutions?

Thanks 🙂

[JohnAageAnderse]

Hello @Enrico1109 

My guess is that your datetime column contains only a date. The expression you are comparing with is a datetime that contains both date and time. To ensure that your date values are in a comparable format, use the formatDatetime expression for both dates.

Example:

formatDatetime(<shipping date>, 'yyyy-MM-dd') is equal to formatDatetime(addDays(utcNow(), 14), 'yyyy-MM-dd')

Are you sure that you want to compare the shipping date with a date 14 days into the future? Or should it be that you want to be notified when there are 14 days till the shipping date? If the later, then the 14 should be a -14 🙂

Kind regards, John

[Enrico1109]

Hello @JohnAageAnderse ,

thank you for your fast answer, 

I named the column "shipping date" but yur solution doesn´t work.

It says: The expression is invalid.

May I need to change something in the sharepoint list settings ?

Thank You

[JohnAageAnderse]

Hello @Enrico1109 

What I wrote was an example 🙂 You have to replace <shipping date> with your column.

In your Condition action you have to use two expressions:

formatDateTime(body('Get_item')?['Created'],'yyyy-MM-dd') - I am using Created as my date column from the list

is equal to

formatDateTime(addDays(utcNow(),-14),'yyyy-MM-dd') - I am using -14 as I want to be notified 14 days before

Kind regards, John

[v-alzhan-msft]

Hi @Enrico1109 ,

Could you please share a screenshot of the configuration of your flow.

Please make sure the "shipping date" is new created column (not a updated name column).

If the flow as screenshot below:

The expression should as below:

formatDateTime(items('Apply_to_each')?['shippingdate'],'yyyy-MM-dd')

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

If the flow as below:

The expression should as below:

formatDateTime(triggerBody()?['shippingdate'],'yyyy-MM-dd')

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

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Enrico1109]

Hey @v-alzhan-msft 

Thank you for your help

My Power Automate is in German, I hope you can understand it.

formatDateTime(body('Elemente_abrufen')?['AnkunftderWare'])

is euqual to

formatDateTime(addDays(utcNow(),14))

The column is new created.

Thank you

Best regards,

Enrico

[v-alzhan-msft]

Hi @Enrico1109 ,

Create the flow as below:

The expression should as below:

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

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

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Enrico1109]

@v-alzhan-msft 

It shows me this error:

 In text:

InvalidTemplate. Vorlagensprachausdrücke für Aktion "Bedingung" in Zeile "1" und Spalte "2877" können nicht verarbeitet werden: Die Vorlagensprachfunktion "formatDateTime" erwartet als ersten Parameter einen Parameter vom Typ "string". Der angegebene Wert ist vom Typ "Null". Details zur Syntax finden Sie unter https://aka.ms/logicexpressions#formatdatetime..

[v-alzhan-msft · Accepted solution]

Hi @Enrico1109 ,

Make sure the date column wouldn't be null in the list.

Or create the flow with condition to check if the date column is null as below:

empty(outputs('Compose'))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Enrico1109]

It worked 🙂 Thank you very much for your help

Best Regards

Enrico

[ASchwingel]

I know this is from a while back but I have been having this issue for a week now and adding the 
Compose finally helped. I was still getting the 'null' error message and I didn't want to add the second condition to remove nulls because my columns were not null. So instead I did this and it worked for me! (Use the Compose Output in the Condition)