Unanswered

Power Fx: Calculate Weekday Hours

(0) Share

Report

Posted on by SBX

Hi All,

I’m trying to add a column within my table (Dataverse) using formula which would work out the weekday hours. Unfornatley, it’s not liking the formula I’ve input giving me an error.

Error: Invalid argument type (Decimal). Expecting a Enum (StartOfWeek) value instead.

Formula: If(Or(Weekday('Start Time',2)<>6,Weekday('Start Time',2)<>7),DateDiff('Start Time','End Time',TimeUnit.Hours),0)

Data Types: 'Start Time' – Date/Time, 'End Time' – Date/Time

Does anyone know how to fix this? Any help would be appreciated!
Thanks, SBX

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
HI @SBX,

I have tested it on my side, and it works,

I think maybe you should replace the number with the parameter named with StartOfWeek.

Check this:

Weekday('Start Time',StartOfWeek.Monday)

Was this reply helpful? Yes No
SBX 4 on at

Like (0)

Report

Thanks Qi,
This is for a model driven app using the Dataverse. I’m trying to enter this calculated column in a table within the Dataverse.
Weekday('Start Time',StartOfWeek.Monday) – I’ve already tried this it wont work.

Was this reply helpful? Yes No
Rusty2 on at

Like (0)

Report

I am having the same issue.
In the documentation for this formula here Work with Dataverse formula columns - Power Apps | Microsoft Learn
It says: * StartOfWeek argument isn't supported for the WeekNum and Weekday functions in formula columns.
So what is the solution to find the week beginning or ending a certain date?
I've tried:
Now() + (7 - Weekday(Now(), 0)) - it errors on the 0 saying Invalid argument type (Decimal). Expecting a Enum (StartOfWeek) value instead.
Now() + (7 - Weekday(Now(), StartOfWeek.Sunday)) - errors on the Sunday saying The start_of_week argument is not supported for the Weekday function in formula columns.

So we cannot use Weekday, Weeknum or StartOfWeek in these formulas.

I also looked at using calculated columns but have the same issues

Was this reply helpful? Yes No
yogimoyyila 2 on at

Like (0)

Report

I have timestamp "7/8/2024 2:51 PM" i need to identify the which weekday of the current timestamp(like Monday, Tuesday) tried multiple ways as mentioned above but nothing worked. please suggest me the way to identify the weekday from the timestamp column.
Link below for dataverse doc
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#guidelines-and-limitations

Was this reply helpful? Yes No