Answered

Calculate week number, weekday, month eg.

(0) Share

Report

Posted on by TrulsB

144

Im using a model drive app. In the Entity there is a data Field: Orderdate. The order day today is 4.11.2020 (November, 4th - Norwegian format)

I like to add Fields With week number, day in week, day in week in text (Wednesday) and also month name.

Orderdate: 4.11.2020

Week number: 45

Day in week: 3 (starts With 1 on monday)

Weekdayname: Wednesday

Monthname: November

Any idea how this values can be added to the actual Field based on "Order date"?

(It seems easy in Canvas app", but only model driven app is in use.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @TrulsB,
Unfortunately on model driven apps those same formulas are not available. Creating a plugin would be a good option, using the Calendar class of the .NET framework.
Some useful references below:
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/tutorial-write-plug-in
https://docs.microsoft.com/en-us/dotnet/api/system.globalization.calendar.getweekofyear?view=netframework-4.6.2
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
TrulsB 144 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you !
Your suggestion seems be requiere knowledge in Visual Studio, C Programming eg.
Do you have any other suggestions? Do you know of somwhere to download plug-ins for week and day calculation? Any experience using Power Automate to do this calculations and update when a record is changed ?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @TrulsB :

It can be inplemented with flow.I'v made a test for your reference:

Formula reference:

Switch On:

dayOfWeek(triggerOutputs()?['body/crba2_orderdate'])

Day in week:

dayOfWeek(triggerOutputs()?['body/crba2_orderdate'])

Monthname:

formatDateTime(triggerOutputs()?['body/crba2_orderdate'],'MMMM')

Week number:

add(div(dayOfYear(triggerOutputs()?['body/crba2_orderdate']), 7),1)

Weekdayname:

Variables('WeekName')

Best Regards,

Bof

Was this reply helpful? Yes No
TrulsB 144 on at

Like (0)

Report
Copy link

Link copied!

Thanks, perfecet !!

Was this reply helpful? Yes No
TrulsB 144 on at

Like (0)

Report
Copy link

Link copied!

Just an additional question. Everything Works well, but when i remove the date in the date Field in Model Drive app, and save - whe flow runs - but the Fields for Week number, days in week, weekday name eg is no cleared or reset. The values for the last date are still there, even if the date Field is empty. Any idea how to handel this, so every Fields are empty of the Orderdate Field is empty. ?

Was this reply helpful? Yes No