Hi all, Is it possible to calculate the week beginning from a Start Time received from an excel column using power automate?
I have a number of users that complete a form every week this is stored in an Excel sheet, I have a 'Start time' Column in this sheet and am looking to be able to split the comments by week beginning and add / update in a SharePoint list.
I have originally got the flow to work by completing this formula in excel using the following formula=[@[Start time]]-MOD([@[Start time]]-5,7).
However my flow fails every time with the last input on the 'Apply to each' with an invalid date of -2. is this because the spreadsheet needs to be opened to update or should this be done on the flow?
"item/Response_x0020_ID":"98","item/WeekBeginning":"1899-12-28","item/Comments":"Invalid date","item/Score":"6"}}
Thats great! If you please link the article here, others might benefit from it.
I've got this resolved, I found a video on Youtube by DamoBird365 which fully explained the expressions and filter arrays.
Hi @SudeepGhatakNZ,
Apologies but i'm new to Power automate and don't quite fully understand the processes, below is the formula i have been using, i have calculated the week number now but can't calculate a week beginning from it it states the expression is invalid I have tested both the addDays and the dayOfWeek expressions individually and they work its just when i try to pass the start time into it, it just falls over
You should use date expressions in Power Automate instead of adding a formula in excel.
You can achieve the same expression in Power Automate.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2