Formula issue : always getting invalid expression

(0) Share

Report

Posted on by matthieudumont

Hello, I am using the action "Get calendar view of events (v3) and i'm trying to export on excel all calendar events that happened during last week. For the start time works ok, for the end time, i tried inserting this formula:

addDays(utcNow(), -1 * (dayOfWeek(utcNow()) + 1), 'yyyy-MM-ddT23:59:59')

But the action says it's invalid. I'm now pretty sure it's not the formula itself but a problem with the webapp as every new suggestion from CHAT GPT does not work and is always saying "invalid".

Any idea ?

Categories:

Using flows

invalid expressio...

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @matthieudumont ,

Please try this expression:

addDays(utcNow(),mul(add(dayOfWeek(utcNow()),1),-1), 'yyyy-MM-ddT23:59:59')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No