How to add a day to a formatedatetime() and ConvertfromUTC() formula.

Like (0) Share

Report

Posted on 27 Sep 2023 13:19:59 by melf123

106

Hi everyone,

I have a flow that's picking up items from a SharePoint list according to the date listed in the date column, in this case it'll be picking up any dates that are a day after the current date.

This is my current formula:

addDays(formatdatetime(ConvertfromUTC(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-dd', 1)).

I keep getting the error: The execution of template action 'Filter_array_2' failed: The evaluation of 'query' action 'where' expression '@equals(item()?['field_1'], addDays(formatdatetime(ConvertfromUTC(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-dd', 1)))' failed: 'The template language function 'formatdatetime' expects its third parameter to be of type string. The provided value is of type 'Integer'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Can someone please lead me into the right direction?

All responses (1)

Answers (0)

Chriddle 7,932 Super User 2025 Season 2 on 27 Sep 2023 at 15:52:12

Like (1)

Report
Re: How to add a day to a formatedatetime() and ConvertfromUTC() formula.

Don't use formatDateTime at all 😉

The date functions accept a format string.

convertFromUtc(addDays(utcNow(), 1), 'Eastern Standard Time', 'yyyy-MM-dd')

The brackets are positioned incorrectly in your expression.