web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Formula issue : always...

Power Automate

Answered

Formula issue : always getting invalid expression

(0) Share

Report

Report

Posted on by matthieudumont

26

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 expression.png

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Join the conversation