web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Weekday of Date in Dat...

Power Apps

Answered

Weekday of Date in Dataverse table of Model Driven Forms

(1) Share

Report

Report

Posted on by SG013

74

HI

I need to create a calculated column with the below formula in Dataverse column

Case(DayOfWeek([Date]),
0, "Sunday",
1, "Monday",
2, "Tuesday",
3, "Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday")

Date: Time zone issue.

Can you please guide me how can i achieve the above in Model driven app or dataverse table calculated column.

Many Thanks

SG

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Jonathan Manrique 2,687 on at

Like (1)

Report
Copy link

Link copied!
Hi @SG013

I used Power FX in the Dataverse formula columns.

The first thing is that this date column must have the format in the "Time Zona Adjustament" property only in Date Only for the formula to work.

Then you can use the following formula

If(Weekday(Fecha)=1,"Sunday",If(Weekday(Fecha)=2,"Monday",If(Weekday(Fecha)=3,"Tuesday")))

Was this reply helpful? Yes No

Join the conversation