
Announcements
Hi guys,
Hope you are well. I'm trying to extract an outlook calendar on excel. Everything is working well when choosing a specific date (for example monday 8th of april). However, as i don't want to go to edit my flow every week, I want the action to get the calendar data from outlook to retrieve data from the current week.
Chat GPT is telling me to input the following:
formatDateTime(startOfWeek(utcNow()), 'yyyy-MM-ddT00:00:00') (see screenshot attached)
and this for the end of the week:
formatDateTime(addDays(startOfWeek(utcNow()), 4), 'yyyy-MM-ddT23:59:59')
Any idea why this is not working?
There is no startOfWeek expression in Power Automate.
Here is a link to a post of mine from a while ago that shows how to determine the start and end of a week.