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 ?

invalid expressio...

All responses (1)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (1)

Report
Re: Formula issue : always getting invalid expression

Hi @matthieudumont ,

Please try this expression:

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

Best Regards,

Sunshine Gu